Unlock ORACLE Default Account

ORACLE default account unlock Problem description: After Oracle10g is installed, use scott/tiger to test, the following error message will appear: oracle10g the account is locked oracle10g the password has expired www.2cto.com cause: scott of Oracle10g cannot log on by default. Solution: (1) conn sys/sys as sysdba; // Log On as DBA (2) alter user scott account unlock; // then unlock (3) conn scott/tiger // a dialog box is displayed. You can change the password to www.2cto.com. The procedure is as follows: C:> sqlplus. Enter the username: sys and enter the password: sys as sysdba // note: the password entered here must be followed by the as sysdba. SQL> alter user scott account unlock; the user has changed. SQL> commit; submitted completely. SQL> conn scott/tiger change scott password new password: tiger retype new password: tiger Password Changed connected. // Complete.