ORA-00132 while starting 11gR2 database

Short post on a error which can take lot of time to debug. You have upgraded a database and after restoring all files (init,tnsnames) try to startup 11g database and it fails with following error

SQL> startup nomount
ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name 'scan-clu:1521'

11gR2 requires remote_listener to be set to <scan_name:port>. Problem is that the sqlnet.ora file has been modified/replaced (from earlier version backup) which does not have EZCONNECT and has only TNSNAMES. Ensure that your sqlnet.ora file contain’s EZCONNECT

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

Amit Bansal

Experienced professional with 16 years of expertise in database technologies. In-depth knowledge of designing and implementation of Disaster Recovery / HA solutions, Database Migrations , performance tuning and creating technical solutions. Skills: Oracle,MySQL, PostgreSQL, Aurora, AWS, Redshift, Hadoop (Cloudera) , Elasticsearch, Python

This Post Has 4 Comments

  1. Arun

    Very nice tip.

    This is what I was facing since morning & was not able to get a solution

    Putting EZCONNECT in sqlnet.ora solved my issues.

    Thanks a lot
    Keep up the great work
    Arun

  2. Claudiomiro Caetano

    Simple and effective.
    Thanks a lot, it solved my issue.

  3. Mark

    Thanks for the help. Worked as advertised.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.