How to retrieve lost passwords for all Oracle users:
Method One:
1. Log in as an operating system verified
Sql>conn/as Sysdba;
2. View the user name in the system.
Sql>select USERNAME from Dba_users;
3. Find the user name you need to change
4. Modify the password for the user name.
Sql>alter user user_name identified by passwd;
Method Two:
Rebuild the password file, and then restart the database
The following are the specific practices:
(1) Change the NTS of Sqlnet.ora directly to none, then execute ALTER user sys identitied by "123456" with Conn/as sysdba login
(2) Execution orapwd File=f:/pwdtest.ora password=123456 entries=10
Place the Pwdtest.ora under the F-disk under Oracle_home/database to replace the previous password file.
Then the landing will be OK.
The PS:pwdtest.ora file naming method is as follows:
PWD <sid>.ora
How to retrieve lost passwords for all Oracle users