Using the Oracle TNS Connection String in BI Administration Tool

Ideally the BI Administration Tool should be able to use the TNS Identifier (SID) to connect to the Oracle Database. E.g. with the default ORCL

However, sometimes (probably because of Environment Variable settings) t he BI Admin Tool doesn’t Accept the Oracle TNS Identifier (SID). To have a quick workaround it is also possible to paste the complete TNS Entry into the BI Administration Tool. This allows the BI Tool to make the proper connection to the Oracle Database.


Data source name: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SID=orcl)))
 

1 thought on “Using the Oracle TNS Connection String in BI Administration Tool

  1. The Admin tool uses the tnsnames.ora file from its own installation directory on the client machine – for example: C:\Oracle\Middleware\obiee12c\network\admin\tnsnames.ora

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.