Information On Installed Database Components and Schemas

Subject:	Information On Installed Database Components and Schemas
	Doc ID:	472937.1	Type:	HOWTO
	Modified Date:	20-JUL-2009	Status:	PUBLISHED

In this Document
  Goal
  Solution
     1. JServer JAVA Virtual Machine
     2. OLAP Catalog, OLAP Analytic Workspace, Oracle OLAP API
     3. Oracle Data Mining
     4. Oracle InterMedia/(Oracle Multimedia in 11gR1)
     5. Oracle Label Security
     6. Oracle Rule Manager and Oracle Expression Filter
     7. Oracle Spatial
     8. Oracle Text
     9. Oracle Ultra Search
     10. Oracle Workspace Manager
     11. Oracle XDK for Java
     12. Oracle XML Database
     13. Oracle Enterprise Manager
     Summary of administrative User Accounts Provided by Oracle Database:

---

Applies to:

Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 11.1.0.6
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 8.1.7.4 to 11.1.0.6

Goal

To provide a brief introduction of different database components and schema.

The scope of this document is to provide information of different database components which includes their introduction, install/deinstall doc/notes. However the functionality(how to use) of these components is not in the scope of this note.

In the documentation section, I have given 10gR2 link for each component since it is mostly used version today. However if you need to access other versions then refer to http://tahiti.oracle.com/

Solution

1. JServer JAVA Virtual Machine

(8i,9i,10g,11gR1)

Description: JVM and Jserver
------------------------------
JVM is a platform-independent execution environment that converts Java bytecode into machine language and executes it. Most programming languages compile source code directly into machine code that is designed to run on a specific microprocessor architecture or operating system, such as Windows or UNIX. A JVM -- a machine within a machine -- mimics a real Java processor, enabling Java bytecode to be executed as actions or operating system calls on any processor regardless of the operating system. For example, establishing a socket connection from a workstation to a remote machine involves an operating system call. Since different operating systems handle sockets in different ways, the JVM translates the programming code so that the two machines that may be on different platforms are able to connect.

Oracle JServer Option is a Java Virtual Machine (Java VM) which runs within the Oracle database server's address space. Oracle also provides a JServer Accelerator to compile Java code natively. This speeds up the execution of Java code by eliminating interpreter overhead.

What is NCOMP:
------------------
The Java language was designed for a platform-independent,  secure development model. Translating Java  bytecodes into machine instructions degrades performance.  To regain some of the performance loss, you may choose to  natively compile certain classes. For example, you may decide to natively compile code with CPU intensive classes and this can be achived using NCOMP. In 10g one can install NCOMP from companion CD if they are really using JAVA intensive application an facing any performance issues because of the reason given above.
Note 134985.1 How to use JServer Accelerator and the NCOMP Utility

Schema:
--------
SYS

How to Install and De-Install:
------------------------------
Note 153271.1 How to manually install JVM into 8i database
Note 126029.1 How to Remove the Jserver (JVM) in versions 8.1.5 and 8.1.6 of the rdbms
Note 175472.1 How to Reload the JVM in 8.1.7.X
Note 202914.1 How to Reload the JVM in 9.0.1.X
Note 209870.1 How to Reload the JVM in 9.2.0.X
Note 276554.1 How to Reload the JVM in 10.1.0.X and 10.2.0.X
Note 457279.1 How to Reload the JVM in 11.1.0.x

FAQ:
------
Note 156439.1 How Does Oracle Store Java Casses Into Database
Note 265293.1 How To Find The Java Source Of A Java Stored Procedure
Note 397770.1 How to Correctly Check if the Oracle JVM is Installed in the Database
Note 471867.1 Simple Java Stored Procedure to Check that the Oracle JVM is Operating Correctly  

Documentation:
----------------
Overview of the Java Virtual Machine (JVM)

2. OLAP Catalog, OLAP Analytic Workspace, Oracle OLAP API

(9i,10gR1,10gR2,11gR1)

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.

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

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 208335.1 How To Manually Install Oracle OLAP into 9i and 10g
Note 296187.1 How To Manually Install Oracle OLAP into a 9i or 10g Database After the DB Has Been Created
Note 332351.1 How To Remove the OLAP Option and Add it again in Oracle Database 10g
Note 467643.1 How To Remove or De-activate OLAP After Migrating From 9i To Standard Edition 10g

Documentation:
----------------
Oracle® OLAP Application Developer's Guide 10g Release 2 (10.2)

3. Oracle Data Mining

(9i,10gR1,10gR2,11gR1)

