Latest News

Friday, May 2, 2014

OBIEE 11g – Import Metadata shows no schemas


  The Oracle DB client install of the OBIEE 11g Administration Tool is installed along with a set of OCI libraries. It can support basic Oracle Database interaction, without the need for a full Oracle Database Client installation.

 When you use the Import Metadata operation, it shows no schemas just shows a stub.



1) First Check the Log File Check the log in the below location and ensure if it says Missing OCI library

C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orainst\diagnostics\logs\OracleBIServerComponent\coreapplication\Administrator_NQSAdminTool.log

It can have below error:
[2013-12-16T15:10:12.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 8b4]  [nQSError: 93001] Can not load library, oracore11.dll, due to, The specified module could not be found. [[
.
The ..specified module could not be found.
]]
 “Can not load library, oracore11.dll“. This library is required to select /display all Schemas. From the  full Oracle Client Installation we can get this library.


2. Installing the Full Oracle Client
Download Oracle Client from oracle website. Unzip the installer and run setup.exe. Select the custom installation and choose just the “Oracle Call Interface (OCI)” option while installing the setup.

Use this Link to Download Oracle Client : Oracle Database 11g Release 2 (Version : 11.2.0.1.0)


After restarting  the OBIEE AdminTool the Import Metadata function should  work now.


In Oracle 10g Client machines there's a workaround for the above Issue just follow below steps

1)Go to %ORACLE_HOME%\BIN
2)Copy ORACORE10.dll in the same location
3)Rename it to ORACORE11.dll
4)Make sure %ORACLE_HOME%\BIN is added to your PATH variable.
5)Restart Admin Tool.

(Fingers cross hope this helps, if not highly recommended to re install Oracle Client)

  • Google+
  • Pinterest
« PREV
NEXT »

2 comments

  1. wonderful information, I had come to know about your blog from my friend nandu , hyderabad,i have read atleast 7 posts of yours by now, and let me tell you, your website gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a ton once again,
    Regards, obiee training in hyderabad

    ReplyDelete
  2. You have done a great job on this article. It’s very readable and highly intelligent. You have even managed to make it understandable and easy to read. You have some real writing talent. Thank you. 1337x

    ReplyDelete