Having problem in accessing specific USERS(like scott,hr,oe..) on oracle 11g database?

Windows 7 environment?....64 bit?..32 bit?...32 is fine...but 64 requires some efforts to run Oracle 11g swiftly..doesn't it?...Even if you got 32 bit win 7 it takes time to install the database depending on your RAM size...However after all efforts and time takings you've got the database installed on your lappy..Beginner to Oracle..you open sql plus...enters the required username and default password..suddenly it says "USER LOCKED"...!..Damn...!

Here's the solution :

->Against username type sys as sysdba

    Against password       just press enter without typing anything

->after getting connected (in order to unlock scott user)

type : 

SQL>alter user scott account unlock;

->If you don't know the password of the user scott, type the following in order to change the password :

SQL>alter user scott identified by <desired password>;

->You can always change the password of sys or system too...But keep it in mind..Never forget the password of sys.

Enjoy...!

Yours

Sashwat(skp)

Subscribe To Get FREE Tips and Tutorials!