Diagnostics
Symptom
(FOC1261) PHYSICAL INTERFACE NOT FOUND FOR SUFFIX SQLORA. MODULE NAME : OR8PS19
(FOC1262) NATIVE ERROR MESSAGE(S) :
(FOC1260) libclntsh.so.19.1: cannot open shared object file: No such file or directory
(FOC1263) THE CURRENT ENVIRONMENT VARIABLES FOR SUFFIX SQLORA ARE :
(FOC1260) ORACLE_SID : NOT SET
(FOC1260) NLS_LANG : NOT SET
(FOC1260) ORACLE_HOME : /home/iadmin/oracle/product/19.0.0/client_1
(FOC1260) ORA_NCHAR_LITERAL_REPLACE : NOT SET
(FOC1260) LD_LIBRARY_PATH : /home/iadmin/ibi/srv82/home/bin
(FOC1260) /lib
(FOC1260) /usr/lib
(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
(FOC1488) SQL INTERFACE HAS NOT BEEN INSTALLED OR COULD NOT BE INITIALIZED
(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
(FOC1488) SQL INTERFACE HAS NOT BEEN INSTALLED OR COULD NOT BE INITIALIZED
(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
(FOC1488) SQL INTERFACE HAS NOT BEEN INSTALLED OR COULD NOT BE INITIALIZED
(FOC1406) SQL OPEN CURSOR ERROR.
Oracle Adapter Connectivity Test (SUFFIX=SQLORA ilms): Status - Failed
Problem
The user receives the error messages above while testing a newly configured Oracle 19c adapter.
Solution
The following several environment variables are needed:
- ORACLE_SID
- ORACLE_HOME
- LD_LIBRARY_PATH
The last variable was not set. Setting LD_LIBRARY_PATH to reference ORACLE_HOME resolved the issue.
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH