Codeinsane

• ทำการ Connect Database ด้วย SQL*Plus

# sqlplus / as sysdba

• Show Hash

SQL> select name, spare4 from sys.user$ where name = 'SYS' ;

NAME  SPARE4
----- ----------------------------------------------------------------------
SYS   S:02F1A0A8CF84BB24114A77F011ED3942CA0BD4F824FCD6CF1CB597E8A7F4

• Show Password Version

SQL> select username, password_versions from dba_users where username = 'SYS' ;

USERNAME                       PASSWORD
------------------------------ --------
SYS                            10G 11G

• Change Password

SQL> alter user sys identified by password ;

• Restore Password

SQL> alter user sys identified by values 'S:02F1A0A8CF84BB24114A77F011ED3942CA0BD4F824FCD6CF1CB597E8A7F4' ;