| Error in listener.ora file [message #267635] |
Fri, 14 September 2007 01:03  |
rolex.mp
Messages: 161
Registered: February 2007
|
Senior Member |
|
|
I am installing Oracle 11g in Unix and I am using a different port number for the listener since the default port number is already in use .
My listener.ora looks like this
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=adorcl)
(ORACLE_HOME=/SLOTS/slot04/appmgr/pramohan/Ora11g_Home))
(SID_DESC=
(SID_NAME=PLSExtProc)
(ORACLE_HOME=/SLOTS/slot04/appmgr/pramohan/Ora11g_Home)
(PROGRAM=extproc)))
LISTENER_ADORCL=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=a_server_name.us.oracle.com)(PORT=1521))
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))))
When I start this listener I get this erro
TNS-01150: The address of the specified listener name is incorrect
NL-00303: syntax error in NV string
Let me know what changes has to be done
[Mod-Edit: changed servername]
[Updated on: Fri, 14 September 2007 01:35] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Error in listener.ora file [message #267928 is a reply to message #267635] |
Sun, 16 September 2007 09:35  |
naveenmelbourne
Messages: 15
Registered: August 2007
|
Junior Member |
|
|
Replace your Listener Description block with this and try...
LISTENER_ADORCL=
(DISCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=a_server_name.us.oracle.com)(PORT=1521))
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))))
Let me know .... what happened
Regards
Naveen
[Updated on: Sun, 16 September 2007 10:06] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
