Oracle Business Intelligence Infrastructure Installation and Configuration Guide > Configuring the Data Sources for Oracle Business Intelligence >

Configuring Oracle Databases for the Oracle BI Server Under Windows

Operating System: Windows only.

Databases: Oracle only.

This topic is part of the Roadmap for Configuring Oracle BI Infrastructure Components.

If your native database is Oracle, the following conditions must be true:

• The machine running Oracle BI Server must use the Oracle Call Interface (OCI) to connect to the database.
• In the tnsnames.ora file, the Oracle database alias (the defined entry name) must match the Data Source Name used in the repository connection pools of all physical Oracle databases.
• In the repository file, the Oracle database alias used in the connection pools must also be the same as the Data Source Name.

  For example, in the following example of a tnsnames.ora entry, the corresponding Oracle Business Intelligence repository connection pool Data Source Name is ITQA2.

  ITQA2 =
     (DESCRIPTION =
        (ADDRESS_LIST =
           (ADDRESS = (PROTOCOL = TCP)(HOST = ITQALAB2)(PORT = 1521))
     (CONNECT_DATA =
        (SERVICE_NAME = ITQALAB2.corp)
        )
     )

The following procedure shows how to check repository connection pool settings against the Oracle tnsnames.ora settings.

To check that an Oracle database refers to the Oracle BI Server machine

1. Log on to the Server Administration Tool.
2. In the repository's Physical layer, double-click on the appropriate database cylinder icon. On the general tab, in the Data source definition Database field, select the appropriate Oracle database version from the drop down list. for your data source.
3. If the Connection Pool is not visible in the Physical layer, click on the (+) navigation control to the left of the appropriate database cylinder icon to expand it.
4. Double-click the appropriate Connection Pool to open the Connection pool window.
5. In the Connection Pool window, check that the following is true:
   • The Call Interface field displays the appropriate value for the release of Oracle database being used.
   • The Data Source Name displays the Oracle database alias that you have defined in the tnsnames.ora entry.

     NOTE:  This Data Source Name is not the DSN name defined in Settings > Control Panel > Data Sources (ODBC).

6. In the Oracle folder, open the tnsnames.ora file.
7. Check that a valid entry name exists with the following characteristics:
   • Matches the Oracle BI repository's connection pool settings for the Data Source Name
   • Specifies the targeted Oracle physical database