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

[suvv]

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.

[Bore]

OCIEnvCreate returns -1 what means it failed. As I see the function is related with the connnection establishing and fails most often because of:
1) lack of priviledges on some OCI shared libaries
2) Lack of PATH to the shared libraries (check LD_LIBRARY_PATH and PATH)
3) Messed up tnsnames.ora

I hope that's a hint. Just google and search metalink and otn for OCIEnvCreate problems

[suvv]

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.