In Linux, occi is compiled using the Oracle database installed by oracle users.ProgramThere is no problem with the execution under the Oracle user, but an exception is reported under other users. The exception information is:
"ExceptionCode: 1804, exception information: Error while trying to retrieve text for error ORA-01804 ".
Finally, we found that if you want to normally execute the occi program for operating the Oracle database under other users, you need to set the Oracle-related link variables. The environment variables are as follows:
# ORACLE_HOME
Export oracle_base =/sdd1/Oracle/11gr2_database_x64
Export ORACLE_HOME = $ oracle_base/product/11.2.0.1.0/db_1
# Oracle client character, prevent to appear Chinese garbled
Export nls_lang = 'simplified chinese_china'. zhs16gbk
# Oracle Lib, or add into/etc/lD. So. conf
Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/lib: $ LD_LIBRARY_PATH
We recommend that you write a shell script, set environment variables in the script, and run executable programs.