Monday, September 13, 2010

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

Enhanced by Zemanta

1 comment:

Sai Ajay said...

What if it doesnot connect even if i give the DSN information?

I am able to create a DSN but not able to connect to it from repository