Two solutions for Oracle password loss

What should I do if my Oracle password is lost? The following two methods are provided for your reference. The methods described in this article may also be omitted due to different Oracle versions.

Solution 1:

 
 

  
  
sqlplus "/ as sysdba" 
  
  
SQL>startup  
  
  
SQL>alter user system identified by root123; 
 
 

If sqlplus "/as sysdba" cannot be accessed, enter the password. If I cannot enter the original password or the modified password, modify the unix environment:

1. $ ORACLE_HOME \ network \ admin \ SQLNET. ORA is:

 
 

  
  
SQLNET.AUTHENTICATION_SERVICES=(NTS)  
 
 

After restarting the database/listener service, you can use the operating system to authenticate sqlplus "/as sysdba" to access your database, so that you can easily deal with your database.

2.

 
 

  
  
sqlplus /nolog   
  
  
sql>connect /as sysdba 
 
 

Solution 2:

1. query view V $ PWFILE_USERS: select * from V $ PWFILE_USERS; records the user information with SYSOPER/SYSDBA system permissions.

2. Shut down the database shutdown immediate.

3. Delete the password file. The file path is ORACLE_HOME \ DATABASE and the file name is PWD. ORA.

4. Create a password file:

 
 

  
  
ORAPWD　FILE=＜ FILENAME ＞　PASSWORD =＜ PASSWORD ＞  
 
 

5. Add a user to the password file:

 
 

  
  
CONNECT　SYS／internal_user_passsword AS　SYSDBA；  
 
 

Start the database instance and open the database; create a corresponding user account and GRANT permissions TO it: grant sysdba to user_name if the previous database only has sysdba permissions, do not do this step ).

6. Change the password file status. The default password file status is shared. Set REMOTE_LOGIN_PASSWORDFILE in the initialization parameter to EXCLUSIVE.

1. Introduction to Oracle user permissions and role management
2. Create and assign Oracle user permissions
3. Quick query of Oracle Default usernames and passwords
4. Unlock an Oracle user on the command line
5. Authorization and management for five Oracle users