question

DeepakSahu avatar image
DeepakSahu asked

Getting ORA-12170: TNS:Connect timeout occurred when trying to TEST Connection on linked server.

Hi, Getting ORA-12170: TNS:Connect timeout occurred when trying to TEST Connection on linked server. Checked the connectivity from the oracle side and it shows successful. Checked the TNS entry in tnsnames.ora and was able to tnsping the service ID. Also able to Telnet the Service ID. From sQLPLUS the connection is showing successful but when trying to test the connection from the SSMS Linked server its failing with ORA-12170: TNS:Connect timeout. Any suggestions on why we are getting this error? Thanks.
oraclelinked-serverconnectivity
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.