search cancel

OCIEnvNlsCreate

book

Article ID: 89515

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

OCIEnvNlsCreate

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

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?