Oracle Database system users forgot their passwords

Oracle Database system user forgot password How to Do 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,200 2, oracle Corporation. all rights reserved. SQL> conn/as sysdba is connected. SQL> alter user system identified by password; the user www.2cto.com 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 disconnect D from 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: \ oracle \ ora92 \ bin> sqlplus SQL * Plus: Release 9.2.0.1.0-Production on Thursday August 16 11:40:37 2007 Copyright (c) 1982,200 2, Oracle Corporation. all rights reserved. enter User name: system 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 -------------- what if the Oracle password is forgotten? Sometimes we may forget the password of a user, but we need to do some operations with this user, and we cannot modify the password of this user. At this time, we can use some tips, to complete the operation. Use the following method to change the password: www.2cto.com 1. open cmd, enter sqlplus/nolog, press enter, enter "conn/as sysdba", and enter "alter user sys identified by new password". Note: it is best to start the new password with a letter, otherwise the error Ora-00988 may occur. With this method, as long as you have administrator permissions on the oracle server, you do not have to worry about the Oracle password. You can change the password at will. 2. execute the following command on the command line: sqlplus "/@ service name as sysdba", and then in sqlplus, alter user sys identified by new password; alter user system identified by new password; 3. run to the C-drive root 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 password is the initial password of the Oracle database. In this way, you can modify the Oracle password if you forget it. Www.2cto.com 4. first, enter SQLPLUS/NOLOG in CMD, and then enter CONN/as sysdba in the displayed interface. In this way, the user logged on to the local system will trust the user to access the database. there are two ways to solve this problem: alter user (USERNAME) identified by "password", which can change the USERNAME Password. of course, this USERNAME must already exist. The other is: create user (USERNAME) identified by "password"; the command TO Change USER Permissions is grant roles to (USERNAME ); the above two methods are for the ORACLE 9I version. 5.use the orapwd.exe command to 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 used to change the password of the sys user. You overwrite the original password file. The password of other users except sys and system will not change. 6. su-oracle sqlplus/nologconn/as sysdbastartup (if the database is not started, it will be started) alter user sys identified by 123456 and then you can use the sys user password to log in.