ORA-00132: syntax error or unresolved network name ‘LISTENER_TEST2AT’

On starting a 3-node 11gR2 RAC database on linux using srvctrl start database/instance command gave the below error –

$ srvctl start instance -d testat -i test1at 
PRCR-1079 : Failed to start resource ora.testat.db
CRS-5017: The resource action "ora.testat.db start" encountered the following error:
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_TEST2AT'
. For details refer to "(:CLSN00107:)" in "/u01/app/oracle_crs/".

The error lead to check tnsnames.ora and tnsping for LISTENER_TEST2AT. All was fine.Did some more debugging and found TNS_ADMIN set.

$echo $TNS_ADMIN

The tnsnames.ora, listener.ora and sqlnet.ora were present in /var/opt/oracle location. The issue was sqlnet.ora file was not present in $ORACLE_HOME/network/admin folder.Created symbolic link for sqlnet.ora in $ORACLE_HOME/network/admin

$ cd $ORACLE_HOME/network/admin/
$ ln -s /var/opt/oracle/sqlnet.ora

Also, missing was symbolic link for tnsnames.ora. Once done, the srvctl start instance/database command succeeded.

For ORA-00132, you can also refer


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s