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)

4 thoughts on “ORA-00132 while starting 11gR2 database

  1. Pingback: ORA-00132: syntax error or unresolved network name ‘LISTENER_TEST2AT’ « Anand's Blog

  2. 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

Leave a Reply