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

Bi Server Architecture With Client


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 (only for the version 10g


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

Discover More
Obiee Scheduler Configuration Mail
Blog - Obiee 10G – How to configure the Mail server of Oracle BI Scheduler/Delivers

This article talk the configuration of the smtp mail server of Oracle BI Scheduler. To set up the smtp server, you must enter at least this information as : the sender address the smtp server the...
Obiee 10g Administration Utilitites Aggregate Persistence
OBIEE - Aggregate Persistence Wizard (aka Data Mart Automation)

The Aggregate Persistence Wizard is an Admintool utility that help you to create an aggregate persistence script. It allows the administrator to select measures and grains in order to create a set of...
Obiee Relationships Between Oracle Bi Infrastructure Components
OBIEE - Architecture

The Oracle Business Intelligence components consist of: Oracle Business Intelligence Presentation Services The Oracle Business Intelligence Presentation Services provides the framework and interface...
Obi Edition
OBIEE - Client Tools

Oracle Business Intelligence provides the following client tools, which are supported only on 32-bit Windows operating systems: Oracle Business Intelligence ODBC Driver Oracle Business Intelligence...
Logical Business Model
OBIEE - Common Enterprise Information Model (CEIM) - The Logical Business Model (the three-layer metadata model)

The Logical Business Model is the three-layer metadata model of the repository and its aim is to build a known also as a model-centric view (as compared to report-centric view of information). Each layer...
Obiee Webcat Critical Folder
OBIEE - Connection Pool Change (Username, password)

method to change the connection parameter of a connection pool from a rpd file (password, ...) Example: list...
Obiee Administration Tools Logon
OBIEE - How to connect remotely to the servers (BI, Presentation) ?

This article shows you how you can perform a remote connections with the OBIEE client tools Administration Tool and catalog manager to manage respectively : the BI Server and the web catalog Variable...
Obiee Connection Pool Shared Logon
OBIEE - How to define one different database credential for each user (the shared logon) ?

For system architecture reasons, you may want to have one database credential by user. Example : When one schema (of one user) is the logical entity of one company, you may decide to have the same...
Bi Server Architecture With Client
OBIEE - Session Manager

The Oracle BI Administration Tool Session Manager is used in online mode to monitor activity. You can see which users are logged in, disconnect users, and terminate queries.The Session Manager shows all...
Obi Edition
OBIEE - The Security Manager

When you open the administration tool, you can reach the security manager by the Menu : Manage > Security

Share this page:
Follow us:
Task Runner