How To Create an Oracle Password File

The Oracle password file is a file that is created automatically during installation.

Users defined in this file can connect to oracle via sqlplus without entering a password.

To add users to this file, you must give the sysdba permission to a user.

You can give or revoke the sysdba permission to the users with the help of the following script.


You can learn which users are defined in this file by using the following script.


In the following command, we create an oracle password file named orapassfile .

In this file you will be able to define 10 users.

You can find the file in the $ORACLE_HOME/dbs directory.

Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

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