How To Make A Preliminary Connection
SQL*Plus provides a useful way of connecting to the instance even if it has apparently hung. This is known as a preliminary connection.
- Local Connection:
sqlplus -prelim / as sysdba
- Remote Connection:
sqlplus -prelim sys/<sys_password>@<SID> as sysdba
sqlplus /nolog set _prelim on conn / as sysdba