Home » RDBMS Server » Networking and Gateways » ORA-02097,ORA-00119 and ORA-00119 (oracle 11g R2, solaris 10, single instance)
ORA-02097,ORA-00119 and ORA-00119 [message #577646] Tue, 19 February 2013 06:09 Go to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
hi ,
i am trying to chnage the default port number of listener but facing problems in instance registration. i did as follows:
1. stop the listener as lsnrctl stop (default listener).
2. chnage the listener.ora and tnsnames.ora with desire port numbers (1526) as follows:-
[code]
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.x)(PORT = 1526))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1526))
)
)

ADR_BASE_LISTENER = /u01/app/oracle


=========================================
MYLISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.x)PORT = 1526))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYLISTENER)
(SID_NAME = SID12)
)
)

{/code]


3. i start the listener as lsnrctl start so it was successfully started with a message that listener support no services
4. login to sqlplus an did following to register the instance

alter system set local_listener='MYLISTENEER' SCOPE=BOTH; and 
alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.x)PORT = 1526)';



but i get following error
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name '(ADDRESS = (PROTOCOL =
TCP)(HOST = x.x.x.x)PORT = 1526)




i search help from metalink as well but i didnt get the reason of aforsaid error and my instance is not registering

please help


Regards
Re: ORA-02097,ORA-00119 and ORA-00119 [message #577647 is a reply to message #577646] Tue, 19 February 2013 06:14 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Check your brackets.
Re: ORA-02097,ORA-00119 and ORA-00119 [message #577667 is a reply to message #577647] Tue, 19 February 2013 08:31 Go to previous messageGo to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
brackets checked, and ok . in above one bracket is missing which is mistake, any thing else sir
Re: ORA-02097,ORA-00119 and ORA-00119 [message #577668 is a reply to message #577667] Tue, 19 February 2013 08:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/m/577376/136107/#msg_577376
Re: ORA-02097,ORA-00119 and ORA-00119 [message #577673 is a reply to message #577668] Tue, 19 February 2013 09:55 Go to previous messageGo to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
@BlackSwan Sir, i know but a help would be appreciated


Regards



Janakors
Re: ORA-02097,ORA-00119 and ORA-00119 [message #577682 is a reply to message #577673] Tue, 19 February 2013 11:39 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
why are you trying to change the port #?
why are you trying to establish a new second listener?
Previous Topic: changing of listener port number
Next Topic: Oracle Discoverer only for Databases or also file system file APPL_TOP
Goto Forum:
  


Current Time: Thu Mar 28 05:49:01 CDT 2024