Description:
------------
Oracle Data Mining (ODM) embeds data mining within the Oracle database. ODM algorithms operate natively on relational tables or views, thus eliminating the need to extract and transfer data into standalone tools or specialized analytic servers. ODM's integrated architecture results in a simpler, more reliable, and more efficient data management and analysis environment. Data mining tasks can run asynchronously and independently of any specific user interface as part of standard database processing pipelines and applications. Data analysts can mine the data in the database, build models and methodologies, and then turn those results and methodologies into full-fledged application components ready to be deployed in production environments. The benefits of the integration with the database cannot be emphasized enough when it comes to deploying models and scoring data in a production environment. ODM allows a user to take advantage of all aspects of Oracle's technology stack as part of an application. Also, fewer "moving parts" results in a simpler, more reliable, more powerful advanced business intelligence application.

Schema:
---------
ODM, ODM_MTR : Oracle 9i
DMSYS/ DMSYS  : Oracle 10g
SYS : Oracle 11gR1

Oracle Data Mining 11g Release 1 (11.1) has a tight integration with Oracle Database. Data Mining metadata and PL/SQL packages have been migrated from DMSYS to SYS. The DMSYS schema no longer exists in Oracle Database 11g Release 1 (11.1) fresh installations.

In 11g fresh installation 'Oracle Data Mining' will no longer appear in dba_registry view since it is not treated as a separate component in 11g, in fact it has been integrated into the database itself.  However if you have upgraded your database from an earlier version to 11g,  you may see this component in dba_registry. This is because of the existence of DMSYS schema, which is not used in 11g and all the objects of DMSYS are shifted to SYS during the upgrade process. So once you drop DMSYS schema,  'Oracle Data Mining' will disappear from the dba_registry.

How to Install and De-Install:
------------------------------
Note 420791.1 How To Manually Install Data Mining
Note 297551.1 How To Remove the Data Mining Option from the Database
Note 235486.1 How to check that the Oracle Data Mining (ODM) Monitor is running
Note 237348.1 The Oracle Data Mining Catalog has a LOADED status instead of a VALID Status

Documentation:
----------------
Oracle® Data Mining Concepts, 10g Release 2 (10.2)

4. Oracle InterMedia/(Oracle Multimedia in 11gR1)

Description:
------------
Oracle interMedia ("interMedia") is a feature that enables Oracle Database to store, manage, and retrieve images, audio, video, or other heterogeneous media data in an integrated fashion with other enterprise information. Oracle interMedia extends Oracle Database reliability, availability, and data management to multimedia content in traditional, Internet, electronic commerce, and media-rich applications.

In Oracle Database 11g Release 1 (11.1), the name Oracle interMedia has been changed to Oracle Multimedia.

Schema: 
------- 
ORDPLUGINS
ORDSYS
SI_INFORMTN_SCHEMA : 10g onwards.

The Oracle interMedia user. Plugins supplied by Oracle and third party format
plugins are installed in this schema.

How to Install and De-Install:
------------------------------
Note 337415.1 Where to Find the Information to Install, Upgrade, Downgrade and Deinstall interMedia/Oracle Multimedia?

FAQ:
------
Note 220018.1  Frequently Asked Questions for Oracle interMedia
Note 458123.1 Script. To Check If interMedia Is Being Used In Oracle Version 10.2
Note 458141.1 Script. To Check If interMedia Is Being Used In Oracle Version 9.2
Note 458140.1 Script. To Check If interMedia Is Being Used In Oracle Version 10.1
Note 221337.1 How to check if Intermedia Audio/Image/Video is Installed Correctly?

Documentation:
----------------
Oracle® interMedia User's Guide, 10g Release 2 (10.2)

5. Oracle Label Security

(9iR2,10gR1,10gR2,11gR1)

Description:
------------
Oracle Label Security (OLS) provides row-level security for your database tables. It protects data rows by labeling individual rows. If a user tries to access a data row protected by a policy, then he must have proper authorization as determined by the OLS label for the row.

Control of access to sensitive information is of concern to managers, information officers, DBAs, application developers, and many others. Selective access control based on a user's level of security clearance can ensure confidentiality without overbroad limitations. This level of access control ensures that sensitive information will be unavailable to unauthorized persons even while authorized users have access to needed information, sometimes in the same tables.

Data can be viewed as sensitive for different reasons. Examples include personal and private matters or communications, professional trade secrets, company plans for marketing or finance, military information, or government plans for research, purchases, or other actions.

Allowing information to be seen or used by inappropriate persons can be embarrassing, damaging, or dangerous to individuals, careers, organizations, agencies, governments, or countries.

