OraFAQ Forum: Networking and Gateways » TNS-01155: Incorrectly specified SID_LIST

Home » RDBMS Server » Networking and Gateways » TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA [message #260710]

Mon, 20 August 2007 14:44

niravana
Messages: 6
Registered: July 2007
Location: Bangladesh

Junior Member

i dont have any idea about this error...
when i am trying to start the listener showing these errors..

"TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
System parameter file is C:\oracleproduct\network\admin\listener.ora
Log messages written to C:\oracleproduct\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=joynul)(PORT=1521)))
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
NL-00303: syntax error in NV string"
i have checked the listener.ora file i have not got any error..
plzz help me out

Report message to a moderator

Re: TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA [message #260718 is a reply to message #260710]

Mon, 20 August 2007 15:05

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

But Oracle found one so double check.
Maybe you have non printable character.

Regards
Michel

Report message to a moderator

Re: TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA [message #260771 is a reply to message #260710]

Mon, 20 August 2007 21:49

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

i have checked the listener.ora file i have not got any error..

I can bet that the problem is in your listener.ora file. Oracle can't be able to read that file. Fix that file.

You can paste your listener.ora file and let us check where the error.

Or you manually can also check and what is the status of the listener?

Report message to a moderator

Re: TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA [message #261018 is a reply to message #260771]

Tue, 21 August 2007 09:29

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

TNS-01155:	Incorrectly specified SID_LIST_string parameter in LISTENER.ORA
Cause:	SID_LIST_<listener_name> in LISTENER.ORA has an error in it.
Action:	Be sure this parameter is specified as described 
in the Oracle9i Net Services Reference Guide.
 For example, SID_LIST_LISTENER = (SID_LIST=(SID_DESC=(SID_NAME=<sid>)(ORACLE_HOME=<oracle_home>)))

Report message to a moderator

Re: TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA [message #261574 is a reply to message #260710]

Thu, 23 August 2007 01:22

niravana
Messages: 6
Registered: July 2007
Location: Bangladesh

Junior Member

sorry for the delay .....
"
# LISTENER.ORA Network Configuration File: C:\oracleproduct\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = joynul)(PORT = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = C:\oracleproduct)
(SID_NAME = ORCL)
)
)
"

this is my listener.ora file ..plz check this out

i have tried all this but could not find out the solution

Report message to a moderator

Re: TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA [message #261583 is a reply to message #260710]

Thu, 23 August 2007 01:33

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Instead of your entry put this entry in your listener.ora file.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracleproduct)-- use ORACLE_HOME PATH HERE
      (PROGRAM = extproc)
    )
  )


LISTENER =
(DESCRIPTION_LIST=
(DESCRIPTION =
(ADDRESS=(PROTOCOL=IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = joynul)(PORT = 1521))
)

Now start the listener service.

Report message to a moderator

Re: TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA [message #261603 is a reply to message #260710]

Thu, 23 August 2007 02:04

niravana
Messages: 6
Registered: July 2007
Location: Bangladesh

Junior Member

i have tried this but its also giveing the error

"
LSNRCTL> status
TNS-01150: The address of the specified listener name is incorrect
NL-00303: syntax error in NV string
LSNRCTL>
"

Report message to a moderator

Re: TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA [message #261612 is a reply to message #260710]

Thu, 23 August 2007 02:22

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

With formatting put the entry of listener.ora
location, ORA_HOME, hostname.

Report message to a moderator

Re: TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA [message #261614 is a reply to message #260710]

Thu, 23 August 2007 02:24

niravana
Messages: 6
Registered: July 2007
Location: Bangladesh

Junior Member

ohhh also with my listener.ora
i have now created the new listener and now this showing this error...

Quote:

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=joynul)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
Start Date 23-AUG-2007 11:36:30
Uptime 0 days 1 hr. 43 min. 39 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File C:\oracleproduct\network\admin\listener.ora
Listener Log File C:\oracleproduct\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=joynul)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=joynul)(PORT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=joynul)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "hello.orcl.com" has 1 instance(s).
Instance "hello", status READY, has 1 handler(s) for this service...
Service "orcl" has 2 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> start
Starting tnslsnr: please wait...

Service OracleOraDb10g_home1TNSListener already running.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 1056: Unknown error
LSNRCTL>

Report message to a moderator