| ORA-02097,ORA-00119 and ORA-00119 [message #577646] |
Tue, 19 February 2013 06:09  |
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
