| SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #69237] |
Tue, 27 November 2001 10:28  |
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  |
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 #71939 is a reply to message #69237] |
Fri, 07 February 2003 22:51 |
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 #435592 is a reply to message #69603] |
Thu, 17 December 2009 00:30 |
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 |
|
|
|
|
|
| SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #452454 is a reply to message #69237] |
Thu, 22 April 2010 03:35 |
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 #464249 is a reply to message #69237] |
Wed, 07 July 2010 02:11 |
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.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
