Hi

>I tested "tnsping red.domain.tld" as well as "tnsping red" and did the same with "sqlpllus
>user/pwd@(protected).
>
>But if using my java app (jdbc:oracle:thin:system/pwd@(protected):
>
>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@(protected)"?


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