Home » RDBMS Server » Networking and Gateways » Error in listener.ora file
Error in listener.ora file [message #267635] Fri, 14 September 2007 01:03 Go to next message
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 #267645 is a reply to message #267635] Fri, 14 September 2007 01:34 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Are you on the oracle network?
I changed the servername. NEVER publish servernames on an internet page!!

[Updated on: Fri, 14 September 2007 01:35]

Report message to a moderator

Re: Error in listener.ora file [message #267648 is a reply to message #267645] Fri, 14 September 2007 01:44 Go to previous messageGo to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
ok sorry for that

Let me know what changes has to be done to the listener.ora file .

Re: Error in listener.ora file [message #267873 is a reply to message #267635] Sat, 15 September 2007 22:05 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Remove Address_list Parameter from file.
Re: Error in listener.ora file [message #267928 is a reply to message #267635] Sun, 16 September 2007 09:35 Go to previous message
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

Previous Topic: Regarding ORA-00119 error
Next Topic: can't stopping Listener
Goto Forum:
  


Current Time: Sat Dec 10 05:07:57 CST 2016

Total time taken to generate the page: 0.06761 seconds