Connect Remotely as SYSDBA using orapwd


– Set init parameter to REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE.

parameter be set to either SHARED or EXCLUSIVE.
SHARED the password file can be used by multiple databases and only the SYS user is recognized.
EXCLUSIVE the password file can be used by only one database and multiple users can exist in the file.

The parameter value can be confirmed by:

SQL> show parameter password

NAME TYPE VALUE

—————————– ———– ———-
remote_login_passwordfile string EXCLUSIVE

– Create the password file using the ORAPWD utility.

orapwd file=<filename> password=<password> entries=<max_users>

– Connect to the database as user SYS (or as another user with the administrative privilege).
If the user does not already exist in the database, create the user.
Grant the SYSDBA or SYSOPER system privilege to the user.
This will add the user to the password file, and that user’s name and privilege information are added to the password file.

SQL> grant sysdba to scott;

Grant succeeded.

– Confirm that the user is listed in the password file.

SQL> select * from v$pwfile_users;

USERNAME SYSDBA SYSOPER

—————————— —— ——-

SYS TRUE TRUE

SCOTT TRUE FALSE

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: