ORA-00132 while starting 11gR2 database

Post author:Amit Bansal
Post published:20 May, 2011
Post category:11g
Post comments:4 Comments

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)

Tags: 11gR2, oracle, RAC

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

Pingback: ORA-00132: syntax error or unresolved network name ‘LISTENER_TEST2AT’ « Anand's Blog
Arun 9 Nov 2011 Reply

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
Claudiomiro Caetano 8 Feb 2012 Reply

Simple and effective.
Thanks a lot, it solved my issue.
Mark 16 Jul 2012 Reply

Thanks for the help. Worked as advertised.