✍ Kashif M
Trends

Wednesday, 4 September 2013


TNS FILES IN OBIEE


By on September 04, 2013


After the fresh installation of OBIEE, when you try to import tables in the repository,you may unable to import database object in obiee reporsitory.

Main reason behind this would be missing tnsnames.ora file in OBIEE.

In this case, Just copy tnsnames.ora file from database to OBIEE as mention below.



Database location ( copy tnsnames.ora file from here)

C:\APP\ORACLE\PRODUCT\11.1.0\db_1\network\admin

OBIEE location ( paste tnsnames.ora file here)

D:\OBIEE11g\Oracle_BI1\network\admin

D:\OBIEE11g\oracle_common\network\admin





Kashif
mkashu: TNS FILES IN OBIEE
Review : Kashif | Kashif
Update: September 04, 2013 | Rating: 4.5

Comment for "TNS FILES IN OBIEE"

5 comments:

  1. My OBIEE is running on a linux and there is no admin folder in oracle_common.
    So do I need to create and place the file there?

    ReplyDelete
    Replies
    1. Yes. You need to create folder

      Delete
  2. facing same issue as sohaib ahmed mentioned, ours is red hat linux 6.
    asking same question as him, pls suggest.

    ReplyDelete
    Replies
    1. Folder will be not available by default. You need to create one.

      Delete
  3. Do we need to restart BI Services after this?

    ReplyDelete

Blog Archive