Get the App
SLTechnology News&Howtos  ›  Database  › 

A quick solution to the forgetting password of Oracle administrator's account

Shulou Source: shulou.com Published: 2022-06-01 04:05:11 11月17日 Update

This example, Oracle12c, is an example.

The administrator account is divided into system and sys, and the modification methods are different, which are described respectively.

1 modify sys password

First, enter the Oracle installation directory, such as F:\ app\ Administrator\ product\ 12.1.0\ dbhome_1\ database, and delete or rename the PWDorcl.ora file:

If you do not perform this step, execute the orapwd command, and an "OPW-00005: file with the same name-please delete or rename" error is thrown.

Then from that directory, execute the following orapwd command, as follows:

F:\ app\ Administrator\ product\ 12.1.0\ dbhome_1\ database > orapwd file=F:\ app\ Administrator\ product\ 12.1.0\ dbhome_1\ database\ PWDorcl.ora password= New password

Parameter describes the path to the password file generated by file. The new password for the passwordsys account.

Both are required.

After successful execution, a new PWDorcl.ora file is created in the current directory.

At this point, the password has been modified successfully.

2 modify system password

In the Windows run command, type sqlplus / nolog to start sqlplus without connecting to the database. After entering sqlplus, enter conn / as sysdba,Oracle to verify the account of the current operating system. If you belong to the ora_dba group, you can log in successfully. Execute the following SQL statement to change the password of the system account: alter user system identified by new password

Summary

The above is the quick solution to forget the password of the Oracle administrator account introduced by the editor. I hope it will be helpful to you!

Tags: Password account file success command directory new secret method administrator management input different operating system parameters data database example system so far statement Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Apple Xiaomi vpn Microsoft Redmi