how to unlock scott user in oracle 11g

After install the oracle. So many are trying to login with Username and Password(scott/tiger) but it shows an error like "THE ACCOUNT IS LOCKED" then so many developers are fear of that error. Dont worry  be happy of that error because it teaches you more and more  knowldge to you. And How to Unlock the Scott User Account in Oracle. When the User scott does not exist in oracle 12c/11g then go to


1) Go to CMD(Command Prompth) in Administrator Mode.
2) And Type "SQLPLUS"
3) Then it redirects to sqlplus
4) Next type "sys as sysdba" in UserName
5) Again Enter in Password without any password.
6) So it indicates as "connected Oracle Databse"
7) Now enter "SQL>ALTER USER ACCOUNT UNLOCK"
8) The Result shows like "USER ALTERED"
9) NOW CONNECT TO SCOTT/TIGER LIKE
      "SQL>Scott/tiger" press Enter.

now you are entered in to Scott User account/Schema in Oracle.

CHECKING.

10) Now go to SQLPLUS Tool or Click on Window button and type sqlplus in Search Box
      then it opens a oracle window.
11) now Check the Username /Password (Scott/tiger) and click enter button
     then it redirect to scott account
12) Now check like  write any query like "Select * from Tab " it gives all four files in Scott Account.








Top Searching Topics

Types of indexes in oracle with examples