RE: newbie question regarding JDBC and CMAN

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <md@xxxxxxxxxxxxx>
  • Date: Wed, 15 Mar 2006 18:49:37 +0100

Hi

>I tested "tnsping red.domain.tld" as well as "tnsping red" and did the same 
>with "sqlpllus
>user/pwd@xxxxxxxxxxxxxx" as well as with "sqlpllus user/pwd@red" sucessfully.
>
>But if using my java app (jdbc:oracle:thin:system/pwd@DB-HOST:1630:red)I get:
>
>ORA-12505, TNS:listener does not currently know of SID given in connect 
>descriptor

Probably the SID is not "RED". You should check tnsnames.ora... (or where else 
the TNS alias is resolved)

Have you tried to connect through OCI with the connect string 
"jdbc:oracle:oci:system/pwd@red"?


HTH
Chris
--
//www.freelists.org/webpage/oracle-l


Other related posts: