change your NLS_LANG to AMERICAN_AMERICA.CHARACTERSET

oerr is a shell script which reads $ORACLE_HOME/rdbms/mesg/$LANG.msg and tells you the error message

oerr ora 942 for example