OBIEE 10G/11G - Administration Tool (admintool, datamodel)


admintool.exe is the Administration tool to manage OBIEE server and have some capabilities to automate some repetitive tasks and principally his embedded tools.

Oracle Business Intelligence Administration Tool is available only for Windows operating systems.

The Administration Tool is a Windows application that allows the BI Server administrator to create and edit repositories.

Repositories can be edited with the administration tool in either OBIEE 10G/11G - Repository (RPD file) or OBIEE 10G/11G - Repository (RPD file) mode.

The Administration Tool also includes a session manager and a cache manager which are available in online mode. The Cache Manager displays what queries have been cached and how frequently they have been accessed. You can also select and delete items in cache

How to



You can start it in two ways :

  • with the Windows Menu : Start > All Programs > Oracle Business Intelligence > Administration
  • by starting the executable file admintool.exe (<note warning>only for the version 10g</note>)

The admintool is located in this directory



You can start it in two ways :

  • with the Windows Menu : Start > All Programs > Oracle Business Intelligence > Administration
  • launch the Administration Tool from the command line using bi-init.cmd.

Do NOT open the RPD by simply double clicking on the RPD file or typing Admintool.exe in a command line. The resulting Administration Tool window is not initialized to your Oracle instance, and errors will result later in your session. Ignoring this will lead to creating inconsistencies in the RPD file.

The admintool is located in this directory

BI_ORACLE_HOME/bifoundation/server/bin (\MiddelwareHome\instances\instance1\bifoundation\server\bin

OBIEE - Metadata dictionary Automatic Export

How to automate the creation of the metadata dictionary.

  • Create a command file BiServerMetaDataExport.txt
    Open repository.rpd AdministratorLogin AdministratorPassword
    GenerateMetadataDictionary {\MetadataDictionaryFolder}
  • Create a scheduler command
{OracleBI}\server\Bin>admintool /command /BiServerMetaDataExport.txt

More command : OBIEE 11g: How To Run the Administration Tool and Administer Repositories in Automated Mode from the Command Line

Inconsistency Check



  • 11g Client: ORACLE_BI_HOME\oraclebi\orainst\diagnostics\logs\OracleBIServerComponent\coreapplication\Administrator_NQSAdminTool.log

The import wizard Metadata shows nothing

Be sure to have in your bi-init script the path set to the good directory bin of an Oracle Client.

SET PATH=C:\toTheOracleDatabaseHome\BIN;%PATH%

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

Documentation / Reference

Powered by ComboStrap