SQL*Loader-704: ORA-12170:

579957 May 28, 2007 6:29 AM

Currently Being Moderated

Hi,
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?

1. Re: SQL*Loader-704: ORA-12170:

427879 May 28, 2007 6:50 PM (in response to 579957)

Currently Being Moderated

This is a connectivity issue, first check the sqlnet.log file. Next try to open a regular connection using sqlplus and see if it can be established.
Post the contents of the sqlnet.log and other related log files from the time the error pops up.
Report Abuse

Like (0)
2. Re: SQL*Loader-704: ORA-12170:

Maran Viswarayar May 28, 2007 9:17 PM (in response to 579957)

Currently Being Moderated

Firewall?Open the Listener port
Report Abuse

Like (0)
3. Re: SQL*Loader-704: ORA-12170:

608582 Nov 14, 2007 10:09 AM (in response to 579957)

Currently Being Moderated

i am facing this problems "SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]".

any solution psl.
Report Abuse

Like (0)
4. Re: SQL*Loader-704: ORA-12170:

Rahul_India Jan 16, 2013 12:01 AM (in response to 608582)

Currently Being Moderated

user605579 wrote:
i am facing this problems "SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]".

any solution psl.
try to run your command prompt in ADMIN mode Then it should work

Edited by: Rahul India on Jan 16, 2013 1:30 PM
Report Abuse

Like (0)

Go to original post

SQL*Loader-704: ORA-12170:

**1. Re: SQL*Loader-704: ORA-12170:**

**2. Re: SQL*Loader-704: ORA-12170:**

**3. Re: SQL*Loader-704: ORA-12170:**

**4. Re: SQL*Loader-704: ORA-12170:**

Actions