Two solutions to Oracle password loss

When using Oracle, you will inevitably encounter the Oracle password loss problem. The following describes two solutions to Oracle password loss, hoping to help you.

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 = (CNT)

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.

Solution 2: Oracle password loss.

Sqlplus/nolog
SQL> connect/as sysdba

Method 2:

The detailed steps are as follows:

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.
 

Entire Process of creating Oracle Materialized View

ORACLE instance creation process

Oracle reads and writes system files

Oracle Password File Management

How to check the oracle deadlock