Import Metadata Objects into Admin Tool 11.1.1.7.1 – Issue

After installing OBIEE Admin Tool 11.1.1.7.1 successfully, consultant faced an issue while using an import metadata objects option. You may end up with not able to see any of the objects at all. This blog is to find out the real cause of this behavior.

Problem Description

The Import Metadata does not work; the user is not able to see any of the objects as shown below.

Solution

The issue is to do with the Oracle Database Client installed on Administrator Client Machine. The Oracle Database Instant client is not enough, you need standard oracle Database client preferably Oracle 11g R2 standard client.  

The recommended client for Windows 64 bit operating system is available for download

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/ 112010-win64soft-094461.html 

For readers benefit here is the difference between the Oracle Database Instant client and Oracle Database standard client.

Oracle Database Instant Client

 Instant Client allows you to run your applications without installing the standard Oracle client or having an ORACLE_HOME. OCI, OCCI, Pro*C, ODBC, and JDBC applications work without modification, while using significantly less disk space than before. Even SQL*Plus can be used with Instant Client. No recompile, no hassle.

Note – The issue has been resolved with the help of Oracle Forum help.