Re: Instance "mydb", status UNKNOWN

Posted by big on Feb 03, 2021; 5:47am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Instance-mydb-status-UNKNOWN-tp9305p9312.html

Hi,
Thanks.
You are true:
" this means your db is reading another tnsnames.ora".

TNS_ADMIN was pointing to a wrong tnsnames.ora file. I corrected and now connection is possible.

One thing:

It seems that in 19c TNS_ADMIN should directly point to tnsnames.ora file and does not like pointing to symbolic links.
 for example if TNS_ADMIN=/etc and in /etc we have
tnsnames.ora --> /u01/cfg/tnsnames.ora

we have ora-12154 tns could not resolve.

Best regards.