When oracle is installed it creates a number user almost 20.
At the time of installation except the DBA accounts all others are LOCKED by default.
Which can be unlocked at the time of installation orlater on by logging in through the DBA accounts.

In your case it seems SCOTT account is locked.

u can login as SYS/AS SYSDBDA

then unlock the scott account
by

alter user scott identified by tiger account unlock;

Hope that helps u in solving your problem.

i am having the same problem for oracle 9i .........
i downloaded it and installed it ...
but i just cant log-in ...

any clues how to resolve this problem

same way... Log in to the admin console and unlock the account(s) you want to use.

And to be on the safe side for the future:
It works that way in Oracle 10g and Oracle 11i as well, and in Oracle XE as well.

jwen ...

but i am new to this ....
so have no clue on how to login as admisn console ?
how to do tht ... can ya elaborate it ..

thanks for the help

check your product documentation.

Have you created a database? If so you would have specified the SYS and SYSTEM passwords. If you haven't done this bit then run the Database Configuration Assistant to help you create a database. If you have created a database and you are using sqlplus you may have to configure your tnsnames.ora file using the net configuration assistant.

Then you could connect using sqlplus

SYSTEM/passwd@tns_servicename

Regards

Alistair

Try this:
write /NOLOG for username and leave password blank.
Then write:
CONNECT / AS SYSDBA
And then:
alter user scott identified by tiger account unlock;

Forgot to mention that in 8i (assuming that you've created a database after installing the binaries) the default passwords are

SYSTEM / MANAGER
SYS / CHANGE_ON_INSTALL

In 9i you are prompted to supply these passwords when you create a database. Use the Database Creation Assistant to help you create a database.

Merry Christmas
Alistair