Home » Applications » Oracle Fusion Apps & E-Business Suite » Sql loader error (oracle 11g , windows 7)
Sql loader error [message #596332] Fri, 20 September 2013 14:00 Go to next message
Messages: 133
Registered: April 2013
Location: INDIA
Senior Member
In my system I created a table in XE and trying to insert data using SQL loader....
I given the path of the .CSV file, but I am getting this error...
In toad also I checked the TNS connections everything is fine....
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12154: TNS:could not resolve the connect identifier specified

but in other systems it is working properly...
Please help me ,

Thank you,
The Learner.
Re: Sql loader error [message #596333 is a reply to message #596332] Fri, 20 September 2013 14:54 Go to previous message
Messages: 21759
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There is more than one copy of TNSNAMES.ORA file on your computer. TOAD uses the one that contains alias for the database you are connecting to. SQL*Loader uses one that doesn't contain it. In order to avoid such problems, use TNS_ADMIN environment variable. Some more info here.
Previous Topic: ISO Receiving
Next Topic: Barcode on Asset
Goto Forum:

Current Time: Thu Mar 23 05:38:29 CDT 2023