Sunday , June 16 2024

What Is Password File In Oracle

In today’s article, we will explain what a password file is, how to create it and how to use it.

For non-SYS users, a password file is needed when they want to connect to the database as SYSDBA or SYSOPER. (On the operating system side)

By default it is created as an orapw<ORACLE_SID> file under the $ORACLE_HOME/dbs directory.

If we want, we can also create it with the “orapwd” tool.

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

We connect to sysdba from the remote desktop as follows.

Now we can query the view.

If we had not connected as sysdba, a result like the following would be returned.



Leave a Reply

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