Instance "mydb", status UNKNOWN

Posted by big on Feb 01, 2021; 6:43pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Instance-mydb-status-UNKNOWN-tp9305.html

Hi,

On 19c on AIX

My listener is always in UNKNOWN status:
 Instance "mydb", status UNKNOWN, has 1 handler(s) for this service...

From dbserver we cannot connect:

sqlplus system@mydb

ora-12154 tns could not resolve.

But from client (with tnsnames.ora exactly the same) we can connect:

sqlplus system@mydb
connected

sql>

Is there any relation between UNKNOWN status and ora-12154?

Thanks for help.