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

The solution of Oracle forgetting username and password

Explanation: sometimes, the oracle database password is forgotten, and you can't try all the commonly used passwords, so you can read on.

Log in directly through operating system authentication and change the user's password

Enter the following life in cmd or bash

Sqlplus / nolog

Conn / as sysdba

Alter user username identified by newpass;//

Username is successful when the user is prompted to change the user name to be modified

I have tried this method in person.

Forget the login passwords of users other than SYS and SYSTEM users.

Log in as a SYS (or SYSTEM) user:

CONNSYS/PASS_WORD AS SYSDBA

Use the following statement to change the user's password:

ALTER USER user_nameIDENTIFIED 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 change the password with the ALTER USER 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 change the password with the ALTER USER password.

CONN SYSTEM/PASS_WORD

ALTER USER SYS IDENTIFIED BY newpass

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

This one is particularly important.

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:\ oracle\ product\ 10.2.0\ db_1\ 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 and system will not be changed.

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.