Skip Headers
Oracle® Fusion Middleware Administrator's Guide
11g Release 1 (11.1.1)

Part Number E10105-14
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

D Metadata Repository Schemas

Oracle Fusion Middleware components store metadata in a repository. Many components require a database repository to store schemas to support the component. This appendix provides information about those schemas.

This appendix contains the following topics:

D.1 Metadata Repository Schema Descriptions

Table D-1 lists the schemas used by Oracle Fusion Middleware components, sorted alphabetically by component. Note that the schema names are prefixed by the prefix you supplied when you ran the Repository Creation Utility.

Table D-1 Metadata Schemas Created by Repository Creation Utility

Component Schema Description

Oracle Access Manager

OAM

Contains information for Oracle Access Manager.

Oracle Adaptive Access Manager

OAAM

OAAM_PARTN

Contains information for Oracle Adaptive Access Manager.

Oracle B2B

SOAINFRA

Contains the design and run-time repository. The design repository has modeling metadata and profile data for an integration. These describe the behavior of the integration and sequence of steps required to execute the business process. The modeling and profile metadata is the design of the integration prior to deployment and execution. Once the integration is deployed, the run-time repository contains the metadata required to execute the integration as well as the business process instance, event instances, role instances, and other data created during execution.

Oracle BPEL Process Manager

MDS

SOAINFRA

MDS contains process definitions and configuration information.

SOAINFRA contains instance and metadata database objects for Oracle Business Activity Monitoring and Oracle BPEL Process Manager.

Oracle Business Activity Monitoring

ORABAM

MDS

Contains instance and metadata database objects for Oracle Business Activity Monitoring.

Oracle Business Intelligence

BIPLATFORM

Contains metadata for Business Intelligence Server.

Oracle Business Intelligence Discoverer

DISCOVERER

DISCOVERER_PS

Contains metadata for Discoverer Portlet Provider, portlet definitions for user portlets, and cached data obtained by running scheduled Discoverer queries. Has RESOURCE and CONNECT privileges.

Oracle Business Process Management

SOAINFRA

Contains metadata related to Oracle Business Process Management, as well as other SOA components.

Oracle Business Rules

MDS

Contains configuration information for Oracle Business Rules.

Oracle Content Server

OCS

Contains metadata information for Oracle Content Server 11g.

Oracle Data Integrator

ODI_REPO

Contains information for Oracle Data Integrator

Oracle Deployment Server

ODSSERVER

Contains metadata information for Oracle Deployment Server.

Oracle Directory Integration Platform

ODSSM

Contains configuration data for Oracle Directory Integration Platform.

Oracle Event Processing

MDS

MDS stores .MAR files, which store Oracle Event Processing .cqlsx files

Oracle Hyperion Enterprise Performance Management

EPM

Contains metadata for Oracle Hyperion Enterprise Performance Management.

Oracle Identity Federation

OIF

Contains metadata for Oracle Identity Federation.

Oracle Identity Manager

OIM

Contains metadata for applications that use Oracle Identity Manager.

Oracle Information Rights Management

ORAIRM

Contains metadata for Oracle Information Rights Management.

Oracle Internet Directory

ODS

ODSSM

For internal use.

Oracle Mediator

MDS

SOAINFRA

Contains metadata for Oracle Mediator.

Oracle Metadata Services

MDS

Contains metadata for applications that use MDS.

Oracle Portal

PORTAL

Contains Oracle Portal database objects and code.

Oracle Real-Time Decisions

RTD

For internal use.

Oracle Single Sign-On

ORASSO

For internal use.

Oracle SOA Suite Infrastructure

SOAINFRA

Contains metadata related to Oracle B2B, Oracle BPEL Process Manager, Oracle Business Process Management, Workflow, Sensor, Mediator, and CEP.

Oracle User Messaging

ORASDPM

Contains metadata related to User Messaging.

Oracle Web Services Manager

MDS

Contains configuration information.

Oracle WebCenter Content

