During Oracle upgrade from 10.2.0.5 to 11.2.0.3, I have come across the below error during “Upgrade Oracle Server phase”
During Oracle upgrade from 10.2.0.5 to 11.2.0.3, I have come across the below error during “Upgrade Oracle Server phase”
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name ‘LISTENER_<SID>’
Hello Hari,
Questions should be posted as discussion, not documents. Check Create New SCN Content: Discussions, Blogs and Documents.
Usually, this issue occurs because of location of tnsnames.ora file or a problem with tns aliases.
Check oracle metalink 1281246.1 and 359386.1 for detailed information.
Regards,
Eduardo Rezende
Hi Eduardo,
Thanks for the reply. I understand the solution provided.
During the oracle upgrade in which I have faced this issue, tnsnames.ora was properly located when this issue aroused. But, the problem was, though the listener port was maintained as 1527 in the listener.ora, listener was somehow trying to run on 1521. So, we have manually routed listener to use 1527 which in-turn resolved the issue.
BR,
Hari
Hi Hari,
Good to hear to you could solve your problem.
Regards,
Eduardo