[suresh_gym]

Hi,

I have tried to integrate OBIEE with existing OTM 5.5 CU4 version. As per the document,we should create new system DSN under ODBC connections. My OS is RHEL 4 and manually created the DSN in odbc.ini file as follows.

[TEST]
Driver=/oraclebi/server/Bin/libnqsodbc.so
Description=Oracle BI Server
ServerMachine=10.239.5.126
UID=
PWD=
Port=9704

But if I check the client connectivity using nqcmd, the commands hangs for ever. Is the configuration is correct?

[suresh_gym]

Hi Guys, Any updates? When I try to start the Oracle BI server, I found the following error in the NQServer.log file.

[55003] The cache polling SELECT query failed for table UET.
2008-09-22 23:49:02
libclntsh.so.9.0: cannot open shared object file: No such file or directory
[nQSError: 46029] Failed to load the DLL /oraclebi/server/Bin/libnqsdbgatewayoci8i.so. Check if 'Oracle OCI 8.x' database client is installed.
2008-09-22 23:49:02
[55005] The cache polling delete statement failed for table UET.
2008-09-23 00:00:00
[nQSError: 43059] Init block 'CURRENT MONTH INITIALIZATION': Dynamic refresh of repository scope variables has failed.
libclntsh.so.9.0: cannot open shared object file: No such file or directory
[nQSError: 46029] Failed to load the DLL /oraclebi/server/Bin/libnqsdbgatewayoci8i.so. Check if 'Oracle OCI 8.x' database client is installed.
2008-09-23 00:00:00
[nQSError: 43059] Init block 'CURRENT YEAR INIITIALIZATION': Dynamic refresh of repository scope variables has failed.
libclntsh.so.9.0: cannot open shared object file: No such file or directory
[nQSError: 46029] Failed to load the DLL /oraclebi/server/Bin/libnqsdbgatewayoci8i.so. Check if 'Oracle OCI 8.x' database client is installed.

The Note 551110.1 talks about the installation of Oracle Client 9i. But My obiee version is 10.1.3.3.1 and I have currently configured with OCI 10g client.

Is there any issues with this configuration?

[nick.polites]

The admin guide has all kinds of errors and should be corrected in the near future. I would suggest you get in contact with Oracle support to have a check over all of your configurations. Have you installed the Oracle 9i client to interface with OBI?

[suresh_gym]

Nick,

Thanks for your reply. But I didn't install the oracle 9i client, rather installed 10gR2 client. Because as per the doc,
02 - Oracle 9i
03 - Oracle 10g R1
04 - Oracle 10g R2
05 - DB2 OS/390 V7
06 - DB2 OS/390 V8
07 - DB2 UDB V7
08 - DB2 UDB V8
Enter 02 and press enter – in 10.1.3.3 you should select 3

Since my OBIEE version is 10.1.3.3.1, I opted for 10.2.0.1 client. Can I install Oracle 9i client and check? More over, I can't find any client version for oracle 9iR2 for Linux.

Please comment.

[nick.polites]

Which guide told you to install 10g client?

Here is from the OTM admin guide

Note: If you are installing OBI EE on a server running 64-bit Linux be sure the
LD_LIBRARY_PATH for the “oracle” user also includes the < Oracle 9i Client Home>/lib32
directory. If the path isn’t correct, the following error would be generated later in the OBI
EE installation.



I know that Oracle development has the 10g client working but you need to configure a bunch of things to get it working which have not yet been published. I would just install the 9i client for now.

[suresh_gym]

Hi Nick,

I installed the oracle9i client and the necessary configuration was done.I started the services, but found the following error while accessing the FTI from OTM.
saw.dll was not found on this server.

Also this my DSN entry in odbc.ini file.
[RPTAPP]
Driver=/oraclebi/server/Bin/libnqsodbc.so
Description=Oracle BI Server
ServerMachine=10.239.5.126
UID=
PWD=
Port=9704

Is this correct?

[nick.polites]

Did you rerun the [FONT='Arial','sans-serif']OBI EE]/Oracle BI\server\Bin\[/FONT]schconfig script again so that it uses the 9i client?

I am also assuming you have installed this on a Redhat 4 server?


[FONT='Arial','sans-serif']As far as modifying the odbc.ini, I can tell you that I didn't have to modify it to get this working. I had to add the RPTAPP as a tnsnames.ora entry into the Oracle 9i client.[/FONT]
[FONT='Arial','sans-serif'][/FONT]

[suresh_gym]

Nick,

Configuration using schconfig utility was completed and the parameters defined as follows.

***** Scheduler Database Configuration *****
1 - Database Type : Oracle 9i
2 - Call Interface : OCI 8i/9i
3 - Data Source Name : RPTAPP
4 - User Name : hdowner
5 - Password : *****
6 - Timeout (Minutes) : 60
7 - Maximum Connections : 5
8 - Bulk Fetch Buffer Size (bytes) : 33792
9 - Database Table for Jobs : S_NQ_JOB
10 - Database Table for Instances : S_NQ_INSTANCE
11 - Database Table for Parameters : S_NQ_JOB_PARAM
12 - Database Table for Messages : S_NQ_ERR_MSG
13 - DEFAULT VALUES
0 - Quit

However, While trying to connect to the OBIEE via OTM,got the following error.
The requested URL /analytics/saw.dll was not found on this server.

While trying to invoke the OBIEE using standalone method (http://<hostname:9704>/analytics> fails for the following error.
Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details.

Did I miss something in the configuration?

[nick.polites]

However, While trying to connect to the OBIEE via OTM,got the following error.
The requested URL /analytics/saw.dll was not found on this server.

You are supposed to be using a separate version of apache and tomcat copied over from your otm install not what OBIEE ships with.

[suresh_gym]

Hi Nick,

I removed the DSN entry from my odbc.ini file and started the services. Now I'm getting the 'The page cannot be displayed' error while accessing OBIEE via OTM.

Also as per the documentation, I downloaded apache-tomcat-5.5.27.tar file for the tomcat installation. But copied the entire apache directory from otm installation and modified the files as per the doc. Is this correct?

If not, could you provide me the URL from where I can download the standalone apache? Because I checked the otn site and found weblogic is available now. My current version of httpd is 2.0.55.