Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DB Link - ORA-12170: TNS:Connect timeout occurred error

hari-OracleDec 22 2017 — edited Jan 5 2018

Dear All,

I have a DB link and I am able to query remote_view data using this DB link. Below query is executing successfully and I can see the data.

CT * from remote_view@remote_db

SELECT * from remote_view@remote_db;

then I have used this remote-view in a procedure to populate data into local table..

-- Pseudocode

INSERT INTO local_table

SELECT * from remote_view@remote_db;

When I run this procedure, then it's executing successfully. I am getting no errors and I can see data inserted into local_table.

But when I schedule the same procedure to run as a job using DBMS_SCHEDULER.CREATE_JOB, then I am getting "ORA-12170: TNS:Connect timeout occurred error" for above insert statement.

Any clues what could be going wrong?

Regards,

Hari

This post has been answered by hari-Oracle on Jan 5 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 2 2018
Added on Dec 22 2017
3 comments
8,109 views