Hi, I have installed WF reporting server 8.1.04. I have security mode PTH enabled. When I am trying to configure the oracle adapter, following error message is coming. If any one could suggest some work around.
(FOC1261) PHYSICAL INTERFACE NOT FOUND FOR SUFFIX SQLORA. MODULE NAME : OR8PS12 (FOC1262) THE FOLLOWING NATIVE ERROR MESSAGE(S) CAPTURED : (FOC1260) libclntsh.so.12.1: cannot open shared object file: No such file or directory (FOC1263) THE CURRENT ENVIRONMENT VARIABLES FOR SUFFIX SQLORA ARE : (FOC1260) ORACLE_SID : FILWFOS2 (FOC1260) NLS_LANG : NOT SET (FOC1260) ORACLE_HOME : /opt/oracle/client/product/12.1.0.2 (FOC1260) ORA_NCHAR_LITERAL_REPLACE : NOT SET (FOC1260) LD_LIBRARY_PATH : /edwsdv02/was/java/jre/lib/amd64 (FOC1260) /edwsdv02/was/java/jre/lib/amd64/server (FOC1260) /edwsdv02/was/java/jre/lib/amd64/classic (FOC1260) /edwsdv02/app/rep/ibi/srv81/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 (FOC1479) ERROR CONNECTING TO SQL DATABASE
I have following in .profile file export TNS_ADMIN=/edwsdv02/app/rep/ORACLE_TNS export ORACLE_SID=FILWFOS2 export ORACLE_HOME=/opt/oracle/client/product/12.1.0.2 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
Thanks, VivekThis message has been edited. Last edited by: jvb,
WF 8.1.04,Infoassist,Oracle, Excel, PDF,HTML.
May 25, 2015, 11:53 PM
Waz
Do you have an oracle client installed on your WebFOCUS server ?
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
May 26, 2015, 12:28 AM
jvb
Yes we have Oracle client installed.
Regards, Vivek
WF 8.1.04,Infoassist,Oracle, Excel, PDF,HTML.
May 26, 2015, 12:35 AM
Waz
Check the documentation on what the adapter needs. Like adding to the path, HOME directory, etc.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
May 26, 2015, 10:10 AM
MattC
Check to make sure you have the right 32 or 62 bit Oracle client installed. I remember running into this a while back when doing a brand new install of 8 on a Windows Server 64bit. I accidentally installed the 32bit Oracle Client.
WebFOCUS 8.1.05
May 27, 2015, 03:28 AM
jvb
Thanks all, for your inputs. I was able to resolve the issue doing following: Remove link ---------------------------- lrwxrwxrwx. 1 oracle oinstall 106 May 12 10:18 /opt/oracle/client/product/12.1.0.2/lib/libclntsh.so -> /oracle/product/client/fil-oracle-client-12.1.0.2/opt/oracle/client/product/12.1.0.2/lib/libclntsh.so.12.1 Add link --------- ln-s /opt/oracle/client/product/12.1.0.2/lib/libclntsh.so.12.1 /opt/oracle/client/product/12.1.0.2/lib/libclntsh.so
It seems that this should have been taken care by DBA at the time of installing oracle client.
Regards, Vivek
WF 8.1.04,Infoassist,Oracle, Excel, PDF,HTML.
June 21, 2019, 01:09 PM
iBeny
Hi Vivek, I am experiencing the same issue, Where is this link you have advised to Remove and Add?
Webfocus 8105,8808,7703,7611, EXL2K,HTML,PDF,COMT,AHTML Info Assist+ , Reportcaster