Oracle Password File

Hello everyone, in this tutorial we gonna examine Oracle Database Password File. The password file is an optional file.
It’s use has some advantages.

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.

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>

blank

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/deniz@192.168.1.2 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/

 280 views last month,  8 views today

About Deniz Parlak

blank
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 parlak.deniss@gmail.com

Check Also

blank

Alter System Flush Shared pool in Oracle

Hi, I will explain Alter System Flush Shared pool in Oracle in this post.  1,667 views …

Leave a Reply