Skip to main content

Connecting Oracle Data Source with OBIEE 11g

In my working environment windows Server R2, I couldn’t connect with oracle database using DSN name (Which we are creating using Administrative Tool -> Data Source (ODBC) -> System DSN in OBIEE 10g) of the schema.

I am sharing the workaround that how I have imported the tables into Administration tool in OBIEE 11.1.1.5.0 in Oracle database environment.
I went to below directories with my installed OBIEE 11g version and copied the oracle credential in the file of tnsnames.ora into this folder.
1. Drive:\<BIHome>\Oracle_BI1\network\admin\tnsnames.ora
    E.g.: C:\OBIEE11g\Oracle_BI1\network\admin\tnsnames.ora

2. C:\OBIEE11g\oracle_common\network\admin\tnsname.ora
     E.g: Drive:\<BIHOME>\oracle_common\network\admin\tnsname.ora
I have opened the Administration Tools and created the Test.rpd and selected ‘Import Metadata’ from file Menu.
Here I have given the following details to connect with oracle database.

Import Type: Local Machine
Connection Type: OCI 10g /11g
DSN: ORCL ( Oracle Service Name)
User Name: SH (The schema that you want to import into the physical layer)
Password: Schema password
You can view the below screenshot for your reference.
 
By clicking 'Next', the schema has to be connected and imported into the physical layer of Administration Tool.

Note:
If you want connect with the remote server oracle database system then we have add the corresponding machine name, service name and IP address in tnsnames.ora file. You can view the below screen shot for you reference.
                               
But MySQL database is connecting with DSN Name with the procedure we are following to import the metadata in OBIEE 10g

Comments

  1. Thank you. It helped me out.

    ReplyDelete
  2. Hi,
    Pls. could you clarify:
    a) OBIEE11g is your installation directory... right ?
    b) oracle_common should be created ? (since it is not there... right ?)
    c) Oracle_BI1 - this should be created also ? (since it is not there... right ?)

    txs

    ReplyDelete
    Replies
    1. Hi Above,

      My experience with the above post is with BI Enterprise Edition 11g. After successful installation of OBIEE 11g we will get all the above directory.
      a) Yes.. OBIEE 11g is installation directory only.
      b) Oracle_Common directory will be available with the installation of OBIEE 11g, no need
      to create manually
      c) Orace_BI1 also will be available with the installation of OBIEE 11g.

      But in OBIEE 11.1.1.5 and above version are supporting creating DSN and import the schema in the physical layer of the repository.

      so After copying the oracle credentials into the tnsnames.ora file to the above mentioned directories we can import the tables using OCI or System DSN.

      Hope it helps!
      Bose

      Delete
    2. I had the same problem. But, if you install only client then the NETWORK folder will not be created automatically. Only two folders will be created.
      ORAHOME
      ORAINST
      To resolve the above issue, i.e 'connection has failed' error you need to update the bi_init.bat file with actual oracle home folder.
      i.e
      set ORACLE_HOME=

      note: you can find bi_init file oraclebi\orahome\bifoundation\server\bin

      Delete
    3. Hi Anand,

      I am facing the same problem. It helped me alot.

      Thanks
      Krishna

      Delete
  3. thank you. you are a top man!

    ReplyDelete
  4. I couldn't find
    \oracle_common\network\admin\tnsname.ora
    since it showing upto network folder not even admin folder also
    Thanks in advance

    ReplyDelete

Post a Comment

Popular posts from this blog

OBIEE 11.1.1.7.0 Step by Step Installation

This post will guide us through the  step by step installation of OBIEE 11.1.1.7.0. Here I don't find any difference in RCU installation between in previous version with this version. Still if you want to know the RCU installation stepsclick here
Step1: Download the OBIEE 11g versionfrom here or from oracle e-delivery site and extract all the four disk into a single folder and click setup.exe from the Disk1
Universal Installer window will start and will check for the initial set up and system requirement. After the successful precheck the first step of our OBIEE 11.1.1.7.0 starts with the below window. Just Click 'Next'
Step2:
If you have oracle Support username and password then update then use that in this step or just select first option 'Skip Software updates' and click 'Next'
Step3:
Select the appropriate installation step here. I am going to install all the component of BI so selected here 'Enterprise Install' and then click 'Next'
Step4:
This …

Step by Step Installation of Oracle 11g 64bit in Windows7 64bit

This Post will give you step by step information of Oracle database 11g 64 bit version installation in windows 7 64 machine. If you prefer with Oracle Database 11g installation in Windows 64bit machine, This post will help you to move forward.
Prerequisites Checks: RequirementMinimum ValuePhysical memory (RAM)1 GB minimum
On Windows 7 and Windows 8, 2 GB minimumVirtual memoryIf physical memory is between 2 GB and 16 GB, then set virtual memory to 1 times the size of the RAM
If physical memory is more than 16 GB, then set virtual memory to 16 GB
Disk spaceTotal: 5.39 GBProcessor TypeAMD64, or Intel Extended memory (EM64T)Video adapter256 colorsScreen Resolution1024 X 768 minimum
Download oracle Database from oracle site and unarchive the zipped download file.
Step1:  Just double click on setup.exe from the unarchived folder of oracle database source. Step2: Oracle Universal Installer will check the disk space and initiates the installation Step3: If you have a oracle metalink ID then type your em…

ADF_FACES-60097 : For more information, please see the server's error log for an entry beginning with: ADF_FACES-60096: Server Exception during PPR, #1