OraFAQ Forum: Server Utilities » SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]

Home » RDBMS Server » Server Utilities » SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]

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

SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #178605]

Wed, 21 June 2006 15:24

punnami
Messages: 3
Registered: June 2006

Junior Member

I am trying to load the bulk data from csv file to database using sql loader. I got the following message..

SQL*Loader: Release 9.2.0.1.0 - Production on Wed Jun 21 16:10:13 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

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

I am very thankful to you in advance for providing me clue..

Report message to a moderator

Re: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #178610 is a reply to message #178605]

Wed, 21 June 2006 16:22

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>ORA-12154: TNS:could not resolve service name
Are you using the right service name? is the database up?
Post what you did (command line parameters)

Report message to a moderator

Re: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #178612 is a reply to message #178610]

Wed, 21 June 2006 16:43

punnami
Messages: 3
Registered: June 2006

Junior Member

yes, I am using right service name and the database is up

Report message to a moderator

Re: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #178615 is a reply to message #178610]

Wed, 21 June 2006 16:45

punnami
Messages: 3
Registered: June 2006

Junior Member

c:\XYZ sqlldr abc/abc@test control=TEMP.ctl is the command I have used

Report message to a moderator

Re: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #178620 is a reply to message #178615]

Wed, 21 June 2006 19:43

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Edit your sqlnet.ora.
Comment all the entries.
Try again.

Report message to a moderator

Previous Topic:	copy table from one instance to another
Next Topic:	SQL*Loader (Sequence problems and more)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 08:44:26 CST 2024