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