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
naren228 0 Newbie Poster
debasisdas 580 Posting Genius Featured Poster
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.
grii_19 0 Light Poster
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
jwenting 1,889 duckman Team Colleague
same way... Log in to the admin console and unlock the account(s) you want to use.
jwenting 1,889 duckman Team Colleague
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.
grii_19 0 Light Poster
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
jwenting 1,889 duckman Team Colleague
check your product documentation.
alit2002 0 Junior Poster in Training
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
Cyrus11 0 Newbie Poster
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;
alit2002 0 Junior Poster in Training
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
bhawna bharat 0 Newbie Poster
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.