Configuring Cognos to Use an Oracle 11gR2 RAC Database using SCAN
An Oracle 11g Release2(11gR2) RAC implementation can be configured to use a Single Client Access Name (SCAN) listener instead of referring to multiple hostnames or IP addresses in the SQL*NET string.
How do we configure Cognos Configuration to connect to a content store or audit database configured in this type of environment?
The SCAN configuration uses a '/' in the JDBC string that is used. We cannot use the standard Oracle configuration setting as it places a ':' between the port number and service name (ie. host:port:service_name)
Resolving the problem
You need to use the Oracle database (Advanced) configuration and enter a valid user name and password for the schema. For the database specifier you use the following format:
For more information regarding Oracle 11g SCAN refer to the following Oracle documentation below.
More support for:
Cognos Business Intelligence
Install and Config
Software version: 10.1, 10.1.1, 10.2, 10.2.1, 10.2.2
Operating system(s): AIX, HP-UX, Linux, Solaris, Windows
Software edition: All Editions
Reference #: 1577855
Modified date: 11 January 2012