Skip to content

OBIEE 11g with Oracle 11g Data Source

November 6, 2013


  • OBIEE Plus running on Solaris 10, Sun Sparc 64 architecture.
  • OBIEE Database repository on MS SQL 2008 running on Windows 2008 (64b).
  • Oracle DB 11g running on Windows Server 2008 SP2, 64 architecture.
  • Oracle client installed with Oracle Business Intelligence.

All the required client components are installed during the OBIEE 11g installation, the only step are:

  1. Verify if the tnsnames.ora file exist in the $ORA_HOME/network/admin directory, if not, create it.
  2. Create in the tnsnames.ora file and entry for the Oracle DB server (see example bellow; personalize it with your Oracle DB server information).

    ORA11GR2 =
    (ADDRESS = (PROTOCOL = TCP)(HOST = MyHost)(PORT = 1522))
    (SERVICE_NAME = ora11gR2.local)




Leave a Comment

Leave a Reply

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

You are commenting using your 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

%d bloggers like this: