Database Utilities (MOSC)

MOSC Banner

sqlldr v11 Unable to locate character set handle for character set ID

edited Aug 30, 2012 1:39AM in Database Utilities (MOSC) 1 commentAnswered ✓
  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.

# .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 USERNAME

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center