Friday, May 30, 2014

11gR2 RAC Database Fails to Start With Error ORA-00132: syntax error or unresolved network name ':1521'


We were seeing below error when trying to start an instance.

ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name '<scanname>:1521'



After doing some research I found that an entry of SQLNET.ORA was not properly set.

The location of SQLNET.ORA is <DB Home>/network/admin.

NAMES.DIRECTORY_PATH entry of SQLNET.ORA was wrong. 

It had the entry "names.directory_path = (TNSNAMES)" instead of "names.directory_path = (TNSNAMES,EZCONNECT)"


So, I made the change as "names.directory_path = (TNSNAMES,EZCONNECT)"

After making the above change I was able to start the instance of RAC without any errors.