on 09-22-2014 1:01 PM
Hi Experts,
While upgrading oracle from 11.2.02. to 11.2.0.4 on Windows platform.
We have installed software of 11.2.0.4 and during up-gradation step at DBUA, We are getting below error -
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_QAL
Please advice.
Thanks
Chander
Hello
Please check note 1915325 - Oracle 11.2.0: LOCAL_LISTENER
During a database upgrade to release 11.2.0.x, DBUA defines an alias entry 'LISTENER_<SID>' in the local tnsnames.ora file and sets the parameter LOCAL_LISTENER=''LISTENER_<SID>'.
Check that parameter value
SQL> show parameter local_listener;
If needed fix it (restart of Oracle instance needed) :
SQL> alter system set local_listener = '(ADDRESS = (PROTOCOL=TCP)(HOST=<hostname>)(PORT=<port>))';
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chander.
LOCAL_LISTENER parameter is no used on single instance databases. You can easily delete this parameter from the spfile or pfile o the target ORACLE_HOME. Afterwards tge upgrade should pass this error and proceed further.
Regards,
János
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.