Oracle Label Security obviates the need for such measures by enabling row-level access control, based on the virtual private database technology of Oracle Database 10g Release 2 (10.2) Enterprise Edition. It controls access to the contents of a row by comparing that row's label with a user's label and privileges. Administrators can easily add selective row-restrictive policies to existing databases by means of the user-friendly graphical interface called Oracle Policy Manager. Developers can readily add label-based access control to their Oracle Database applications.

Schema:
--------
LBACSYS (9iR2,10gR1,10gR2,11gR1)

How to Install and De-Install:
------------------------------
Note 171155.1 How to Install / Deinstall Oracle Label Security Oracle9i/10g
Installing OLS and Enabling the LBACSYS User (11gR1)

FAQ:
------
Note 213684.1 Oracle Label Security Frequently Asked Questions

Documentation:
-----------------
Oracle® Label Security Administrator's Guide 10g Release 2

6. Oracle Rule Manager and Oracle Expression Filter

(10gR2,11gR1)
Description:
------------
The 10i new feature allows you to store conditional expressions as data in the database. The Expression Filter provides a mechanism that you use to place a constraint on a VARCHAR2 column to ensure that the values stored are valid SQL WHERE clause expressions. The mechanism also identifies the set of attributes that can be referenced in the conditional expressions.

Oracle Expression Filter, a feature of Oracle Database 10g, is a component of Rules Manager that allows application developers to store, index, and evaluate conditional expressions (expressions) in one or more columns of a relational table. Expressions are a useful way to describe interests in expected data.
Expression Filter matches incoming data with expressions stored in a column to identify rows of interest. It can also derive complex relationships by matching data in one table with expressions in a second table. Expression Filter simplifies SQL queries; allows expressions to be inserted, updated, and deleted without changing the application; and enables reuse of conditional expressions in rules by separating them from the application and storing them in the database. Applications involving information distribution, demand analysis, and task assignment can benefit from Expression Filter.

The Rules Manager and Expression Filter features are the same in the Standard and Enterprise Editions. Support for indexing expressions is available only in the Enterprise Edition because it requires bitmap index support.

Schema:
---------
EXFSYS:
Each is supplied as a set of PL/SQL packages, a Java package, a set of dictionary tables, and catalog
views. All these objects are created in a dedicated schema named EXFSYS.

How to Install and De-Install:
------------------------------
Note 258618.1 - How To Install and Uninstall Expression Filter Feature or EXFSYS schema

 

Uninstalling Expression Filter implicitly uninstalls Rules Manager.

During installation of Oracle Database, a demonstration script. is installed for both the Rules Manager and
Expression Filter features. The scripts ruldemo.sql (Rules Manager demo) and exfdemo.sql (Expression Filter demo) are located in the $ORACLE_HOME/rdbms/demo/ directory.


Documentation:
----------------
Oracle Expression Filter Concepts 10gR2

 

7. Oracle Spatial

(9iR2,10gR2,11gR1)
Description:
------------
Oracle Spatial is designed to make spatial data management easier and more natural to users of location-enabled applications and geographic information system (GIS) applications. When spatial data is stored in an Oracle database, it can be easily manipulated, retrieved, and related to all other data stored in the database.

A common example of spatial data can be seen in a road map. A road map is a two-dimensional object that contains points, lines, and polygons that can represent cities, roads, and political boundaries such as states or provinces. A road map is a visualization of geographic information. The location of cities, roads, and political boundaries that exist on the surface of the Earth are projected onto a two-dimensional display or piece of paper, preserving the relative positions and relative distances of the rendered objects.

Schema:
---------
MDSYS/MDSYS The Oracle Spatial and Oracle interMedia Locator administrator account
MDDATA/MDDATA The schema used by Oracle Spatial for storing Geocoder and router data

How to Install and De-Install:
------------------------------
Note 179472.1 Steps for Manual De-installation of Oracle Spatial
Note 270588.1 Steps for Manual Installation / Verification of Spatial 10g / 11g
Note 220484.1 Steps for Manual Installation of Oracle 9i Spatial

FAQ:
------
Note 102313.1 What is Oracle Spatial? A Technical User Introduction
Note 273573.1 Removed Spatial Option But Spatial Still Appears In V$Option

Documentation:
----------------
Oracle® Spatial User's Guide and Reference, 10g Release 2 (10.2)

8. Oracle Text

(8i,9iR2,10gR1,10gR2,11gR1)

Description:
------------
Oracle Text indexes any document or textual content to add fast, accurate retrieval of information to internet content management applications, e-Business catalogs, news services, job postings, and so on. It can index content stored in file systems, databases, or on the Web.

