Member Avatar for KLK12345

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

Edited by KLK12345 because: n/a
  • 2 Contributors
  • 1 Reply
  • 68 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

the error message is self explanatory.

check if the target database is up and running.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.