11 OBIEE 11g Tips: #4 Connecting to Oracle Databases

Connection Pools on Oracle databases can be configured in two ways in OBIEE 11g.

The first way is to provide the complete connection information - which is typically found in a tnsnames.ora file - in the Data source name field of the connection pool properties.

This looks similar to the following:

Here is a sample string for your reference:



(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=yourhostname)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))

The second option is to provide only the service name (orcl in the above example). But to enable this you will have to place a valid copy of tnsnames.ora in the following directory:

%BI_HOME%/Oracle_BI1/network/admin

and restart the BI Server.

Have a nice day

@lex