Skip to Main Content
Forums

Database Software

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL*Loader-704: ORA-12170:

Vidhya Sethuraman-OracleMay 28 2007 — edited Jan 16 2013
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?

Comments

Madrid
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.
Maran Viswarayar
Firewall?Open the Listener port
608582
i am facing this problems "SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]".

any solution psl.
Rahul_India
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
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 13 2013
Added on May 28 2007
#database-key-features, #export-import-sql-loader-external-tables
4 comments
7,647 views