oracle-12170 dblink,DB Link - ORA-12170: TNS:Connect timeout occurred error

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.SELECT * from [email protected]_db;

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

-- PseudocodeINSERT INTO local_tableSELECT * from [email protected]_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