SQL*Loader-704: ORA-12170:

User576954-Oracle May 28, 2007 1:29 PM

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:

Madrid May 29, 2007 1:50 AM (in response to User576954-Oracle)

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.
Like Show 0 Likes(0)

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

Maran Viswarayar May 29, 2007 4:17 AM (in response to User576954-Oracle)

Firewall?Open the Listener port
Like Show 0 Likes(0)

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

608582 Nov 14, 2007 6:09 PM (in response to User576954-Oracle)

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

any solution psl.
Like Show 0 Likes(0)

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

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

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
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.

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