Problem solve
Get help with specific problems with your technologies, process and projects.
ORA-12528 error
I am getting the error "ORA-12528: TNS:listener: all appropriate instances are blocking new connections."
My database says:
java.sql.SQLException: Listener refused the connection with the following error: ORA-12528, TNS:listener: all appropriate instances are blocking new connections The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS= (PROTOCOL=TCP)(HOST=192.168.0.18)(PORT=1521))) (CONNECT_DATA=(SID=DBPMRB)(SERVER=DEDICATED)))I shut down and restarted the database.
I addressed this issue in November 2004. You can see my answer here: ORA-12528 after shutting down and restarting instance. If that does not fix your problem, then on your database server, restart the Listener.
lsnrctl stop lsrnctl startWait up to 10 minutes and then try to connect again.
