There are several reasons why you might have trouble connecting to an Oracle Database using OCI.
Check to ensure that the following conditions are true:
The computer running the Oracle BI Server must use Oracle Call Interface (OCI) to connect to the database.
If you choose not to use the entire connect string in the repository connection pool, you must ensure that a valid tnsnames.ora
file is set up in the following location within the Oracle Business Intelligence environment, so that the Oracle BI Server can locate the entry:
BI_DOMAIN/config/fmwconfig/bienv/core
If you choose not to use the entire connect string in the repository connection pool, ensure that the net service name in the tnsnames.ora
file matches the Data Source Name used in the connection pool.
For example, in the following example of a tnsnames.ora
entry, the corresponding Oracle BI EE 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 database and connection pool settings against the Oracle tnsnames.ora settings.