A quick solution to the forgetting password of Oracle administrator's account
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!