sqlldr v11 Unable to locate character set handle for character set ID
Good day,
Having recently migrated to a 11g oracle database(11.2.0.1.0) from 9i on a test server, running SQL loader gives/throws the above error in the subject line.
I've seen a few posts about this but with pretty vague explanations, below is what my bash profile looks like though and i compared NLS_PARAMETERS to another server that already has version 11 running.
Having recently migrated to a 11g oracle database(11.2.0.1.0) from 9i on a test server, running SQL loader gives/throws the above error in the subject line.
I've seen a few posts about this but with pretty vague explanations, below is what my bash profile looks like though and i compared NLS_PARAMETERS to another server that already has version 11 running.
# .bash_profile
# Get the aliases and functions
<font color="navy"><b>if</b></font> [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
export ORACLE_SID=mtctst
export ORA_NLS10=$ORACLE_HOME/nls/data
export ORACLE_BASE=/oracle/app/product
export ORACLE_HOME=/oracle/client/11.2.0/dbhome_1
#export ORACLE_HOME=/oracle/client/9.2.0
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib/X11; export LD_LIBRARY_PATH
PATH=$ORACLE_HOME/bin:$HOME/bin:/bin:/usr/bin:/usr/local/bin:/bin/X11;
export PATH
#export LD_LIBRARY_PATH=$ORACLE_HOME/lib
#LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$LD_LIBRARY_PATH
#LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
#export LD_LIBRARY_PATH
#export LD_LIBRARY_PATH_64
#PATH=$ORACLE_HOME/bin:$HOME/bin:/bin:/usr/bin:/usr/local/bin:/usr/bin/X11; export PATH
#PATH=$PATH:$HOME/bin
#export PATH
umask 002
unset USERNAME0