Problems Connecting To Oracle 关注

0
Avatar
Legacy Poster

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?

1 评论

0
Avatar
Legacy Poster
评论操作 固定链接

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.

请先登录再写评论。