PasswordFile – orapwd utility in Oracle

Hello everyone, in this tutorial we gonna examine PasswordFile – orapwd utility in OracleThe password file is an optional file.
It’s use has some advantages.

 

PasswordFile in Oracle

The most authoritative user of the database was the SYS user, and we were connecting to this database as SYSDBA.

We may also want to connect as SYSDBA or SYSOPER with our non-sys users.

We may still want to connect to the database from remote computers as SYSDBA or SYSOPER.

Image result for oracle password file

In this case the password file is needed.

 

orapwd utility in Oracle

By default, the password file is created as an orapw <ORACLE_SID> file under $ ORACLE_HOME / dbs on linux servers when we create our database with DBCA.

 

If we want “orapwd” tool can create with us.

cd $ORACLE_HOME/dbs
orapwd file=orapw<ORACLE_SID> password=<sys password>


 

In order to use our password file, we need to set the value of “REMOTE_LOGIN_PASSWORDFILE” parameter to “exclusive” in our spfile or pfile parameter file.

This parameter has three values;

Exclusive: It can be connected to a single machine database. Users other than SYS can also be found in the password file.

Shared: Multiple databases can use a password file. Only the SYS user can be found in the password file.

None: Oracle ignore password file. When this parameter is “exclusive”, we can allow sysdba to save the file to the user

SQL>grant sysdba to deniz

We can now connect to our database from a remote computer with sysdba authority

sqlplus deniz/[email protected] as sysdba

 

See you next article..

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/

About Deniz Parlak

Hi, i’m Security Data Scientist & Data Engineer at My Security Analytics. I have experienced Advance Python, Machine Learning and Big Data tools. Also i worked Oracle Database Administration, Migration and upgrade projects. For your questions [email protected]

Leave a Reply

Your email address will not be published. Required fields are marked *