Shulou(Shulou.com)06/01 Report--

This article mainly explains "oracle sys user password forgot how to do", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's train of thought slowly in depth, together to study and learn "oracle sys user password forgot how to do" it!

First, forget the login password of users except SYS and SYSTEM users.

Log in as a SYS (or SYSTEM) user: CONN SYS/PASS_WORD AS SYSDBA

Use the following statement to change the user's password: ALTER USER user_name IDENTIFIED BY "newpass"

Note: passwords cannot be all numbers. And it cannot be the beginning of a number. Otherwise, there will be: ORA-00988: password missing or invalid

Forget the password of the SYS user or the SYSTEM user.

If you forget the password of the SYSTEM user, you can log in as the SYS user. Then use the ALTER USER command to change the password:

CONN SYS/PASS_WORD AS SYSDBA

ALTER USER SYSTEM IDENTIFIED BY "newpass"

If you forget the password of the SYS user, you can log in as the SYSTEM user. Then use the ALTER USER command to change the password.

CONN SYSTEM/PASS_WORD

ALTER USER SYSTEM IDENTIFIED BY "newpass"

Third, if the SYS,SYSTEM user's password is forgotten or lost.

You can use the ORAPWD.EXE tool to change the password.

Start menu-> run-> enter 'CMD', to open a command prompt window and enter the following command:

Orapwd file=D:\ oracle10g\ database\ pwdctcsys.ora password=newpass

This command regenerates the password file for the database. The location of the password file is in the\ database directory under the ORACLE_HOME directory.

This password is to change the password of the sys user. The passwords of users other than sys will not be changed.

However, Oracle provides two authentication methods, one is OS authentication, and the other is password file verification. If it is the first method, use the following methods to modify the password:

Sqlplus / nolog

Connect / as sysdba

Alter user sys identified by

Alter user system identified by

If it is the second method, use the above method to modify the password, or you can change the password by the following method:

Orapwd file=pwdxxx.ora password= the new password you set entries=10

After setting up, restart the service and log in again.

Oracle 11g

After installing Oracle on this machine, I can't remember the password of the sys user. You can change the password by using the following methods:

1. Open cmd, type sqlplus / nolog, enter enter; enter "conn / as sysdba"; enter "alter user sys identified by new password". Note: the new password had better start with a letter, otherwise an error Ora-00988 may occur. With this method, as long as you have administrator privileges on the oracle server, you can change the password at will when you don't remember the password.

two。 Execute the following command on the command line: sqlplus "/ @ service name as sysdba", and then alter user sys identified by the new password in sqlplus

New password for alter user system identified by

3. Run to the root directory of C disk

1) enter: 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 completed. The password is the initial password of the Oracle database.

4. First of all, type SQLPLUS/NOLOG under CMD and then type CONN/AS SYSDBA in the coming interface, so that the user logged in by the local system will enter the database as the trusted user. There are two ways to solve this problem, one is: ALTER USER (USERNAME) IDENTIFIED BY password; this is the password that can be changed by USERNAME. 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); both of the above methods are for the version of ORACLE 9i.

5. With the orapwd.exe command, you can modify the command.

The command orapwd file='/oracle/pwdsid.ora' password=123456 is to change the password of the sys user. You overwrite the generated file over the original password file. The passwords of users other than sys will not be changed.

6.su-oracle

Sqlplus / nolog

Conn / as sysdba

Startup (start if the database is not in the startup state)

Alter user sys identified by 123456

Then you can log in with the sys password.

Operating system authentication mode

Conn / as sysdba

Alter user sys identified by xxx

Thank you for reading, the above is the "oracle sys user password forgot how to do" the content, after the study of this article, I believe you forget how to do this problem of oracle sys user password has a deeper experience, the specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.