By
Published: 09 Aug 2006
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 start
Wait up to 10 minutes and then try to connect again.
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Continue Reading