Solution to Oracle password forgetting (1)

An error occurred while connecting to the database with the SYS identity today. I don't know whether the SYS password was accidentally modified or what happened. Fortunately, the SYSTEM password is not forgotten.

The following describes how to change the password of an Oracle database:

1. Enter as SYSTEM

2. SQL> show parameter password;
NAME, TYPE, VALUE
Remote_login_passwordfile, string, and EXCLUSIVE
My VALUE is EXCLUSIVE. If your result is other, please refer to the following information. Of course, you can also use SQL> alter system set

Remote_login_passwordfile = 'clusive 'scope = spfile; command to modify remote_login_passwordfile

3. Run CMD to enter the command line and enter orapwd file = C: "oracle" product "10.2.0" db_3 "database" pwdorcl1.ora password = test

Note:: File = C: "oracle" product "10.2.0" db_3 "database" pwdorcl1.ora. pwdorcl1.ora is the name of your password file, and the naming rule is pwdxxx. ora, xxx is your database name, not the Instance name. Then, put the file in a fixed directory. The fixed directory 9i and 10i is the oracle_home "database directory. If a file with the same name already exists in your directory, delete it in advance.

4. now you can log on to the system as SYS. For details about the SYS password and the remote_login_passwordfile parameter, see: Oracle. If you want to log on to Oracle as a privileged user, there are two authentication methods:
1) use authentication integrated with the operating system
2) use the Oracle Database Password File for authentication.

Therefore, managing password files is of special significance for controlling authorized users to log on to the Oracle Database System from the remote end or local end and perform database management.

The password file of the Oracle DATABASE is stored in the password of the Super User INTERNAL/SYS and the username/password of other privileged users. It is generally stored in the ORACLE_HOME \ DATABASE directory.