the database can not resolve the LISTENERS_***TEST TNS name.
TNS_ADMIN should be set to the location of tnsnames.ora, and not to Oracle homes.
E.g (grid home/network/admin) instead of just (grid home).
p.s: obivously, you need the corresponding entry in your tnsnames.ora
The files are placed under grid_home/network/admin only. I should have mentioned clearly.
Yes the LISTENERS_***TEST entry is already available on tnsnames.ora file under /grid_home/network/admin.
New listener.ora file created under grid_home/network/admin has the below information,
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
I am able to start the database from 10g home after export TNS_ADMIN=gird_home/network/admin from the session where i am trying to start the db.
But the dbua db upgrade failed.. this time i set the TNS_ADMIN=/grid_home/network/admin, ORACLE_HOME=11g home, from the session where i am starting dbua,
CRS-5017: The resource action "ora.ihctest.db start" encountered the following error:
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_IHCTEST1'
I could able to start the db with sqlplus and verified all the components are upgraded. but starting with srvctl failing with the above error.
Issue is resolved, by making the soft link to listener.ora and tnsnames.ora file from /grid_home/network/admin to /oracle11g_home/network/admin.