•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 332,654 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,327 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser:
Views: 2023 | Replies: 7
 |
•
•
Join Date: Apr 2007
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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
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
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,035
Reputation:
Rep Power: 4
Solved Threads: 61
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.
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.
•
•
Join Date: Jul 2007
Posts: 30
Reputation:
Rep Power: 1
Solved Threads: 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
i downloaded it and installed it ...
but i just cant log-in ...
any clues how to resolve this problem
•
•
Join Date: Nov 2004
Location: Netherlands
Posts: 5,325
Reputation:
Rep Power: 17
Solved Threads: 168
same way... Log in to the admin console and unlock the account(s) you want to use.
42 Private messages asking for help will be ignored
In the frozen land of Nador they were forced to eat Steve's iMinstrels, and there was much rejoicing.
In the frozen land of Nador they were forced to eat Steve's iMinstrels, and there was much rejoicing.
•
•
Join Date: Nov 2004
Location: Netherlands
Posts: 5,325
Reputation:
Rep Power: 17
Solved Threads: 168
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.
It works that way in Oracle 10g and Oracle 11i as well, and in Oracle XE as well.
42 Private messages asking for help will be ignored
In the frozen land of Nador they were forced to eat Steve's iMinstrels, and there was much rejoicing.
In the frozen land of Nador they were forced to eat Steve's iMinstrels, and there was much rejoicing.
•
•
Join Date: Jul 2007
Posts: 30
Reputation:
Rep Power: 1
Solved Threads: 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
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
•
•
Join Date: Nov 2004
Location: Netherlands
Posts: 5,325
Reputation:
Rep Power: 17
Solved Threads: 168
check your product documentation.
42 Private messages asking for help will be ignored
In the frozen land of Nador they were forced to eat Steve's iMinstrels, and there was much rejoicing.
In the frozen land of Nador they were forced to eat Steve's iMinstrels, and there was much rejoicing.
•
•
Join Date: Dec 2006
Posts: 23
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by grii_19 
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
|
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
Linear Mode
- Setup and Run MSDE. (MS SQL)
- sql server 2000 on win-xp pc (MS SQL)
- Connection must be valid and open (MySQL)
- Quick VB2005 help....how do I get this basic app started? (VB.NET)
- Help with Roles Stored in SQL database (ASP.NET)
- Password (Visual Basic 4 / 5 / 6)
- JSTL compare string (JSP)
- Simple ASP.Net Login Page (Using VB.Net) (ASP.NET)
- connecting to mssql with using jsp (JSP)
- Retrieving a field from a SQL procedure (ASP)
Other Threads in the Oracle Forum
- Previous Thread: find which tables get updated..
- Next Thread: Error 3509 In TNSPING...
