-
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 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
-
try to check status of ur listener
$ lsnrctl status
-
You need to re-create the listener.ora using the Net8 Assistant/netca
-
 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 .
-
 Originally Posted by muzammil.dba
You need to re-create the listener.ora using the Net8 Assistant/netca
S.. i will recreate it. CAn you tell me why you suggest to recreate it.Is there any problem in the listner.ora file.wht is the casue for this error ?
-
couple of days back I face some problem, then I created Listener.ora file then its working file, that y i suggest you.
-
ya for me also the problem is solved, thanks for the solution,but i did't get what is the error in that.
-
The listener.ora file was copied from a previous version of Oracle.
The file contains different syntax for the database and environment
variables. When you try to use this file with Oracle v8.0.5, it
cannot understand the parameters listed in the listener.ora file.
-
i am not altered the listner,i shut down the db.and after starting up the database i tried to startup the listner, at that time i got that error.
and my db i oracle 9i
-
gopu_g,
One possibility is that your original listener.ora file got deleted from OS. And when you started the listener next time, it got created with default parameters, which weren't as per your original listener's parameters. It could also be that your original listener's name was something else from the default LISTENER.
HTH,
gtcol
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|