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?