| 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!!!
|
|
|
|
| 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.
|
|
|
|
|
|
| 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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