Oracle Text allows text searches to be combined with regular database searches in a single SQL statement. It can find documents based on their textual content, metadata, or attributes. The Oracle Text SQL API makes it simple and intuitive to create and maintain Text indexes and run Text searches.

Schema:
---------
CTXSYS/CTXSYS The Oracle Text account

How to Install and De-Install:
------------------------------
Note 579601.1 Manual installation, deinstallation and verification of Oracle Text 11gR1
Note 280713.1 Manual installation, deinstallation of Oracle Text 10gR1 and 10gR2
Note 275689.1 Manual installation, deinstallation of Oracle Text 9.2.0.x
Note 150316.1 Manual installation of Oracle Text version 9.0.1
Note 73605.1 Installation of Oracle Text version 8.1.x (formally interMedia Text)
Note 177233.1 Manual deinstallation of Oracle Text (Intermedia Text)
Note 159959.1 How to Install Oracle Text 9.0.1 using Scripts

FAQ:
------
Note 153264.1 Frequently Asked Questions for Oracle Text

Documentation:
----------------
Oracle® Text Application Developer's Guide, 10g Release 2 (10.2) 

9. Oracle Ultra Search

(9iR2,10gR1,10gR2,11gR1)

Description:
------------
Oracle Ultra Search is built on the Oracle Database and Oracle Text technology that provides uniform. search-and-location capabilities over multiple repositories such as, Oracle databases, other ODBC compliant databases, IMAP mail servers, HTML documents served up by a Web server, files on disk, and more.

Oracle Ultra Search uses a crawler to collect documents. You can schedule the crawler to the Web sites that you want to search. The documents stay in their repositories, and the collected information is used to build an index that stays within the firewall in a designated Oracle Database. Oracle Ultra Search also provides APIs for building content management solutions.

Schema:
---------
WKSYS: Stores data dictionay for Oracle Ultrasearch.

How to Install and De-Install:
Note 337992.1 How to Manually Install and Uninstall Ultra Search 10gR2 Server Components
Note 177203.1 How to Manually Install and Uninstall Ultra Search 9.0.1 Server Components
Note 222517.1 How to Manually Install and Uninstall Ultra Search 9.2.0.x Server Components
Note 283292.1 How to Manually Install and Uninstall Ultra Search 10gR1 Server Components

FAQ:
------
Note 232648.1 Ultra Search Frequently Asked Questions

Documentation:
----------------
Oracle® Ultra Search Administrator's Guide, 10g Release 2 (10.2)

10. Oracle Workspace Manager

(9iR2,10gR1,10gR2,11gR1)

Description:
------------
Oracle Workspace Manager, is a new feature of Oracle9i that transparently and securely versions relational content in place with no changes to application SQL (DML), while permitting simultaneous read and write access to the same production data. Workspace Manager also supports Oracle8i, and Oracle Spatial, and is supported by Oracle9i Enterprise Manager.

Schema:
---------
WMSYS: It stores data dictionary for Oracle Workspace Manager

How to Install and De-Install:
------------------------------
Note 263428.1 How to De-install Oracle Workspace Manager
Note 341353.1 Why does the Workspace Manager version differ from the current RDBMS patchset version
How to install Workspace Manager with Custom Databases 11gR1

FAQ:
------
Note 156963.1 Frequently Asked Questions for Oracle Workspace Manager

Documentation:
----------------
Oracle® Database Application Developer's Guide - Workspace Manager, 10g Release 2 (10.2)

11. Oracle XDK for Java

(8i,9iR2,10gR2,11gR1)

Description:
-----------
Oracle Oracle XML Developer's Kit (XDK) is a versatile set of components that enables you to build and deploy C, C++, and Java software programs that process XML. You can assemble these components into an XML application that serves your business needs.

Oracle XDK provides the foundation for the Oracle XML solution. The XDK supports Oracle XML DB, which is a set of technologies used for storage and processing of XML in the database. You can use the XDK in conjunction with Oracle XML DB to build applications that run in Oracle Database. You can also use the XDK independently of XML DB.

The Oracle XDK is fully supported by Oracle Corporation and comes with a commercial redistribution license. The standard installation of Oracle Database includes the XDK.

Note:
Customers using Oracle XDK with PL/SQL and migrating from Oracle Database Release 8.1 or 9.2 are strongly encouraged to use AL32UTF8 as the database character set. Otherwise, issues can arise during PL/SQL processing of XML data that contains escaped entities. 

9206 XDK should be installed in 9204 database, 9207 XDK should be installed in 9205 database and 9208 XDK should be installed in 9206 server. That is why in 9.2.0.8 installation you will see XDK version 9.2.0.10

Schema:
--------- 
SYS: In 9.2 XDK should be installed in SYS schema, as 9.2.0.* patchsets upgrade XDK installed in SYS schema only.  

