![]() |
||||||||||||
Go ![]() | New ![]() | Search ![]() | Notify ![]() | Tools ![]() | Reply ![]() | ![]() |
Gold member |
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. | ||
|
Expert |
Do you have an oracle client installed on your WebFOCUS server ? Waz...
| |||||||||||||||||||||||||||
|
Gold member |
Yes we have Oracle client installed. Regards, Vivek WF 8.1.04,Infoassist,Oracle, Excel, PDF,HTML. | |||
|
Expert |
Check the documentation on what the adapter needs. Like adding to the path, HOME directory, etc. Waz...
| |||||||||||||||||||||||||||
|
Guru |
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 | |||
|
Gold member |
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. | |||
|
Gold member |
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 | |||
|
Powered by Social Strata |
![]() | Please Wait. Your request is being processed... |
|