Modify the OracleSYS, SYSTEM password, and authentication password and authentication method

Welcome to the Oracle community forum and interact with 2 million technical staff into SQLselectusername, passwordfromdba_users; USERNAMEPASSWORD------------------------------------------------------------SYS8A8F025737A9097ASYSTEM2D594E86F93B17A1DBSNMPE066D21

Welcome to the Oracle community forum, and interact with 2 million technical staff> go to SQL select username, password from dba_users; USERNAME PASSWORD should receive SYS 8A8F025737A9097A SYSTEM 2D594E86F93B17A1 DBSNMP E066D21

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

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.

Unlock a user

SQL> alter user system account unlock;

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

[1] [2]