Oracle Schemas Not Visible In OBIEE 11g Metadata Import Wizard And Admin Tool Log Shows Error: "[nQSError: 93001] ...Cannot load library, oracore11.dll..." (Doc ID 1475489.1)

Last updated on OCTOBER 12, 2016

Applies to:

Business Intelligence Server Administrator - Version 11.1.1.6.0 and later
Oracle Exalytics Software - Version 1.0.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Using Oracle Business Intelligence Enterprise Edition (OBIEE) Admin Tool 11.1.1.6+  (or 11.1.1.7+) in an Exalytics environment and created connection pool and database object for an Exadata database.
Then connected to OBIEE Admin Tool in offline mode and started the Metadata Import Wizard to import data from the Exadata database.
All schema objects were checked in step 2 (View, tables, indexes, etc.) of the wizard.
In step 3, the Exadata database shows on the left side, of the wizard window, but there are no schemas displayed and the import cannot proceed (see image below):

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms