Nl-00303 Syntax Error In Nv String
Contents |
in listner If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 11 Thread: problem in listner Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 06-23-2008,06:15 AM #1 http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=69141&DestinationA=RSS gopu_g View Profile View Forum Posts Senior Member Join Date Aug 2007 Location Cyberjaya,kuala lumpur Posts 340 problem in listner I am not able to startup the listner, earlier it was running fine and i did't alter the listner file also.but when i shut down the db and started the listner i am getting this error. TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA NL-00303: syntax error in http://www.dbasupport.com/forums/showthread.php?58172-problem-in-listner NV string this is my listner.ora file # LISTENER.ORA Network Configuration File: /oracle/u01/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = blrgesun)(PORT = 1521)) ) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /oracle/u01) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = blrgeora) (ORACLE_HOME = /oracle/u01) (SID_NAME = blrgeora) ) ) Thanks in advance Reply With Quote 06-23-2008,07:40 AM #2 muzammil.dba View Profile View Forum Posts Junior Member Join Date May 2008 Posts 95 try to check status of ur listener $ lsnrctl status Reply With Quote 06-23-2008,07:46 AM #3 muzammil.dba View Profile View Forum Posts Junior Member Join Date May 2008 Posts 95 You need to re-create the listener.ora using the Net8 Assistant/netca Reply With Quote 06-23-2008,08:07 AM #4 gopu_g View Profile View Forum Posts Senior Member Join Date Aug 2007 Location Cyberjaya,kuala lumpur Posts 340 Originally Posted by muzammil.dba try to check status of ur listener $ lsnrctl status the listner is not up... when i try to startup i got that error . Reply With Quote 06-23-2008,08:08 AM
to friend TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA [message #260710] Mon, 20 August 2007 14:44 niravana Messages: 6Registered: July 2007 http://www.orafaq.com/forum/t/87764/2/ Location: Bangladesh Junior Member i dont have any idea http://harvarinder.blogspot.com/2011/04/tns-01150-address-of-specified-listener.html 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 syntax error 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 syntax error in #260710] Mon, 20 August 2007 15:05 Michel Cadot Messages: 63908Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount 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: 1554Registered: 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_LIST
error that I am getting while starting the listener: $ lsnrctl start listener LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 20-APR-2011 06:06:46 Copyright (c) 1991, 2010, Oracle. All rights reserved. Starting /u01/app/oracle/product/11.2.0.2/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.2.0 - Production System parameter file is /u01/app/oracle/product/11.2.0.2/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/jeetdev/listener/alert/log.xml TNS-01150: The address of the specified listener name is incorrect Listener failed to start. See the error message(s) above... $ $ lsnrctl status listener LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 20-APR-2011 06:16:46 Copyright (c) 1991, 2010, Oracle. All rights reserved. TNS-01150: The address of the specified listener name is incorrect NL-00303: syntax error in NV string $ In order to check on what is happening my first check would be to see if the listener.ora file have got the correct information and check if the opening and closing brackets are present. My current listener file is: LISTENER= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=jeetdev)(PORT=1521)) ) SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (ORACLE_HOME=/u01/app/oracle/product/11.2.0.2) (SID_NAME=orcl)) ) ADR_BASE_LISTENER = /u01/app/oracle I have observed that there is a missing closing bracket in LISTENER for DESCRIPTION. What I have done is added that closing bracket and saved the listener file and then tried starting the listener again. $ lsnrctl status listener LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 20-APR-2011 06:17:20 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jeetdev)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused $ $ lsnrctl start listener LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 20-APR-2011 06:17:26 Copyright (c) 1991, 2010, Oracle. All rights reserved. Starting /u01/app/oracle/product/11.2.0.2/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.2.0 - Production System parameter file is /u01/app/oracle/product/11.2.0.2/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/