ORA-12528

Solve ORA-12528

by

Today one of my client was facing ora-12528 TNS:listener: all appropriate instances are blocking new connections.

ORA-12528

ORA-12528

We checked the listener status and found the instance is also blocked in the listener which means the normal user cannot be able to establish a connection from the application side.

$lsnrctl status
ORA-12528 in listener

Solve ORA-12528: TNS:listener: all appropriate instances are blocking new connections

Here is the solution for ORA-12528: TNS:listener: all appropriate instances are blocking new connections. We need to add UR=A in tnsnames.ora file. This is the connection descriptor to lift the restriction, for more details check the below screenshot.

$ vi $ORACLE_HOME/network/admin/tnsnames.ora
ORA-12528

Now try to connect with the database as a sys user, and you will be able to connect.

$sqlplus sys/password@ocp as sysdba

...
Connected.

SQL> startup mount;
SQL> alter database open;

Now the error has been resolved successfully.

1 thought on “Solve ORA-12528”

  1. Pingback: ORA-02019: connection description for remote database not found

Leave a Comment