Home » RDBMS Server » Networking and Gateways » TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA [message #260710] Mon, 20 August 2007 14:44 Go to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But Oracle found one so double check.
Maybe you have non printable character.

Regards
Michel
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 Go to previous messageGo to next message
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?
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 Go to previous messageGo to next message
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>)))
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
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>
"
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 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

With formatting put the entry of listener.ora
location, ORA_HOME, hostname.
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 Go to previous messageGo to next message
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>
Re: TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA [message #261619 is a reply to message #260710] Thu, 23 August 2007 02:33 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

It seems everything now ok. Now connect to database.
sqlplus user/pass@joynul/orcl
Re: TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA [message #261620 is a reply to message #260710] Thu, 23 August 2007 02:34 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Hai Niravana are you from Bangladesh?
Re: TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA [message #261685 is a reply to message #261620] Thu, 23 August 2007 06:02 Go to previous messageGo to next message
niravana
Messages: 6
Registered: July 2007
Location: Bangladesh
Junior Member
yup ....i m from from bd and its dhaka
icon10.gif  Re: TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA [message #262288 is a reply to message #260710] Sun, 26 August 2007 00:54 Go to previous message
niravana
Messages: 6
Registered: July 2007
Location: Bangladesh
Junior Member
thanks to all for yours help....specially thanks to mr.arju
to reply me so quickly ...i have already solve the porblem
Previous Topic: Cannot access the port:8080
Next Topic: log file for connections
Goto Forum:
  


Current Time: Tue Dec 06 12:06:36 CST 2016

Total time taken to generate the page: 0.08768 seconds