Sql*Loader-704 ORA-12154 Connecting To a Client Machine (Doc ID 1301098.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Net Services - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

If you run SQL*Loader using a connect string from an OS user that it's not the owner of Oracle software you can get the errors:

SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12154: TNS:could not resolve service name


The connect string is like:

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms