IBM Support

Configuring Cognos to Use an Oracle 11gR2 RAC Database using SCAN

Technote (troubleshooting)


Problem(Abstract)

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?

Cause

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:

SCANhost:port/service_name

ie. myscanhost.domain.com:1521/orclscan

For more information regarding Oracle 11g SCAN refer to the following Oracle documentation below.

Related information

SINGLE CLIENT ACCESS NAME (SCAN)

Document information

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