Oracle forgot user name and password solutions

Oracle forgot user name and password solutions

Description: Sometimes, the Oracle database password is forgotten, then you have to try all the usual password, you can look down.

First, directly through the operating system authentication mode login, modify the user password

Kill the following in CMD or bash

Sqlplus/nolog

Conn/as Sysdba;

Alter user username identified by newpass;//

username the user name that you want to modify is prompted for a change that indicates success

The way I tried it myself

second, forget to remove SYS,the login password of a user other than the SYSTEM user.  

Log in with SYS (or system) User:

Connsys/pass_word as SYSDBA;

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

ALTER USER user_nameidentified by Newpass;

Note: Passwords cannot be all numbers. and cannot be a number start. Otherwise it will appear: ORA-00988: Password is missing or invalid

Third, forget the SYS user, or the password of the SYSTEM user.

If you forget the password of the system user, you can log in with the SYS user. Then change the password with alter user chitian:

CONN Sys/pass_word as SYSDBA;

ALTER USER SYSTEM identified by Newpass;

If you are forgetting the password of the SYS user, you can log in with the system user. Then change the password with alter user Chitian.

CONN System/pass_word

ALTER USER SYS identified by Newpass;

Iv. If the password of the Sys,system user is forgotten or lost.

This item is particularly important.

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

Start menu, run as input ' CMD ', 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 under the \database directory in the Oracle_home directory.

This password is the password that modifies the SYS user. Passwords for other users except SYS and system will not change

This article is from the "Technical Achievement Dream" blog, please be sure to keep this source http://pizibaidu.blog.51cto.com/1361909/1683737

Oracle forgot user name and password solutions