Re: Instance "mydb", status UNKNOWN

Posted by ErmanArslansOracleBlog on Feb 03, 2021; 2:18pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Instance-mydb-status-UNKNOWN-tp9305p9316.html

Hi,

I tested it on a EBS 19C database and it works..

[oracle@ebsclone tns_link]$ echo $TNS_ADMIN
/home/oracle/tns_link

[oracle@ebsclone tns_link]$ ls -al
total 4
drwxr-xr-x   2 oracle oinstall   26 Feb  3 17:15 .
drwx------. 24 oracle oinstall 4096 Feb  3 17:15 ..
lrwxrwxrwx   1 oracle oinstall   52 Feb  3 17:15 tnsnames.ora -> /u01/dbebs/product/19.0.0/network/admin/tnsnames.ora

[oracle@ebsclone tns_link]$ echo $TNS_ADMIN
/home/oracle/tns_link
[oracle@ebsclone tns_link]$ ls -al
lrwxrwxrwx   1 oracle oinstall   52 Feb  3 17:15 tnsnames.ora -> /u01/dbebs/product/19.0.0/network/admin/tnsnames.ora

[oracle@ebsclone tns_link]$ sqlplus apps/xxxxxxxxx@TEST

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 3 17:17:33 2021
Version 19.9.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.

Last Successful login time: Wed Feb 03 2021 17:16:17 +03:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.9.0.0.0

SQL>