top of page

SQLPLUS -prelim

  • Writer: kyle Hailey
    kyle Hailey
  • May 30, 2010
  • 1 min read

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:


1) sqlplus -prelim / as sysdba

2) sqlplus /nolog set _prelim on conn / as sysdba


see more from Tanel Poder

 
 
 

Comments


Kyle Hailey

  • Facebook
  • Twitter
  • LinkedIn
  • Instagram

San Franisco, Ca 94131

415-341-3430  (please text initially before calling)

bottom of page