OCIEnvNlsCreate

Document ID : KB000089515
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
OCIEnvNlsCreate
Resolution:
Detailed Description and Symptoms

U0003590 DB error: 'OCIEnvNlsCreate', 'ERROR   ', '', 'Error while trying to retrieve text for error ORA-01804'?

This message occurs because of missing OracleClient environment settings.
 


Solution

It is recommended to set the necessary env-settings like ORACLE_HOME, NLS_LANG and LD_LIBRARY_PATH (SUN Solaris, LiNUX) or LIBPATH (AIX) or SHLIB_PATH (HPUX) not over a user profile but direct in a shell-script

Sample:
 export ORACLE_HOME=/oracle/product/11.2.0
 export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15
 export LIBPATH=$PWD/bin:$ORACLE_HOME/lib:/usr/lib:/lib?