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 #70147]

Mon, 22 April 2002 00:05

Matthias Schaper
Messages: 1
Registered: April 2002

Junior Member

I tried using the sqlldr locally to load data to the
server. I received the error message.
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [[0]]
ORA-12560: TNS:protocol adapter error
Is there any ora file that I should change or update to be able to use sqlldr from client to load data in the server. Thanks in advance!!!

Report message to a moderator

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

Thu, 06 February 2003 23:04

Sethuram
Messages: 2
Registered: February 2003

Junior Member

I got the Same message and was resolved by removing the IP address after the username and password.

The correct way to use sql Loader is
sqlldr username/password@SIDname control='controlfilename.ctl' log='logfilename.log'

Do not use
sqlldr username/password@IPADRESS:SIDname control='controlfilename.ctl' log='logfilename.log'

and also Check for the SID Name in your tnsnames.ora file.

Report message to a moderator

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

Fri, 07 February 2003 09:03

kat
Messages: 15
Registered: February 2000

Junior Member

Hi guys!

Thank you very much! That also was my problem the _whole_ afternoon.

IP address instead of the servicename...unbelievable...

But why is it not possible to make it using the real servicename? Is ist a bug?

Greetz
kat

Report message to a moderator

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

Tue, 14 December 2004 06:07

Liz Todak-Norem
Messages: 1
Registered: December 2004

Junior Member

I am getting the following error.
ORA-12545: Connect failed because target host or object does not exist
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach �-1�

Here is my JCL:
//TNSNAMES DD *
IFMSUSR1= (DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)
(PORT=1525)
(HOST=smrs106a.stl.mo.boeing.com)
(SSN=TN19)
)
(CONNECT_DATA=(SID=IFMSUSR1))
)
//LOGON DD *
USERID=userid/password@IFMSUSR1

This is going to a test server, I do this daily to
the production server, do you see anything wrong with
this?

Report message to a moderator

Previous Topic:	redirect export in windows to zip
Next Topic:	FAL_CLEINT,FAL_SERVER

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 07 03:10:17 CDT 2025