Forget the Oracle administrator password

A database version used to change the password of an Oracle user: 9.2.0.5)

Sometimes we may not know the password of a user, but we need to perform 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.

If UNIX is used, it must be transferred to the Oracle user environment variable, provided that the operating system is used for verification.

The procedure is as follows:

SQL * Plus: Release 9.2.0.5.0-production on Sunday November 21 13:32:34 2004

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

SQL> connect sys/Oracle AS sysdba

Connected.

SQL> select username, password from dba_users;

Username Password

------------------------------------------------------------

Sys 8a8f025737a9097a

System 2d594e86f93b17a1

Dbsnmp e066d214d5421ccc

Toad a1ba01cf0dd82695

Outln 4a3ba55e08595c81

Wmsys 7c9ba362f8314299

You have selected 6 rows.

SQL> connect system/Oracle

Connected.

SQL> connect sys/Oracle AS sysdba

Connected.

Change User System Password to Manager

SQL> alter user system identified by manager;

The user has changed.

SQL> select username, password from dba_users;

Username Password

------------------------------------------------------------

Sys 8a8f025737a9097a

System d4df7931ab130e37

Dbsnmp e066d214d5421ccc

Toad a1ba01cf0dd82695

Outln 4a3ba55e08595c81

Wmsys 7c9ba362f8314299

You have selected 6 rows.

SQL> connect system/Manager

Connected.

Then, you can perform any operations you want.

SQL> connect sys/Oracle AS sysdba

Connected.

Change the user's system password to a previous value.

SQL> alter user system identified by values '2d594e86f93b17a1 ';

The user has changed.

SQL> connect system/Oracle

Connected.

SQL> connect sys/Oracle AS sysdba

Connected.

SQL> connect system/Manager

Error:

ORA-01017: invalid username/password; logon denied

Warning: you are no longer connected to Oracle.

or delete the old password file and create a new one, for example,
orapwd file = D: \ oracle \ database \ pwdetalker. ora Password = newpass entries = 10 force = y;
you can change the password after logon using OS verification.