OCS

OCSSEARCH

Contains metadata for Oracle WebCenter Content.

Oracle WebCenter Content: Imaging

IPM

Contains metadata for Oracle WebCenter Content: Imaging.

Oracle WebCenter Content: Records

URMSERVER

Contains metadata for Oracle WebCenter Content: Records

Oracle WebCenter Portal

WEBCENTER

MDS

Contains information for Oracle WebCenter Portal.

Oracle WebCenter Portal: Spaces

WEBCENTER

MDS

Contains information for WebCenter Portal services such as Links, lists, Tags, and Events.

Oracle WebCenter Portal's Activity Graph and Analytics

ACTIVITIES

Contains information for Oracle WebCenter Portal's Activity Graph and Analytics services.

Oracle WebCenter Portal's Portlet Producer

PORTLET

Contains information for WebCenter Portal's Portlet Producers.

Oracle WebCenter Portal's Discussion Server

DISCUSSIONS

DISCUSSIONS_CRAWLER

Contains information for Oracle WebCenter Portal discussion server.


D.2 Metadata Repository Schemas, Tablespaces, and Data Files

Table D-2 lists the tablespace and default data file for each Metadata Repository schema. It is sorted alphabetically by schema name. Note that the default data files are prefixed by the prefix you assigned the schemas in RCU.

In addition to the tablespaces listed, the tablespace IAS_TEMP is always created when you create a schema with RCU. Its data file is iastemp.dbf.

Table D-2 Metadata Repository Tablespaces and Data Files

Schema Tablespace Default Data File

ACTIVITIES

IAS_ACTIVITIES

activities.dbf

BIPLATFORM

BIPLATFORM

biplatform.dbf

DISCOVERER

DISCO_PTM5_META

DISCO_PTMS_CACHE

DISCO_PSTORE

discoptm5meta.dbf

discoptm5cache.dbf

discopstore.dbf

DISCUSSIONS

IAS_DISCUSS

iasjive.dbf

DISCUSSIONS_CRAWLER

IAS_DSCRAWL

iasjivecrawl.dbf

EPM

EPM

epm.dbf

IPM

IPM

ipm.dbf

MDS

MDS

iasmds.dbf

OAAM

BRSADATA

brsdatan.dbf

OAAM_PARTN

OAAM_DATA

partn_brsadatan.dbf

OAM

OAM

oam.dbf

OAM

OAM

oam.dbf

OCS

OCS

ocs.dbf

OCSSEARCH

OCSSEARCH

ocssearch.dbf

ODI_REPO

ODI_USER

prefix_odi_user_n.dbf

ODS

OLTS_DEFAULT

default1_oid.dbf

ODSERVER

ODSERVER

odserver.dbf

ODSSM

ODSSM

odssm.dbf

OIF

IAS_OIF

iasoif.dbf

OIM

OIM

oim.dbf

ORABAM

ORABAM

orabam.dbf

ORAIRM

ORAIRM

orairm.dbf

ORASDPLS

IAS_ORASDPLS

orasdpls.dbf

ORASDPM

IAS_ORASDPM

IAS_ORASDPM_AQ

iassdpm.dbf

iassdpmaq.dbf

ORASDPSDS

IAS_ORASDPSDS

orasdpsds.dbf

ORASDPSXDMS

IAS_ORASDPSXDMS

orasdpsxdms.dbf

ORASSO

IAS_ORASSO

iasorasso.dbf

PORTAL

PORTAL

PORTAL_IDX

PORTAL_LOG

PORTAL_DOC

portal.dbf

portalidx.dbf

portallog.dbf

portaldoc.dbf

PORTLET

IAS_PORTLET

webcenter_portlet.dbf

RTD

IAS_RTD

iasrtd.dbf

SOAINFRA

SOAINFRA

soainfra.dbf

URMSERVER

URMSERVER

urmserver.dbf

WEBCENTER

IAS_WEBCENTER

iaswebcenter.dbf