SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1]
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.
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Click Here to Expand Forum to Full Width
Bookmarks