password for sql plus
 

i hav just installed oracle 8i on my laptop
but i am not able to open the sql plus
what is the user name & password??
i hav tried scott &tiger but not working
please reply soon

Re: password for sql plus
 

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.

Re: password for sql plus
 

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

Re: password for sql plus
 

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

Re: password for sql plus
 

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.

Re: password for sql plus
 

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

Re: password for sql plus
 

check your product documentation.

Re: password for sql plus
 

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