ORA-28017: The password file is in the legacy format

If the password file format in the 12c databases is same with the format in the 11g databases, you receive the error “ORA-28017: The password file is in the legacy format” when attempting to change the password of a user in the password file.

The format of the password file should be set to 12 or higher instead of LEGACY to avoid error.

Find Password File Format in Oracle

You can learn the format of the existing password file as follows.

To avoid the problem, either re-create or convert the password file.

How To Create Oracle Password File

How To Change Oracle Password File Format

You can convert the password file to the new format as follows.

The above commands should be executed under the $ORACLE_HOME/dbs directory, or the path must be specified exactly when specifying the file name. (Like $ORACLE_HOME/dbs/orapwORCL).

The format of the new password file should be as follows.

Then you can change the password successfully.

In RAC databases, the new password file created must be copied with the name it should be into the $ORACLE_HOME/dbs directory to other nodes.

dbtut
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 *