Shulou(Shulou.com)06/01 Report--

Refer to the MOS documentation:

Information On Installed Database Components and Schemas (document ID 472937.1)

The Oracle component can be viewed through the following SQL, which is the component of one of my production libraries, which I deployed at that time:

SQL > col COMP_NAME for A50

SQL > select comp_id,comp_name, version, status from dba_registry

COMP_ID COMP_NAME VERSION STATUS

-

OWB OWB 11.2.0.4.0 VALID

APEX Oracle Application Express 3.2.1.00.12 VALID

EM Oracle Enterprise Manager 11.2.0.4.0 VALID

AMD OLAP Catalog 11.2.0.4.0 VALID

SDO Spatial 11.2.0.4.0 VALID

ORDIM Oracle Multimedia 11.2.0.4.0 VALID

XDB Oracle XML Database 11.2.0.4.0 VALID

CONTEXT Oracle Text 11.2.0.4.0 VALID

EXF Oracle Expression Filter 11.2.0.4.0 VALID

RUL Oracle Rules Manager 11.2.0.4.0 VALID

OWM Oracle Workspace Manager 11.2.0.4.0 VALID

CATALOG Oracle Database Catalog Views 11.2.0.4.0 VALID

CATPROC Oracle Database Packages and Types 11.2.0.4.0 VALID

JAVAVM JServer JAVA Virtual Machine 11.2.0.4.0 VALID

XML Oracle XDK 11.2.0.4.0 VALID

CATJAVA Oracle Database Java Packages 11.2.0.4.0 VALID

APS OLAP Analytic Workspace 11.2.0.4.0 VALID

XOQ Oracle OLAP API 11.2.0.4.0 VALID

RAC Oracle Real Application Clusters 11.2.0.4.0 VALID

The focus of this chapter is on the introduction, installation and uninstallation of various components, and the use of related components is outside the scope of this chapter.

1. OWR (Oracle Warehouse Builder)

OWB is a process of creating a data warehouse. Oracle's OWB is one of the three best ETL products at present.

OWB can not only extract, transform and load data, but also help users to create ROLAP (Relational Online Analysis Process) in Oracle database.

And MOLAP (Multidimensional Online Analysis Process) data warehouse objects, data quality management, business intelligence definition, etc. Anyway, it's the ETL tool.

Description:

-

This component will appear in dba_registry when you have configured Warehouse Builder in your database.

Schema:

-

OWBSYS (This is available from Oracle RDBMS 11gR1 onwards, see below.)

How to Install and De-Install:

-

Note 340955.1-Oracle Warehouse Builder, Releases and Patches

See Also: Oracle OWB Documentation http://download.oracle.com/docs/cd/B31080_01/doc/install.102/b28224.pdf

2. APEX (Oracle Application Express)

Oracle Application Express is a rapid Web application development tool for Oracle databases.

Professional applications can be developed and deployed quickly and securely with a Web browser and limited programming experience.

Description:

-

Oracle Application Express (Oracle APEX) is a rapid web application development tool for the Oracle database.

Using only a web browser and limited programming experience, you can develop and deploy professional applications that are both fast and secure.

Oracle APEX is a fully supported, no cost option of the Oracle database.

The APEX product requires a database in which to install the APEX database packages, procedures, functions, tables, etc. And an HTTP Server which is used to call the APEX application from a browser.

APEX is currently supported on on 10.1 and higher. The 11.x version of the database automatically installs Application Express by default.

Schema:

-

APEX_xxxxxx

How to Install and De-Install:

-

Note 1086415.1-Master Note for Oracle Application Express (APEX) Installation

3. EM (Oracle Enterprise Manager)

When installing Oracle software, Oracle Universal Installer can optionally install Oracle Enterprise Manager.

Enterprise Manager provides a Web-based interface that you can use to manage Oracle instances and databases. It is a tool that can replace SQLPLUS to manage database, in fact, it can not be replaced.

Description:

-

