| SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1] [message #206171] |
Wed, 29 November 2006 00:50  |
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 #206507 is a reply to message #206193] |
Thu, 30 November 2006 06:24  |
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
