This discussion is archived
4 Replies Latest reply: Jan 16, 2013 12:01 AM by Rahul_India RSS

SQL*Loader-704: ORA-12170:

579957 Newbie
Currently Being Moderated
I am using Oracle Data Integrator to load a flat file into a remote db(oracle 10gR2) using SQLLDR. It fails with the following log.

SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12170: TNS:Connect timeout occurred

However i tried to load the flat file using SQLLDR from the cmd prompt and it works fine. Can someone help me with this?