My Oracle Support Banner

Error While Running Sql Loader In ATP DB (Doc ID 2954304.1)

Last updated on JUNE 13, 2023

Applies to:

SQL*Plus - Version 19.10 and later
Information in this document applies to any platform.

Symptoms

Issue
----------
Error while loading data to Autonomous database using SQL Loader shipped with Instant Client.

Error
----------

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



Changes

 This is new setup and wallet zip file has been downloaded for the Autonomous database. Zip file is unzipped and TNS_ADMIN is set to refer to unzipped location.
 Say for example, TNS_ADMIN=<location>\Wallet_unzip, here <location> is full path to the unzipped wallet zip content and the unzipped folder is Wallet_unzip.So full path to tnsnames.ora file is <location>\Wallet_unzip

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.