New to Oracle10g

I am trying to execute a script, it gives me the error
SP2-0640: not connected
I then select to connect, type in my username, password, service, and select SYSDBA as the connect. I then get the error
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor.
I checked my tnsnames.ora file and it is listed in there, what else can I do to fix this?

Thanks for your help
Katie

KLK12345

Newbie Poster

1 post since Sep 2010

Reputation Points: 10

Solved Threads: 0

1 Year Ago

the error message is self explanatory.

check if the target database is up and running.

debasisdas

Posting Genius

6,872 posts since Feb 2007

Reputation Points: 666

Solved Threads: 434

This question has already been solved

You