Solution to Oracle password loss

This article uses two methods to solve this problem when I often encounter password loss when I use Oracle.

One method:

sqlplus "/ as sysdba"SQL>startupSQL>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.

2.

sqlplus /nolog sql>connect /as sysdba

1 2 Next Page

[Content navigation]
Solution to Oracle password loss	Solution to Oracle password loss