This component will appear in dba_registry when you have configured a db console in your database. This is available from Oracle rdbms 10gR1 onwards.

Please note that for this component you need to have Oracle Enterprise Manager installed at binaries level.

Schema:

-

DBSNMP, SYSMAN, MGMT_VIEW (11gR1 and 11gR2 only)

How to Install and De-Install:

-

Note.278100.1 How To Drop, Create And Recreate DB Control In A 10g Database

(This note is applicable to 11gR1 and 11gR2)

Please note that reconfiguring the dbconsole will remove the existing settings in dbconsole. So after dropping and recreating the em repository you need to redo all the em related setting.

4 、 OLAP Catalog, OLAP Analytic Workspace, Oracle OLAP API

The three components here are all core components of Oracle OLAP. Oracle OLAP is an option for Oracle Enterprise Edition, because the OLAP engine is fully integrated into the Oracle database.

Therefore, all data and metadata are stored and managed from within the Oracle database to provide a highly scalable, robust management environment and industry-level availability and security.

Oracle OLAP mainly consists of the following components: OLAP Analytic Workspace, which is used to analyze the data actually stored in the workspace. An Analytic Workspace is stored as a relational table

Different objects in the analysis workspace are stored as a row in the table (in LOB format). The analysis workspace can even be stored in a partition table to provide better concurrency performance.

OLAP API is a Java programming interface of Oracle OLAP, which supports OracleBI Bean. In addition to server components, Oracle OLAP provides two client tools:

Supported version (9iMagne10gR1mem10gR2 11gR1min11gR2)

Description:

-

Introduced in 9i, OLAP applications are developed within the context of business intelligence and data warehousing systems

And the features of the OLAP API are optimized for this type of application. With the OLAP API, a Java application can access

Manipulate, and display data in multidimensional terms. The OLAP API also makes it possible to define a query in a step-by-step process

That allows for undoing individual query steps without reproducing the entire query. Such multistep queries are easy to modify and refine dynamically.

The OLAP API is a Java application programming interface (API) through which an application can access data for online analytical processing (OLAP).

The Java classes that implement the API are part of the Oracle OLAP component.

The purpose of the OLAP API is to facilitate the development of OLAP applications, which allow users to dynamically select, aggregate, calculate

And perform other analytical tasks on data through a graphical user interface. Typically, the user interface of an OLAP application displays data

In multidimensional formats, such as graphs and crosstabs.

The following components must be installed and valid to support the OLAP installation, and should be installed and valid before OLAP is installed:

Component:

JServer JAVA Virtual Machine

Oracle Database Java Packages

Oracle XDK

Oracle XML Database

Schema:

-

OLAPSYS/MANAGER (9i, 10gR1, 10gR2, 11gR1, 11gR2)

The account used to create OLAP metadata structures. This account owns the OLAP Catalog.

The OLAP catalog is created in CWMLite tablespace in 9i but in 10g it is SYSAUX tablespace.

How to Install and De-Install:

-

Note 331808.1 How to Uninstall OLAP Options from ORACLE_HOME?

Note 278111.1 How to Remove the Oracle OLAP API Objects from 9i and 10g

Note 296187.1 How To Manually Install Oracle OLAP In 9i, 10g Or 11g Database After The DB Has Been Created.

Note 332351.1 How To Remove The OLAP Option In 10g And 11g

Note 467643.1 How To Remove or De-activate OLAP After Migrating From 9i To Standard Edition 10g

How to Remove OLAP From the Standard Edition database. (Doc ID 1362752.1)

Oracle? OLAP User's Guide: Installing Analytic Workspace Manager

Known Issues:

-

Document 1262866.1-OWBSYS Account Not In Fresh 11gr2 Install-Deselected OLAP Option During Creation Of The Database

Documentation:

-

Oracle? OLAP Application Developer's Guide 10g Release 2 (10.2)

Is the OLAP Option Installed in the Database?

Note.738192.1 What's New in Oracle Database 11g Release 11.1 Oracle OLAP

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.