Skip to Content
Author's profile photo Former Member

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

Assigned tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Eduardo Rezende
      Eduardo Rezende

      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

      Author's profile photo Former Member
      Former Member
      Blog 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

      Author's profile photo Eduardo Rezende
      Eduardo Rezende

      Hi Hari,

      Good to hear to you could solve your problem.

      Regards,

      Eduardo