How To Make A Preliminary Connection

BACKGROUND

SQL*Plus provides a useful way of connecting to the instance even if it has apparently hung. This is known as a preliminary connection.

OPTION 1

  • Local Connection:
   sqlplus  -prelim / as sysdba
  • Remote Connection:
   sqlplus -prelim sys/<sys_password>@<SID> as sysdba

OPTION 2

   sqlplus /nolog
   set _prelim on
   conn / as sysdba
© copyright 2001-2014 ABCdba.com | all rights reserved