Search

Top 60 Oracle Blogs

Recent comments

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