Skip to Main Content

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

783226Nov 20 2013 — edited Nov 21 2013

I'm working with OBIEE 11.1.1.5, with Ora DB 11.2.

Suddenly, the OBIEE is not accessible.

The logs showed that the issue is DB connectivity.

When I try to enter directly to the DB via sqlplus I get the error:

/opt/oracle/product/11.2.0/dbhome_1/bin/sqlplus sys@UBI as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 20 13:18:23 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter password:

ERROR:

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

I tried restarting server, DB, listener, but nothing helped.

I've Googled and saw that I need to unregister some old connections, which were not closed correctly, i.e. entering DB and delete some records,

but I cannot login to the sqlplus.

I failed login as sys, system, scott - on the same error.

How can I solve this issue?

Comments