ora-12528: TNS:Listener: All Appropriate instances are blocking new connections

ora-12528: TNS:Listener: All Appropriate instances are blocking new connections

Got this Error.

This error means Database instance are not started or Starting.You need to start database server.If your database server is already starting.You have to wait till the database open.

Connect directly to Oracle



command:-

export oracle_sid=testdb

sqlplus sys as sysdba
password:XXXXX

SQL>select status from v$instance;

we can see the current status from Database from above query.

Cheers!!!!