OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Sql loader error (oracle 11g , windows 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sql loader error [message #596332]

Fri, 20 September 2013 14:00

thelearner
Messages: 133
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.

Report message to a moderator

Re: Sql loader error [message #596333 is a reply to message #596332]

Fri, 20 September 2013 14:54

Littlefoot
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.

Report message to a moderator

Previous Topic:	ISO Receiving
Next Topic:	Barcode on Asset

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

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