We are setting up a 10.2.1 cognos environment with a gateway server, and an application server (and content manager). We will be running against Oracle 11.2.0.3 (we have several databases in Oracle and our content store will also be in oracle). I am trying to determine the correct oracle client to install on our application server. I believe that even though our servers are 2012 64-bit, we need the 32-bit Oracle client because Framework Manager is 32-bit. Is this correct? Any help is appreciated.
Hi Penny,
It depends. If you are connecting to Oracle through the client libraries using CQM, access is 32-bit (CQM is 32-bit even in a 64-bit install of Cognos 10). You will need the 32-bit Oracle client libraries on your application server. If you are using only DQM, access is 64-bit and uses the Oracle JDBC (the jar files will need to be installed on the Application server for this to work). Either way, you don't need the 64-bit Oracle client libraries on the application server - either the 32-bit ones or the JDBC (or both) :)
Cheers!
MF.
Additional:
If you use Metrics Studio you'll have to install BOTH driver (32 and 64).
And also the sequence in your %PATH% variable is important: Make sure the x64 version is the first. (Suggestion: First install 32-bit Oracle client and then the 64-bit client).
Oh - of course! I always forget about Metrics. Cheers RA! :)
MF.
Hi again....thank-you.
I have installed the 32-client as we are using CQM. When I looked on the Oracle website there was a new version of the client (the only one that I could see that was certified to run on Windows Server 2012).
ODAC 12c Release 1 (12.1.0.1.0) - includes SQL Plus client and oracle instant client. Compatible with 10g and 11g of Oracle.
My problem now is:
The Cognos 10.2.1. Installation and Configuration Guide (page 85) states that the ojdbc14.jar (for oracle 10g), or ojdbc5.jar file (Oracle 11g) must be copied to c10_location\webappls\p2pd\WEB-INF\lib directory from the ORACLE_HOME/jdbc/lib directory. However, when look, I only see an ojdbc7.jar. Is the documentation just not up-to-date with the newest version of the Oracle client. Any advice is appreciated.
Try it. Sounds like the docs need an update.
You can download OJDBC5.jar separately:
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html
As far as I know, the 32 bit client installation is only required for Oracle CQM.
OJDBC5.jar should suffice for the content store / audit log databases and DQM.