Home » RDBMS Server » Server Utilities » SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #69237] Tue, 27 November 2001 10:28 Go to next message
Wally
Messages: 3
Registered: November 2001
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 #69603 is a reply to message #69237] Wed, 06 February 2002 11:21 Go to previous messageGo to next message
Thomas Zezulka
Messages: 1
Registered: February 2002
Junior Member
Wally,
I was having the same problem when my machine crashed and I had to put on Oracle8si. The problem is Oracle8si no longer will look directly at your database sid name so you can't use it in the sql loader command line. You have to create a local service name calling your database. So what you call in the command line is the name of your local service name. Let me know if you need more help. Thanks, Thomas
Re: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #70162 is a reply to message #69237] Tue, 23 April 2002 08:08 Go to previous messageGo to next message
Anurag Garg
Messages: 1
Registered: April 2002
Junior Member
Try using this command

sqlldr username/password@service control='controlfile.ctl' log='logfile.log'

make sure that ur .dat file is in the path.

Hope this helps

Regds
Anurag garg
Re: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #70187 is a reply to message #69237] Fri, 26 April 2002 09:53 Go to previous messageGo to next message
Bernardo Zamora
Messages: 1
Registered: April 2002
Junior Member
This really really helped a lot, it was exactly what was happening! (and nowhere had I seen the @.... parameter)
Re: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #71939 is a reply to message #69237] Fri, 07 February 2003 22:51 Go to previous messageGo to next message
Sethuram
Messages: 2
Registered: February 2003
Junior Member
As kant has asked this is not a bug, It is the way Oracle has designed it.

SQL Loader uses all internals of oracle to push in the files to the database.

So Oracle not concerned with the ip or anything which you specify externally. He uses the service name which you have in the tnsnames.ora.

If you think around this is the efficient way for inserting.
Re: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #74788 is a reply to message #69603] Wed, 16 February 2005 16:46 Go to previous messageGo to next message
Yolanda Dimitri
Messages: 1
Registered: February 2005
Junior Member
Hello Guys, I have the same problem.

How do I create alocal service name calling My DB
Re: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #435592 is a reply to message #69603] Thu, 17 December 2009 00:30 Go to previous messageGo to next message
baktash.siddiqi
Messages: 3
Registered: December 2009
Location: Kabul,Afghanistan
Junior Member
Hi,

When i run the sql loader script i get below error... Help Pls.

Error: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12546: TNS:permission denied


Script: #!/bin/bash

# Veriables
LOGDIR=/export/home/oracle/VOM_LOGS
DTEXT=`date '+%U%m%d'`
SCRIPTDIR=/export/home/oracle/SCRIPTS
INPUTDIR=/backup/loaded_voms/INPUT
BACKUPDIR=/backup/loaded_voms
PATH=/u01/app/oracle/product/10.2.0/Db_1/bin; export PATH
ORACLE_HOME=/u01/app/oracle/product/10.2.0/Db_1; export ORACLE_HOME
DATETIME=`date +%Y%m%d%H%M`

ORACLE_SID=billing123; export ORACLE_SID

sqlldr TSI/TSI control=${SCRIPTDIR}/voms.ctl direc
mv ${INPUTDIR}/VOMS_LOAD_DATA.txt ${BACKUPDIR}/VOM

gzip /${BACKUPDIR}/VOMS_LOAD_DATA.loaded$DATETIME

Kind Regards

[Updated on: Thu, 17 December 2009 00:32]

Report message to a moderator

Re: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #435597 is a reply to message #435592] Thu, 17 December 2009 00:57 Go to previous messageGo to next message
Michel Cadot
Messages: 63814
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the OS user that executes this?

Regards
Michel
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #452454 is a reply to message #69237] Thu, 22 April 2010 03:35 Go to previous messageGo to next message
siva.n.subramanian
Messages: 10
Registered: April 2009
Junior Member
hi,

i am getting the following error while loading the data through control file. I tried the above mentioned solution but it did not work.

The error is as follows:

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

I typed sqlldr userid/password@service.. wht i want to knw is as my passwd ends with @ will oracle accept it... dont knw... pls guide...

thanks in advance....


regards
N.Siva
Re: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #452457 is a reply to message #452454] Thu, 22 April 2010 04:14 Go to previous messageGo to next message
Michel Cadot
Messages: 63814
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Enclose your password between "

Regards
Michel
Re: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #464249 is a reply to message #69237] Wed, 07 July 2010 02:11 Go to previous messageGo to next message
advcomm
Messages: 1
Registered: October 2005
Location: pakistan
Junior Member

faced the following error and solution is very very simple
C:\>sqlldr uuser control='E:\test_ctl.ctl'
Password:
SQL*Loader: Release 10.2.0.1.0 - Production on Wed Jul 7 11:11:45 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12560: TNS:protocol adapter error
as the last line show that (ora-12560) its sid is not set. please use for windows at cmd
set ORACLE_SID=YOUR_SID
for linux
ORACLE_SID=YOUR_SID

Cheers.
Re: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #464253 is a reply to message #464249] Wed, 07 July 2010 02:28 Go to previous messageGo to next message
Michel Cadot
Messages: 63814
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you realize that you have registered to answer a question from year 2001?

Regards
Michel

Re: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #515765 is a reply to message #69237] Wed, 13 July 2011 03:56 Go to previous messageGo to next message
adnanmkm
Messages: 3
Registered: June 2011
Location: Abudhabi,U.A.E
Junior Member

Dear ,

make sure that your using correct login ?
i mean full privilaged os user..
example:- oracle

Cheers

Adnan

Re: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #515771 is a reply to message #515765] Wed, 13 July 2011 04:06 Go to previous message
Michel Cadot
Messages: 63814
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same thing for you, do not expect any answer from OP.

I lock the topic.

Regards
Michel
Previous Topic: Dump from 9i DB to be imported to 11g directly
Next Topic: How can i get the total time when using export a table(2 Merged)
Goto Forum:
  


Current Time: Fri Sep 30 14:03:57 CDT 2016

Total time taken to generate the page: 0.17703 seconds