tomvv
asked on
lsnrctl
my listener not starting
this is /etc/host file
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localdomain
192.168.1.12 mac.localdomain mac
192.168.1.16 wtu.localdomain wtu
wtu is another machine...
which we can ping from mac machine..
my tnsnames.ora of mac is this
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11 .2.0/db_1/ network/ad min/tnsnam es.ora
# Generated by Oracle configuration tool
SBI =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mac.localdomain)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =sbi)
)
)
LISTENER_SBI =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL= TCP) (HOST = mac.localdomain)(PORT = 1521))
(ADDRESS = (PROTOCOL= TCP) (HOST = localhost)(PORT = 1521))
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mac.localdomain)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =orcl)
)
)
LISTENER_ORCL =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL= TCP)(HOST = wtu.localdomain)(PORT = 1521))
(ADDRESS = (PROTOCOL= TCP)(HOST = localhost)(PORT = 1521))
)
my lister.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11 .2.0/db_1/ network/ad min/listen er.ora
# Generated by Oracle configuration tools.
LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcl.localdomain)(PORT = 1521))
)
)
ADR_BASE_LISTENER1 = /u01/app/oracle
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = orcl.localdomain)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
~
~
~
~
~
~
~
~
why my lsnrctl is like this...
[oracle@mac admin]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-SEP-2012 12:43:27
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PRO TOCOL=IPC) (KEY=EXTPR OC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PRO TOCOL=TCP) (HOST=orcl .localdoma in)(PORT=1 521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
Linux Error: 111: Connection refused
[oracle@mac admin]$
this is /etc/host file
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localdomain
192.168.1.12 mac.localdomain mac
192.168.1.16 wtu.localdomain wtu
wtu is another machine...
which we can ping from mac machine..
my tnsnames.ora of mac is this
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11
# Generated by Oracle configuration tool
SBI =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mac.localdomain)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =sbi)
)
)
LISTENER_SBI =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL= TCP) (HOST = mac.localdomain)(PORT = 1521))
(ADDRESS = (PROTOCOL= TCP) (HOST = localhost)(PORT = 1521))
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mac.localdomain)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =orcl)
)
)
LISTENER_ORCL =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL= TCP)(HOST = wtu.localdomain)(PORT = 1521))
(ADDRESS = (PROTOCOL= TCP)(HOST = localhost)(PORT = 1521))
)
my lister.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11
# Generated by Oracle configuration tools.
LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcl.localdomain)(PORT = 1521))
)
)
ADR_BASE_LISTENER1 = /u01/app/oracle
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = orcl.localdomain)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
~
~
~
~
~
~
~
~
why my lsnrctl is like this...
[oracle@mac admin]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-SEP-2012 12:43:27
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PRO
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PRO
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
Linux Error: 111: Connection refused
[oracle@mac admin]$
Your Host doesn't exist, or its name is not orcl.localdomain. Try to use IP address for host in listener definition.
>>wtu is another machine...
What server has the database? The listener is only for the database server.
What is the error when you try to start the listener?
What server has the database? The listener is only for the database server.
What is the error when you try to start the listener?
ASKER
mac sever
[oracle@mac ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2012 00:42:52
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11 .2.0/db_1/ bin/tnslsn r: please wait...
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11 .2.0/db_1/ network/ad min/listen er.ora
Log messages written to /u01/app/oracle/diag/tnsls nr/mac/lis tener/aler t/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PRO TOCOL=ipc) (KEY=EXTPR OC1521)))
Error listening on: (DESCRIPTION=(ADDRESS=(PRO TOCOL=TCP) (HOST=orcl .localdoma in)(PORT=1 521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
Linux Error: 111: Connection refused
Listener failed to start. See the error message(s) above...
[oracle@mac ~]$
[oracle@mac ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2012 00:42:52
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11
Log messages written to /u01/app/oracle/diag/tnsls
Listening on: (DESCRIPTION=(ADDRESS=(PRO
Error listening on: (DESCRIPTION=(ADDRESS=(PRO
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
Linux Error: 111: Connection refused
Listener failed to start. See the error message(s) above...
[oracle@mac ~]$
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
slightvv please excuse my ignorance..
here is my new listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11 .2.0/db_1/ network/ad min/listen er.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1521))
)
)
This is the tnsnames.ora I already have
SBI =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =sbi)
)
)
LISTENER_SBI =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL= TCP) (HOST = 192.168.1.12)(PORT = 1521))
(ADDRESS = (PROTOCOL= TCP) (HOST = localhost)(PORT = 1521))
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =orcl)
)
)
LISTENER_ORCL =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL= TCP)(HOST = 192.168.1.12)(PORT = 1521))
(ADDRESS = (PROTOCOL= TCP)(HOST = localhost)(PORT = 1521))
)
still problem...
[oracle@mac admin]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2012 11:30:00
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PRO TOCOL=IPC) (KEY=EXTPR OC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PRO TOCOL=TCP) (HOST=192. 168.1.12)( PORT=1521) ))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@mac admin]$ lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2012 11:30:08
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PRO TOCOL=IPC) (KEY=EXTPR OC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PRO TOCOL=TCP) (HOST=192. 168.1.12)( PORT=1521) ))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@mac admin]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2012 11:30:14
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11 .2.0/db_1/ bin/tnslsn r: please wait...
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
Linux Error: 29: Illegal seek
[oracle@mac admin]$
here is my new listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1521))
)
)
This is the tnsnames.ora I already have
SBI =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =sbi)
)
)
LISTENER_SBI =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL= TCP) (HOST = 192.168.1.12)(PORT = 1521))
(ADDRESS = (PROTOCOL= TCP) (HOST = localhost)(PORT = 1521))
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =orcl)
)
)
LISTENER_ORCL =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL= TCP)(HOST = 192.168.1.12)(PORT = 1521))
(ADDRESS = (PROTOCOL= TCP)(HOST = localhost)(PORT = 1521))
)
still problem...
[oracle@mac admin]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2012 11:30:00
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PRO
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PRO
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@mac admin]$ lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2012 11:30:08
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PRO
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PRO
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@mac admin]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2012 11:30:14
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
Linux Error: 29: Illegal seek
[oracle@mac admin]$
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
wow what a magic
working fine
is this applicable to all versions of oracle..
[oracle@mac admin]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2012 16:38:04
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11 .2.0/db_1/ bin/tnslsn r: please wait...
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11 .2.0/db_1/ network/ad min/listen er.ora
Log messages written to /u01/app/oracle/diag/tnsls nr/mac/lis tener/aler t/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PRO TOCOL=ipc) (KEY=EXTPR OC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PRO TOCOL=tcp) (HOST=192. 168.1.12)( PORT=1521) ))
Connecting to (DESCRIPTION=(ADDRESS=(PRO TOCOL=IPC) (KEY=EXTPR OC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 18-SEP-2012 16:38:05
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11 .2.0/db_1/ network/ad min/listen er.ora
Listener Log File /u01/app/oracle/diag/tnsls nr/mac/lis tener/aler t/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PRO TOCOL=ipc) (KEY=EXTPR OC1521)))
(DESCRIPTION=(ADDRESS=(PRO TOCOL=tcp) (HOST=192. 168.1.12)( PORT=1521) ))
The listener supports no services
The command completed successfully
[oracle@mac admin]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2012 16:38:18
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PRO TOCOL=IPC) (KEY=EXTPR OC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 18-SEP-2012 16:38:05
Uptime 0 days 0 hr. 0 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11 .2.0/db_1/ network/ad min/listen er.ora
Listener Log File /u01/app/oracle/diag/tnsls nr/mac/lis tener/aler t/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PRO TOCOL=ipc) (KEY=EXTPR OC1521)))
(DESCRIPTION=(ADDRESS=(PRO TOCOL=tcp) (HOST=192. 168.1.12)( PORT=1521) ))
The listener supports no services
The command completed successfully
[oracle@mac admin]$
working fine
is this applicable to all versions of oracle..
[oracle@mac admin]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2012 16:38:04
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11
Log messages written to /u01/app/oracle/diag/tnsls
Listening on: (DESCRIPTION=(ADDRESS=(PRO
Listening on: (DESCRIPTION=(ADDRESS=(PRO
Connecting to (DESCRIPTION=(ADDRESS=(PRO
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 18-SEP-2012 16:38:05
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11
Listener Log File /u01/app/oracle/diag/tnsls
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PRO
(DESCRIPTION=(ADDRESS=(PRO
The listener supports no services
The command completed successfully
[oracle@mac admin]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2012 16:38:18
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PRO
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 18-SEP-2012 16:38:05
Uptime 0 days 0 hr. 0 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11
Listener Log File /u01/app/oracle/diag/tnsls
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PRO
(DESCRIPTION=(ADDRESS=(PRO
The listener supports no services
The command completed successfully
[oracle@mac admin]$
Glad it's working. What one fixed it for you? Was it the host permissions or SUBSCRIBE_FOR_NODE_DOWN_EV ENT_LISTEN ER?
>>is this applicable to all versions of oracle..
Depends on what fixed it. If it was SUBSCRIBE_FOR_NODE_DOWN_EV ENT_LISTEN ER I'm thinking this is a Linux specific issue. I've been using Oracle for over 20 years on Windows and Unix (HP-UX) and have never heard about that parameter.
>>is this applicable to all versions of oracle..
Depends on what fixed it. If it was SUBSCRIBE_FOR_NODE_DOWN_EV
>>The listener supports no services
Now you just need to get the instances registered with the listener.
Either hard-code the instance in the listener.ora file or have the instance register with it using the local_listener spfile parameter or from a sqlplus prompt: alter system register;
Now you just need to get the instances registered with the listener.
Either hard-code the instance in the listener.ora file or have the instance register with it using the local_listener spfile parameter or from a sqlplus prompt: alter system register;
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for tomvv's comment #a38408480
for the following reason:
problem solved
Accepted answer: 0 points for tomvv's comment #a38408480
for the following reason:
problem solved
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.