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

Question

I have successfully installed Oracle 11g R2 version. I don't have good knowledge about Oracle database. SQL developer needs a Database Connection.

I don't know how to create this. Searching through the Internet, I found this page

According to this site, there is HR user and HR database. Also there is some predefined tables. What are these tables and other things. Does Oracle comes with this default database? Can't I create database with different name? And how to create this database connection in right way?

These tables are not my creations

Answer 1

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