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 USERNAME
0