Monday 21 April 2014

OBIEE 11g Admin tool Connection failed error


After installation of both Oracle database 11g and obiee 11.1.1.7 in my windows 7 64bit laptop, I use OBIEE administration tools to import metadata into the physical layer using connection type of ‘OCI 10g/11g’. And It end up with the following error:
Administration tool import metadata into physical layer error
The reason is that BI administration tool is a client tool, and it does not use the traditional  tnsnames.ora in the  $ORACLE_HOME/network/admin directory, Administration tool look for the tnsnames.ora file in the below directory instead.
You have to create a tnsnames.ora file in the above directory with the following like content (just change the host/port/service_name to your own setting)
And now you could use administration tool to import medata from the database of your laptop!
 

GO to COMPUTER and Write click

 

 

 

 

Set environment Varible

C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client Tools\oraclebi\orainst\bifoundation\OracleBIServerComponent\coreapplication\repository

No comments:

Post a Comment