Oracle RSS Oracle RSS

password for sql plus

Reply

•
•
Join Date: Apr 2007
Posts: 1
Reputation: naren228 is an unknown quantity at this point 
Solved Threads: 0
naren228 naren228 is offline Offline
Newbie Poster

password for sql plus

 
0
  #1
Apr 9th, 2007
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
Reply With Quote Quick reply to this message  
•
•
Join Date: Feb 2007
Posts: 2,070
Reputation: debasisdas will become famous soon enough debasisdas will become famous soon enough 
Solved Threads: 124
debasisdas's Avatar
debasisdas debasisdas is offline Offline
Postaholic

Re: password for sql plus

 
0
  #2
Jun 6th, 2007
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.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2007
Posts: 30
Reputation: grii_19 is an unknown quantity at this point 
Solved Threads: 0
grii_19 grii_19 is offline Offline
Light Poster

Re: password for sql plus

 
0
  #3
Apr 26th, 2008
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
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2004
Posts: 6,145
Reputation: jwenting is just really nice jwenting is just really nice jwenting is just really nice jwenting is just really nice 
Solved Threads: 212
Team Colleague
jwenting's Avatar
jwenting jwenting is offline Offline
duckman

Re: password for sql plus

 
0
  #4
Apr 26th, 2008
same way... Log in to the admin console and unlock the account(s) you want to use.
As people are clearly allowed to attack me but I'm not allowed to defend myself, I no longer post to this site.
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2004
Posts: 6,145
Reputation: jwenting is just really nice jwenting is just really nice jwenting is just really nice jwenting is just really nice 
Solved Threads: 212
Team Colleague
jwenting's Avatar
jwenting jwenting is offline Offline
duckman

Re: password for sql plus

 
0
  #5
Apr 26th, 2008
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.
As people are clearly allowed to attack me but I'm not allowed to defend myself, I no longer post to this site.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2007
Posts: 30
Reputation: grii_19 is an unknown quantity at this point 
Solved Threads: 0
grii_19 grii_19 is offline Offline
Light Poster

Re: password for sql plus

 
0
  #6
Apr 26th, 2008
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
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2004
Posts: 6,145
Reputation: jwenting is just really nice jwenting is just really nice jwenting is just really nice jwenting is just really nice 
Solved Threads: 212
Team Colleague
jwenting's Avatar
jwenting jwenting is offline Offline
duckman

Re: password for sql plus

 
0
  #7
Apr 27th, 2008
check your product documentation.
As people are clearly allowed to attack me but I'm not allowed to defend myself, I no longer post to this site.
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2006
Posts: 44
Reputation: alit2002 is an unknown quantity at this point 
Solved Threads: 1
alit2002 alit2002 is offline Offline
Light Poster

Re: password for sql plus

 
0
  #8
May 7th, 2008
•
•
•
•
Originally Posted by grii_19 View Post
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
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2008
Posts: 1
Reputation: Cyrus11 is an unknown quantity at this point 
Solved Threads: 0
Cyrus11 Cyrus11 is offline Offline
Newbie Poster

Re: password for sql plus

 
0
  #9
Dec 9th, 2008
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;
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2006
Posts: 44
Reputation: alit2002 is an unknown quantity at this point 
Solved Threads: 1
alit2002 alit2002 is offline Offline
Light Poster

Re: password for sql plus

 
0
  #10
Dec 24th, 2008
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
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the Oracle Forum
Thread Tools Search this Thread



2009predictions acquisition amazon.com bartz bernanke cia citrix cloudcomputing crm database dell economy enterprise enterprise2.0 enterprisesoftware federalreserve forbes hp ibm intellipedia internet larryellison layoffs linux loughridge mediawiki michaeljackson microsoft neverland nortel notebooks oil operatingsystem oracle palm rimm saas salesforce sap seagate socialcomputing sun sybase technologystocks virtualiron virtualization vmware wiki wikipedia xen yahoo zoho
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC