Author Archives: SandeepSingh DBA

About SandeepSingh DBA

Hi, I am working in IT industry with having more than 10 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

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