Home » RDBMS Server » Server Utilities » SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1]
SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1] [message #206171] Wed, 29 November 2006 00:50 Go to next message
suvv
Messages: 17
Registered: October 2006
Junior Member
I have logged in as Oracle Operating system user and started data loading for
one database user using SQLLDR, data is loading without any problem.

I logged in as other(sup_load) Operating system user and I tried to load data
using SQLLDR for the same(sup) database user. I am getting the error

" SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1]"


$ whoami
sup_load

$ pwd
/home/sup_load

$ export ORACLE_HOME=/u111/app/oracle/product/10.2
$ export ORACLE_SID=migsso

$ ls -ltr
total 96
-rw-rw-r-- 1 sup_load users 163 Nov 28 07:33 aubCO3A2006.A
-rw-rw-r-- 1 sup_load users 1795 Nov 28 07:35 pir_seca.ctl
-rw-rw-r-- 1 sup_load users 192 Nov 28 07:37 aubCO3A2006.log

$ $ORACLE_HOME/bin/sqlldr sup/sup control=pir_seca.ctl bad=aubCO3A2006.bad
log=aubCO3A2006.log data=aubCO3A2006.A

SQL*Loader: Release 10.1.0.4.2 - Production on Tue Nov 28 07:37:56 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1]

We checked as user permission and and environment variables, we checked for
Oracle user, and tested in the $ORACLE_HOME/bin directory itself still we are
getting the same error.
Re: SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1] [message #206193 is a reply to message #206171] Wed, 29 November 2006 02:28 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Your ORACLE_HOME variable is not set to the correct software version:

Quote:
$ export ORACLE_HOME=/u111/app/oracle/product/10.2


Quote:
SQL*Loader: Release 10.1.0.4.2 - Production on Tue Nov 28 07:37:56 2006

Re: SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1] [message #206507 is a reply to message #206193] Thu, 30 November 2006 06:24 Go to previous messageGo to next message
suvv
Messages: 17
Registered: October 2006
Junior Member
We have added the following environment variable in the user's dot profile as
well as in the dollar prompt.

ORACLE_HOME=/u111/app/oracle/product/10.2; export ORACLE_HOME
ORACLE_SID=migsso; export ORACLE_SID
PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export SHLIB_PATH=$ORACLE_HOME/lib32

The Readonly and execute permission assinged for the directory u111 and its
subsequent subdirectories ( the Oracle Home which is installed under u111).

Still we are facing problem O/S user SUP_LOAD. There is no problem with ORACLE
O/S user. For SUP_LOAD user, It is reading SQLLDR file, but it is not loading
the data file.
Re: SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1] [message #305432 is a reply to message #206171] Mon, 10 March 2008 14:12 Go to previous message
karluk
Messages: 1
Registered: March 2008
Junior Member
This error appears to be caused by the bug discussed in Metalink document 361325.1. We got this error messages from a customer trying to use SQL*Loader via Citrix. The Oracle 10.2.0.1 client on the Citrix server was working correctly for Citrix administrators, but the customer didn't have sufficient privileges and got the SQL*Loader-704 error.

The fix was to apply the 10.2.0.3 patch set to the Oracle client. The Metalink article also says it's possible to fix the problem by granting additional permissions without installing the 10.2.0.3 patch set, but we didn't test this.
Previous Topic: Import related query!
Next Topic: Backup error import
Goto Forum:
  


Current Time: Thu Dec 08 06:01:30 CST 2016

Total time taken to generate the page: 0.10276 seconds