How to Install and De-Install:
------------------------------
There is no need to install XDK Java in 10g database as it comes with XDB schema. In 10g, much about XDK has been included in Oracle XML Database (XDB).

Note 317176.1 How to De-install corrupted pl/sql XDK in 9.2 and Install the right version
Note 171658.1 How To Install and Uninstall the XML Developers Toolkit
Note 435999.1 How To Install XDK 10.2.0.x ?
Note 277152.1 How to install XDK 9.2.0.x in an 8.1.7 Database Cleanly
Note 453050.1 How to Verify the XDK Installation

FAQ:
------
Note 250288.1  XDK For PL/SQL API Has Been Deprecated from 9.2 Database
Note 103871.1  XML Parser for PL/SQL FAQs
Note 103872.1  XML Parser for Java Version 2 - Frequently Asked Questions

Documentation:
----------------
Oracle® XML DB Developer's Guide, 10g Release 2 (10.2)

12. Oracle XML Database

Description:
------------
Extensible Markup Language (XML) is a tag-based markup language that lets developers create their own tags to describe data that's exchanged between applications and systems. XML is widely adopted as the common language of information exchange between companies. It is human-readable; that is, it is plain text. Because it is plain text, XML documents and XML-based messages can be sent easily using common protocols, such as HTTP or FTP.

Oracle XML DB treats XML as a native datatype in the database. Oracle XML DB is not a separate server. The XML data model encompasses both unstructured content and structured data. Applications can use standard SQL and XML operators to generate complex XML documents from SQL queries and to store XML documents.

Oracle XML DB provides capabilities for both content-oriented and data-oriented access. For developers who see XML as documents (news stories, articles, and so on), Oracle XML DB provides an XML repository accessible from standard protocols and SQL.

The Oracle XML developer's kits (XDK) contain the basic building blocks for reading, manipulating, transforming, and viewing XML documents, whether on a file system or stored in a database. They are available for Java, C, and C++. Unlike many shareware and trial XML components, the production Oracle XDKs are fully supported and come with a commercial redistribution license.

Schema:
---------
XDB: Stores XML database related schema objects.

How to Install and De-Install:
------------------------------
Note 243554.1 How to Deinstall and Reinstall XML Database (XDB)
Note 243553.1 Considerations Patching a DB with the XML Database (XDB) option
Note 742014.1 XDB 11g Install and Deinstall Note

FAQ:
------
Note 416132.1 XML Database FAQ administer Oracle
Note 733667.1 11g: How to Determine if XDB is Being Used in the Database?

Documentation:
----------------
Overview of XML in Oracle

13. Oracle Enterprise Manager

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 (11g 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)

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.

 

--------------------------------------------------------------------------------------------------------------------------------

Summary of administrative User Accounts Provided by Oracle Database:

Component Name 9iR2 10gR2 11gR1Oracle Data Mining ODM, ODM_MTR DMSYS SYSOracle Enterprise Manager DBSNMP
SYSMAN DBSNMP
SYSMAN
MGMT_VIEW DBSNMP
SYSMAN
MGMT_VIEWOracle InterMedia/
Oracle Multimedia 
(11gR1)

ORDPLUGINS
ORDSYS

ORDPLUGINS
ORDSYS
SI_INFORMTN_SCHEMA ORDPLUGINS
ORDSYS
SI_INFORMTN_SCHEMAOracle OLAP OLAPSYS OLAPSYS OLAPSYSOracle Label Security LBACSYS LBACSYS LBACSYSOracle Spatial MDSYS MDDATA
MDSYS MDDATA
MDSYS
SPATIAL_CSW_ADMIN_USR
SPATIAL_WFS_ADMIN_USROracle Text CTXSYS CTXSYS CTXSYSOracle XML Database XDB XDB XDBOracle Ultra Search WKSYS
WKPROXY WKSYS
WKPROXY WKSYS
WKPROXY
WMSYS
WK_TESTOracle Workspace Manager WMSYS WMSYS WMSYSOracle Warehouse Builder NA NA OWBSYSOracle Rule Manager & Expression Filtrer NA EXFSYS EXFSYS
You can also refer to the following note for Database Users: Password, Usage and Files References
Note 160861.1  Oracle Created Database Users: Password, Usage and Files References

Keywords

INSTALLATION ; DEINSTALL ; MDSYS ; WKSYS ; ULTRASEARCH ; XDB ; INTERMEDIA ; DE-INSTALL ; 

---

Help us improve our service. Please email us your comments for this document. .

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22782597/viewspace-618138/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22782597/viewspace-618138/