Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have installed Oracle 11g R2 on my Windows. During the installation, in password management, the "scott" user is missing. I'm unable to login in "scott" as my sample schema.

What do I have to do in order to get the "scott" user in my database?

share|improve this question
add comment

2 Answers

It may already be there (if you installed the demo schema) but locked for security reasons.

Log in as SYSTEM or SYS.

SQL > alter user scott account unlock;

share|improve this answer
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.