Wednesday, December 8, 2010

Oracle Unlock Account

To Resolve the Oracle error ora-28000 Account Locked in Oracle 10g, Do the following

1) Connect to the sys as sysdba and issue the following commands
      a) Alter user <username> account unlocked;
      b) grant connect, resource to <username>;
  
Account is unlocked now. Connect to the <username>. You may be prompted for password change. If prompted you can retype the old password itself.

No comments:

Post a Comment