SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to unlock user, Scott

865683May 31 2011 — edited May 31 2011

HI,

I have installed Oracle 10g DB on XP. After installation of ORACLE DB, DATABASE CONFIGURATION ASSISTANT dialog box came, but i mistakenly click on OK button instead of clicking on PASSWORD MANAGEMENT to unlock user id, SCOTT.

Now when i am trying to login using user id and password, SCOTT/TIGER, then error is coming as :

ORA-28000: the account is locked

i don't know what is the password of SYSDBA or SYSTEM so that i can reset the password of SCOTT. for SYSDBA id, i have tried with CHANGE_ON_INSTAL password, but it didn't go through.

Would you pls. help.

This post has been answered by sb92075 on May 31 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 28 2011

Added on May 31 2011

2 comments

737 views