question

Kirman avatar image
Kirman asked

Oracle Rdb Database - Connection Time Out Error

I have a SQL Agent Job . There is a TSQL Command. In TSQL Commad we have the Openquery which gets connected to Oracle Rdb database. The job fails stating the connection time out. I want to know where exactly in Oracle Rdb database I can go and change the Connection time out settings. Please help !
sqloracle
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

Kirman avatar image Kirman commented ·
Any thoughts on the above query... Thanks
0 Likes 0 ·

1 Answer

·
alexsdba avatar image
alexsdba answered
See if this query works for you: SELECT * FROM OPENQUERY(your_oracle_linked_server, 'select sysdate from dual') If it doesn't then check your linked server/ODBC settings.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

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.