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
thelearner
Messages: 117
Registered: April 2013
Location: INDIA
Senior Member
Hi,
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
Littlefoot
Messages: 19536
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: Mon Sep 01 17:41:47 CDT 2014

Total time taken to generate the page: 0.12573 seconds