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: Internal error: ulconnect: OCIServerAttach [0]

3373013Jan 23 2017 — edited Jan 24 2017

Hi All,

I have an Oracle DB 12c installed on my laptop. I am able to database objects in the HR schema. And have a SYS and PDB as well.

When running a SQLLOADER from the command prompt, I am getting the below error:

C:\WINDOWS\system32>cd\

C:\>cd C:\app\sunita\product\12.1.0\dbhome_1\BIN

C:\app\sunita\product\12.1.0\dbhome_1\BIN>sqlldr userid=sys/Password@xe control=FixedDataControlFile.ctl

SQL*Loader: Release 12.1.0.2.0 - Production on Mon Jan 23 20:50:49 2017

SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12154: TNS:could not resolve the connect identifier specified

Kindly advise.

Note: FixedDataControlFile.ctl is kept in C:\app\sunita\product\12.1.0\dbhome_1\BIN.

Thank you.

This post has been answered by AndrewSayer on Jan 23 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 21 2017

Added on Jan 23 2017

#database-key-features, #export-import-sql-loader-external-tables

37 comments

22,829 views