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

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.

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

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

tell me the user name and password of sql plus..
i have tried scott and tiger but its not working...soo rply me ......sooooooooonnnnnnnnn

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.