-
listener error
Hi Friends,
I cannot startup my listener when i run "lsnrctl start"
I got these errors:
===============
LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 26-JUN-2008 18:26:45
Copyright (c) 1991, 2006, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCPROD))
TNS-12560: TNSrotocol adapter error
TNS-00530: Protocol adapter error
Linux Error: 20: Not a directory
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=orasvr1.abc.net.ph)(Port=1521))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 26-JUN-2008 18:26:45
Copyright (c) 1991, 2006, Oracle. All rights reserved.
Starting /u02/oracle/PROD/db/tech_st/10.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.3.0 - Production
System parameter file is /u02/oracle/PROD/db/tech_st/10.2.0/network/admin/PROD_orasvr1/listener.ora
Log messages written to /u02/oracle/PROD/db/tech_st/10.2.0/network/admin/prod.log
Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCPROD))
TNS-12560: TNSrotocol adapter error
TNS-00530: Protocol adapter error
Linux Error: 20: Not a directory
Listener failed to start. See the error message(s) above...
LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 26-JUN-2008 18:26:45
Copyright (c) 1991, 2006, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCPROD))
TNS-12560: TNSrotocol adapter error
TNS-00530: Protocol adapter error
Linux Error: 20: Not a directory
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=orasvr1.abc.net.ph)(Port=1521))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 26-JUN-2008 18:26:45
Copyright (c) 1991, 2006, Oracle. All rights reserved.
Starting /u02/oracle/PROD/db/tech_st/10.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.3.0 - Production
System parameter file is /u02/oracle/PROD/db/tech_st/10.2.0/network/admin/PROD_orasvr1/listener.ora
Log messages written to /u02/oracle/PROD/db/tech_st/10.2.0/network/admin/prod.log
Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCPROD))
TNS-12560: TNSrotocol adapter error
TNS-00530: Protocol adapter error
Linux Error: 20: Not a directory
Listener failed to start. See the error message(s) above...
Please help me....thanks a lot
Last edited by reeshe; 06-30-2008 at 06:12 AM.
-
post the listener.ora - it has errors
-
Thanks Dave ...why do I get dir error? >Linux Error: 20: Not a directory
Which line was it?
My listener.ora...bow
================
#
# Net8 definition for Database listener
#
PROD =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= EXTPROCPROD))
(ADDRESS= (PROTOCOL= TCP)(Host= orasvr1.abc.net.ph )(Port= 1521))
)
SID_LIST_PROD =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME= /u02/oracle/PROD/db/tech_st/10.2.0)
(SID_NAME = PROD)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u02/oracle/PROD/db/tech_st/10.2.0)
(PROGRAM = extproc)
)
)
STARTUP_WAIT_TIME_PROD = 0
CONNECT_TIMEOUT_PROD = 10
TRACE_LEVEL_PROD = OFF
LOG_DIRECTORY_PROD = /u02/oracle/PROD/db/tech_st/10.2.0/network/admin
LOG_FILE_PROD = PROD
TRACE_DIRECTORY_PROD = /u02/oracle/PROD/db/tech_st/10.2.0/network/admin
TRACE_FILE_PROD = PROD
ADMIN_RESTRICTIONS_PROD = OFF
SUBSCRIBE_FOR_NODE_DOWN_EVENT_PROD = OFF
IFILE=/u02/oracle/PROD/db/tech_st/10.2.0/network/admin/PROD_orasvr1/listener_ifile.ora
===== end
My /etc/hosts
===========
127.0.0.1 localhost.localdomain localhost
119.111.9.48 orasvr1.abc.net.ph orasvr1
I can ping > orasvr1.abc.net.ph
Last edited by reeshe; 06-29-2008 at 06:16 AM.
-
did you try replacing hostname by ip?
Listener.ora shows (ADDRESS= (PROTOCOL= TCP)(Host= orasvr1.abc.net.ph )(Port= 1521))
whereas the error message shows :
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=orasvr1.prime.net.ph)(Port=1521))
HTH,
gtcol
-
Originally Posted by gtcol
did you try replacing hostname by ip?
Listener.ora shows (ADDRESS= (PROTOCOL= TCP)(Host= orasvr1.abc.net.ph )(Port= 1521))
whereas the error message shows :
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=orasvr1.prime.net.ph)(Port=1521))
As stated Poster can ping the host name, what are you planning to solve by replacing hostname by IP address?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
i just got confused with these two different hosts in two different locations.
listener.ora: (Host= orasvr1.abc.net.ph )
error msg: (Host=orasvr1.prime.net.ph)
gtcol
-
hi....thats for confidentiality i used abc instead of prime....just forget the prime thing.
So...any ideas please what is missing with listener.ora
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|