I have upgraded our database from 11.2.0.3 to 11.2.0.4. we have a sql loader job which kicks off from different user than oracle on the same DB server.
I am getting the following error when I try to run the sqlldr.
# sqlldr USERID=bk2x/****** CONTROL=/TPAR/CLIENT/BK2X/EXT96101.ctl LOG=EXT96101_4.log
SQL*Loader: Release 11.2.0.4.0 - Production on Mon Oct 16 19:00:57 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1]
========================
I do have correct environment setup:
# id
uid=18911(invtech) gid=2003(invtech)
invtech@r02jbdbs04a [/home/invtech]
# env
_=/usr/bin/env
MANPATH=/usr/perl5/5.8.4/man:/usr/perl5/5.8.3/man:/usr/perl5/5.6.1/man:/usr/apache2/man:/usr/jdk/instances/jdk1.6.0/man:/usr/jdk/instances/jdk1.5.0/man:/usr/openv/java/jre/man:/usr/apache/man:/usr/openwin/share/man:/usr/lib/cc-ccr/man:/usr/lib/gnome-private/share/man:/usr/X11/share/man:/usr/dt/share/man:/usr/share/webconsole/man:/usr/share/man:/usr/postgres/8.3/man:/usr/sfw/share/man:/usr/j2se/man:/usr/local/man:/usr/local/share/man:/usr/local/ssl/man:/opt/FJSVvts/man:/opt/SUNWvts/man:/opt/SUNWrtvc/man:/opt/SUNWsneep/man
HZ=
PATH=/oracle_TKRDY01/product/11.2.0.4/bin:/usr/ccs/bin:/opt/syncsort/bin:/usr/bin:/bin:/usr/ucb:/usr/sbin:/usr/local/bin:/usr/bin:/opt/sudo/bin:.
ORACLE_BASE=/oracle_TKRDY01
ORACLE_PATH=/oracle_TKRDY01/product/11.2.0.4/bin
EDITOR=vi
LOGNAME=invtech
MAIL=/var/mail/invtech
MOZILLA_HOME=/opt/NSCPcom
PS1=
invtech@r02jbdbs04a [$PWD]
#
ORACLE_LIB_PATH=/oracle_TKRDY01/product/11.2.0.4/lib
DISPLAY=:0.0
SHELL=/bin/ksh
JAVA_HOME=/usr/java
HOME=/home/invtech
LD_LIBRARY_PATH=/oracle_TKRDY01/product/11.2.0.4/lib:/usr/lib:/usr/ucb/lib:/opt/syncsort/lib:/usr/dt/lib
TERM=vt220
ORACLE_HOME=/oracle_TKRDY01/product/11.2.0.4
PWD=/home/invtech
TZ=US/Central
ENV=/home/invtech/.kshrc