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


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

  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.