Shulou(Shulou.com)05/31 Report--

This article mainly introduces "the solution of oracle forgetting user password". In daily operation, I believe that many people have doubts about the solution of oracle forgetting user password. Xiaobian consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubt of "oracle forgetting user password solution". Next, please follow the editor to study!

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 password

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 password

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.

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 password file is located in the ORACLE_HOME directory

Under the\ database directory of.

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

At this point, the study on "the solution of oracle forgetting user password" is over. I hope to be able to solve everyone's doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.