Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Not able to configure Oracle adapter
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]Not able to configure Oracle adapter
 Login/Join
 
Gold member
posted
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,
Vivek

This message has been edited. Last edited by: jvb,


WF 8.1.04,Infoassist,Oracle, Excel, PDF,HTML.
 
Posts: 82 | Registered: January 06, 2014Reply With QuoteReport This Post
Expert
posted Hide Post
Do you have an oracle client installed on your WebFOCUS server ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6136 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
Yes we have Oracle client installed.

Regards,
Vivek


WF 8.1.04,Infoassist,Oracle, Excel, PDF,HTML.
 
Posts: 82 | Registered: January 06, 2014Reply With QuoteReport This Post
Expert
posted Hide Post
Check the documentation on what the adapter needs. Like adding to the path, HOME directory, etc.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6136 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Guru
posted Hide Post
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
 
Posts: 495 | Registered: January 04, 2008Reply With QuoteReport This Post
Gold member
posted Hide Post
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.
 
Posts: 82 | Registered: January 06, 2014Reply With QuoteReport This Post
Gold member
posted Hide Post
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
 
Posts: 60 | Location: Toronto, Ontario | Registered: May 15, 2014Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Not able to configure Oracle adapter

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.