Sunday, April 28, 2013

How to login to the scot account after installing Oracle 11g [closed]


I think you have not unlocked your scott user account while installation,please follow the steps below to unlock you scott account .
When you started installing oracle ,it asked for global database name and database password that password is used for the sys system sysman dbsnmp account.
  1. SQL> conn user/password;
    SQL> conn scott/tiger;
Error message is displayed: the account is locked.
  1. Try to login as "system" - pass
    SQL> conn system/password;
  2. Unlock "scott"
    SQL> alter user scott account unlock;
  3. Can change "tiger":
    SQL> alter user scott identified by tiger;
  4. SQL> conn scott/tiger; -Success
scott account is locked in 11g due to security thinking,
Now you can type Connection Name :ORCL ,username:Scott,password:tiger to login

No comments:

Post a Comment