kyle Hailey
SQLPLUS -prelim
There is a way to connect to Oracle even when sessions are maxed out or there is a hang etc:
I knew about this a while back but its just one of those things that’s important to remember when it’s needed! Thus, so I can always know where to find it , I’m reposting:
http://oraclue.com/2008/09/25/sqlplus-preliminary-connection/
1) sqlplus -prelim / as sysdba
2) sqlplus /nolog set _prelim on conn / as sysdba
see more from Tanel Poder
http://tech.e2sn.com/oracle/troubleshooting/hang/how-to-log-on-even-when-sysdba-can-t-do-so