TNS-01151: Missing listener name, orcl (2 threads merged by bb) [message #492907] |
Thu, 03 February 2011 10:46 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
piduruviswa
Messages: 12 Registered: May 2007 Location: Singapore
|
Junior Member |
|
|
Hi All,
I'm having issues starting listener with the listener name on Oracle server. I'm able to start it with out listener with out the name. I have searched lot of forums but not helped in resolving this issue. Appreciate any help.
Oracle version
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit
[oracle@dw9 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dw9)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
[oracle@dw9 admin]$ cat listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC=
(GLOBAL_DBNAME=CIS)
(ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1)
(SID_NAME=ORCL))
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dw9)(PORT = 1521))
)
)
[oracle@dw9 admin]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 03-FEB-2011 08:30:02
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /home/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /home/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dw9)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dw9)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 03-FEB-2011 08:30:02
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /home/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dw9)(PORT=1521)))
Services Summary...
Service "CIS" has 1 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@dw9 admin]$ tnsping orcl
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 03-FEB-2011 08:33:35
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/home/oracle/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dw9)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL)))
OK (0 msec)
[oracle@dw9 admin]$ lsnrctl stop
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 03-FEB-2011 08:32:11
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dw9)(PORT=1521)))
The command completed successfully
[oracle@dw9 admin]$ lsnrctl start orcl
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 03-FEB-2011 08:34:18
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /home/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /home/oracle/oracle/product/10.2.0/db_1/network/log/orcl.log
TNS-01151: Missing listener name, orcl, in LISTENER.ORA
Listener failed to start. See the error message(s) above...
[oracle@dw9 admin]$ sqlplus system/oracle@orcl
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 3 08:35:05 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@dw9 admin]$ sqlplus system/oracle
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 3 08:35:23 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Thanks in advance for your help
|
|
|
Re: TNS-01151: Missing listener name, orcl [message #492910 is a reply to message #492907] |
Thu, 03 February 2011 10:52 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/42800.jpg) |
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
First, You have not named the listener to start it with a name.
>>lsnrctl start orcl
For above to work, you first need to name the listener as orcl.
Here is an example with the listener named as "prod" that
handles connection for database instance "prod"
oracle@jinx#cat listener.ora
prod =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = jinx)(PORT = 1521))
)
)
SID_LIST_prod =
(SID_LIST =
(SID_DESC =
(SID_NAME = prod)
(ORACLE_HOME = /u01/home)
)
)
oracle@jinx#lsnrctl start prod
LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 03-FEB-2011 11:54:36
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /u01/base/product/11.2.0/home/bin/tnslsnr: please wait...
TNSLSNR for Solaris: Version 11.2.0.1.0 - Production
System parameter file is /u01/base/product/11.2.0/home/network/admin/listener.ora
Log messages written to /u01/base/diag/tnslsnr/jinx/prod/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jinx)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jinx)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias prod
Version TNSLSNR for Solaris: Version 11.2.0.1.0 - Production
Start Date 03-FEB-2011 11:54:36
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/base/product/11.2.0/home/network/admin/listener.ora
Listener Log File /u01/base/diag/tnslsnr/jinx/prod/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jinx)(PORT=1521)))
Services Summary...
Service "prod" has 1 instance(s).
Instance "prod", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[Updated on: Thu, 03 February 2011 10:58] Report message to a moderator
|
|
|
Re: TNS-01151: Missing listener name, orcl [message #492911 is a reply to message #492907] |
Thu, 03 February 2011 10:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
You seem to be confusing listeners with tnsnames.
tnsnames.ora defines the list of dbs/services the listener can connect to.
listener.ora defines the list of listeners.
The error messages do point that out:
TNS-01151: Missing listener name, orcl, in LISTENER.ORA
|
|
|
|
Re: TNS-01151: Missing listener name, orcl [message #492915 is a reply to message #492910] |
Thu, 03 February 2011 11:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
piduruviswa
Messages: 12 Registered: May 2007 Location: Singapore
|
Junior Member |
|
|
Hi Mahesh,
After changing the listener.ora I'm able to start with listener name but getting different error while starting sqlplus
[oracle@dw9 admin]$ lsnrctl start orcl
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 03-FEB-2011 09:31:18
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /home/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /home/oracle/oracle/product/10.2.0/db_1/network/log/orcl.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dw9)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dw9)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias orcl
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 03-FEB-2011 09:31:18
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /home/oracle/oracle/product/10.2.0/db_1/network/log/orcl.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dw9)(PORT=1521)))
Services Summary...
Service "ORCL" has 1 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@dw9 admin]$ sqlplus system/oracle@orcl
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 3 09:31:25 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
[oracle@dw9 admin]$ sqlplus system/oracle
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 3 09:32:31 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
|
|
|
|
|
|
Re: TNS-01151: Missing listener name, orcl [message #492924 is a reply to message #492920] |
Thu, 03 February 2011 11:54 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
piduruviswa
Messages: 12 Registered: May 2007 Location: Singapore
|
Junior Member |
|
|
Hi Mahesh,
Instance is UP.
[oracle@dw9 admin]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 3 09:50:12 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> select status from v$instance;
STATUS
------------
OPEN
[oracle@dw9 admin]$ ps -ef | grep smon
oracle 11866 1 0 09:29 ? 00:00:00 ora_smon_cis
oracle 11945 11206 0 09:48 pts/1 00:00:00 grep smon
[Updated on: Thu, 03 February 2011 11:55] Report message to a moderator
|
|
|
|
Re: TNS-01151: Missing listener name, orcl [message #492927 is a reply to message #492924] |
Thu, 03 February 2011 12:05 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/42800.jpg) |
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
And to add,
I was expecting to see an instance named ORCL, because your Tnsnames.ora entry ORCL is looking into ORCL not "cis".
Quote:
[oracle@dw9 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dw9)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)
In other words, you tnsentries are wrong. It is looking into non-existing instance.
[Updated on: Thu, 03 February 2011 12:11] Report message to a moderator
|
|
|
|