cancel
Showing results for 
Search instead for 
Did you mean: 

DBUA Fails error- ORA-00119: invalid specification for system parameter LOCAL_LISTENER

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

ACE-SAP
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Dear Yves,

After maintaing LOCAL_LISTENER in tnsname.ora the upgrade workd without any error.Thanks

for help

Regards

Chander

Answers (1)

Answers (1)

0 Kudos

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