I encountered a problem today: I forgot the password of the INTERNAL account: (I checked the information and found a way to enter the database:
In the Oracle database system, if you want to log on to the Oracle database as a privileged user (INTERNAL/SYSDBA/SYSOPER), there are two authentication methods: that is, authentication is performed using the Integrated Identity Authentication with the operating system or using the password file of the Oracle database.
The password file of the Oracle DATABASE is stored in the Super User INTERNAL/SYS password and the user name/password of other privileged users. It is generally stored in the ORACLE_HOME \ DATABASE directory.
When you use Oracle Instance Manager to create a DATABASE Instance, a password file is automatically created under the ORACLE_HOME \ DATABASE directory. The file name is PWDSID. ORA, where SID represents the corresponding Oracle database system identifier.
Therefore, it is very easy to solve this problem, and I just went up and down the password file :)
"Start"-"run", enter
Orapwd file = d: OracleOra81DATABASEPWDnewfile password = NEWPSW entries = 5"
Done :)
The command format is as follows:
C: \> orapwd file = <FILENAME> PASSWORD = <PASSWORD> ENTRIES =
The meanings of command parameters are as follows:
FILENAME: password file name;
PASSWORD: Set the PASSWORD of the INTERNAL/SYS account;
MAX_USERS: the maximum number of users in the password file, which corresponds to the maximum number of users allowed to log on to the database with SYSDBA/SYSOPER permissions. In future maintenance, if the number of users exceeds this limit, the password file needs to be rebuilt. Therefore, this parameter can be set to be larger as needed.
Note: After the password file is available, you need to set the initialization parameter REMOTE_LOGIN_PASSWORDFILE to control the Usage Status of the password file.