Skip to Content

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>’

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

    1. Hari Vemula Post author

      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

      (0) 

Leave a Reply