i cannot login to the oracle .. sql plus

what is the error ?

SQL*Plus: Release 8.1.6.0.0 - Production on Thu Apr 7 23:43:22 2005

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

ERROR:
ORA-01034: ORACLE not available
 (the above is when i write the default user scott, pwd tiger, n hoststring my name as i configured in the database)

try this at the sql plus command prompt

connect scott/tiger@host

replace "host" with the schema

if you need to connect with vb, this will get you set.

Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
cn.Open ("Provider=OraOLEDB.oracle;Data Source=host;User Id=scott;Password=tiger;")
   

Oracle indicates the following possible causes:
The SGA requires more space than was allocated for it.

The operating system variable pointing to the instance is improperly defined.

And ORACLE recommends the following remedial action: Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. Retry after ORACLE has been initialised. If ORACLE has been initialised, verify that ORACLE was linked correctly. Also, refer to the installation or user's guide for additional information about this error.

After exhausting all other options, a simple reboot has been observed to resolve this error.

have you tried any of these suggestions? If so, did it work, are the problems the same or does it create new problems?

connect scott/tiger@host


.TNS lister could not resolve SERVICE_Name give ni nthe connect

this is the msg i get

replace host with the name of the database that you configured and make sure you have the tns names configured properly. let me know if you need more info.

Also make sure you have started the listener.

In the windows world it's a service, and in the unix world it is controlled by "lsnrctl start"

if im not mistaken, the error he got signifies that the listener is active... i could be wrong though and it is not a bad idea to make sure it is running.

Axrial, please, post your TNSNAMES.ORA file.

did you have any luck with this, do you know where to find the tnsnames.ora file? I am sure we can get you going if you give us a little more info.

please either respond so that we can help you ,award the points if someone helped you, or close the question if you already have solved this problem or given up.

Anything is better than nothing here...

Even if you solved your problem on your own, we need a status update.

I think that you can split points between astrohelp and jacobhoover.

sorry ppl,

was so out of touch ... couldnt post anything ... that was a well deserved points that i have been keeping to myself ... very sorry for the delay

axrial