Problems Connecting To Oracle

Legacy Poster

• July 18, 2013 16:36

Hi, 

 

I keep getting ORA-12660 while trying to connect to my remote oracle instance. Using the exact same TNS data connecting is successful with Sql Developer, so I'm a bit confused. 

 

Originally I tried to use the Microsoft ODB but that caused ORA-12504 (SERVICE_NAME not in CONNECT_DATA even though the SID is there). No configurations on sqlnet have any effect on this. Interestingly I noticed that if you use Connection Identifier (which has the exact same data as in tnsnames.ora for the server) it fails too. 

 

Any ideas?

0

• 

  Legacy Poster

  ★ BarTender Hero ★

  • July 19, 2013 07:32

  Nevermind. I had installed Oracle Server version instead of the client version. Apparently the server package does NOT include necessary drivers to actually connect to a remote oracle server that requires encryption.

  0

Please sign in to leave a comment.