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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.