Category Archives: Oracle

In this we are handling Oracle Database Administration and development task. If provide solution of ORA Errors and configuration Steps for setup in Oracle.

Connect SQLPLUS back door with Preliminary connection (PERLIM) in Oracle

Connect SQLPLUS back door with Preliminary connection (PERLIM) in Oracle

When you are not able to login as sysdba in your own database then you have one back door entry to connect to the Oracle Database with using PERLIM parameter with SQLPLUS. In this you have limited access to Database for do basic DBA task.

Following are the ways to connect to database:

First method, Use perlim directly in the SQLPLUS command:

sqlplus -prelim / as sysdba

Second method, Set the parameter perlim ON for connectivity as shown below:

sqlplus /nolog
set _prelim on
connect / as sysdba