Oracle Database system Users forget the password what to do?

Oracle Database system users forget their passwords.
D:\oracle\ora92\bin>sqlplus/nolog


Sql*plus:release 9.2.0.1.0-production on Thursday August 16 11:32:22 2007


Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Sql> Conn/as SYSDBA
is connected.
sql> alter user system identified by password;


The user has changed.


sql> alter user SYS identified by password;


The user has changed.


sql> alter user system identified by manger;


The user has changed.


Sql> exit
From Oracle9i Enterprise Edition release 9.2.0.1.0-production
With the partitioning, OLAP and Oracle Data Mining options
Disconnect in Jserver release 9.2.0.1.0-production


D:\oracle\ora92\bin>sqlplus


Sql*plus:release 9.2.0.1.0-production on Thursday August 16 11:40:37 2007


Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Please enter user name: System
Please enter password:


Connect to:
Oracle9i Enterprise Edition Release 9.2.0.1.0-production
With the partitioning, OLAP and Oracle Data Mining options
Jserver Release 9.2.0.1.0-production


Sql> select instance_name from V$instance;


Instance_name
----------------


Oracle password forgot what to do. Sometimes we may forget a user's password, but need to do some operations with this user, and can not modify the user's password, this time, you can use some tips to complete the operation. You can modify your password by using the following methods:


1. Open cmd, enter the Sqlplus/nolog, enter the "Conn/as sysdba", enter "ALTER user SYS identified by new password", note: The new password is best to start with a letter, or you may receive error Ora-00988. With this method, as long as you have administrator privileges on the Oracle Server, Oracle password forget also do not worry, you can modify the password arbitrarily.


2. Execute the following command at the command line: Sqlplus "/@ service name as SYSDBA" and then in Sqlplus
ALTER user SYS identified by the new password;
Alter user system identified by the new password;


3. Run to C packing directory
1 input: SET oracle_sid = your SID name
2) Input: Sqlplus/nolog
3) Input: Connect/as sysdba
4 Input: Alert user sys identified by SYS
5 Input: Alert user system identified by system
6 The change is complete and the password is the initial password for the Oracle database. So the Oracle password has been forgotten and can be modified.


4. First, in the cmd input sqlplus/nolog and then in the interface to enter Conn/as SYSDBA, so that the local system to log in to the user to trust users to enter the database operation. There are two ways to solve this problem: ALTER USER (USERNAME) identified by "password"; This is the password that can change USERNAME. Of course this USERNAME must already exist.
The other is: CREATE user (USERNAME) identified by "password"; the command to change the user's permissions is: GRANT ROLES to (USERNAME); All 2 of these methods are for Oracle 9I versions.


5. With the Orapwd.exe command, you can modify the command. Even if the Oracle password is forgotten, it can be changed many times.
Orapwd file= '/oracle/pwdsid.ora ' password=123456 This command is the password to modify the SYS user. You overwrite the resulting file with the original password file. Passwords for other users except SYS and system will not change.


6.su-oracle
Sqlplus/nolog
Conn/as SYSDBA
Startup (starts if the database is not in a startup state)
ALTER user SYS identified by 123456
You can then log on using the SYS user password