|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
April 24th, 2005, 10:52 AM
|
|||
|
|||
|
Cant login SQL*Plus
i have installed Oracle10g, but i cant log into SQL*Plus.
it prompts me for the Username, Password and Host String. i key in the SYSTEM with the corresponding password, but i din work fine, showing an error message below: Quote:
what should i do to fix this problem? in fact, i can log into Web-based Enterprise Manager using the same SYSTEM (password). i am new to it and hope to learn more about that... -- thank you 
|
|
#2
April 25th, 2005, 11:06 AM
|
|||
|
|||
|
There is a file on your local PC/workstation called tnsnames.ora.
You have to edit that file and add the information about the name of ther SID (Oracle instance) you want to connect to.. The file in the distribution has example entries.
|
|
#3
April 25th, 2005, 12:35 PM
|
|||
|
|||
|
what should i change in order to log in? cant really understand the syntax shown.
by the way, why i cant go through the web based Enterprise Manager now? i type the same URL with http://<hostname>:5500 (listen port)/em but an error message was shown. what have i did wrong? the following is the error shown: Quote:
--thank you
|
|
#4
May 11th, 2005, 05:44 AM
|
|||
|
|||
|
the question is did you changed the system password while installing Oracle... it must be changed either when you are installing Oracle or after first login...
any way iam not sure of this but i think you can login as the user scott with password tiger and chang the system password..try
|
|
#5
May 11th, 2005, 05:49 AM
|
||||
|
||||
|
Are you shure the instance is running/has successfully started??
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Cant login SQL*Plus |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
