Skip Headers
Oracle® Application Server Administrator's Guide
10g Release 2 (10.1.2)
B13995-06
  Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
Next
Next
 

E Metadata Repository Schemas

A Metadata Repository is an Oracle database that is pre-seeded with additional schemas to support Oracle Application Server. This appendix provides information about those schemas.

It contains the following topics:

E.1 Metadata Repository Schema Descriptions

This section lists the Metadata Repository schemas and describes their contents.

The schemas are divided into three categories:

There is one additional schema that does not fall into the previously listed categories: INTERNET_APPSERVER_REGISTRY. This schema contains release numbers for Metadata Repository schemas.


See Also:

Section I.5, "Viewing Metadata Repository Release Numbers" for information on using the INTERNET_APPSERVER_REGISTRY schema to query release numbers

E.1.1 Identity Management Schemas

Table E-1 lists the schemas used by Identity Management components, sorted alphabetically by component.

Table E-1 Identity Management Schemas

Component Schema Description

Oracle Internet Directory

ODS

For internal use

OracleAS Certificate Authority

OCA

For internal use

OracleAS Certificate Authority


ORAOCA_PUBLIC

For internal use

OracleAS Single Sign-On

ORASSO

For internal use

OracleAS Single Sign-On


ORASSO_DS

For internal use

OracleAS Single Sign-On


ORASSO_PA

For internal use

OracleAS Single Sign-On


ORASSO_PS

For internal use

OracleAS Single Sign-On


ORASSO_PUBLIC

For internal use


E.1.2 Product Metadata Schemas

Table E-2 lists the schemas used by middle-tier application components, sorted alphabetically by component.

Table E-2 Product Metadata Schemas

Component Schema Description

Oracle Ultra Search

WK_TEST

Oracle Ultra Search default instance schema—contains the document information and document index of the default Oracle Ultra Search instance

Oracle Ultra Search


WKPROXY

Oracle Ultra Search proxy database user—does not contain any data

Oracle Ultra Search


WKSYS

Oracle Ultra Search metadata repository—contains metadata information on data sources, crawler configuration, crawling schedules, trace logs, attribute mappings, authentication, and user privileges of Oracle Ultra Search instances

Oracle Workflow

OWF_MGR

Contains design-time and runtime workflow tables, queues, PL/SQL code, directory service database views and local tables, and metadata for workflow processes and business events

OracleAS Integration B2B

B2B

Contains the design and runtime 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 runtime 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.

OracleAS Integration B2B


IP

N/AFoot 1 

Oracle BPEL Process Analytics

BAM

Contains instance and metadata database objects for Oracle BPEL Process Analytics.

Oracle BPEL Process Manager

ORABPEL

Contains instance and metadata database objects for Oracle BPEL Process Manager.

OracleAS Portal

PORTAL

Contains Portal database objects and code. This schema also represents the proxy user account that mod_plsql uses to connect to the database through the credentials provided in the corresponding DAD.

OracleAS Portal


PORTAL_APP

Contains information for authentication of external JSP applications

OracleAS Portal


PORTAL_DEMO

Contains demonstration code

OracleAS Portal


PORTAL_PUBLIC

OracleAS Portal schema for all lightweight users, who are mapped to this schema by default. All procedures publicly accessible through the Web are granted execute to PUBLIC, which makes them accessible through this schema.

OracleAS UDDI Registry

UDDISYS

Contains UDDI entities such as business entities, business services, binding templates, tModels, and publisher assertions; taxonomy structures such as North American Industry Classification System (NAICS), Universal Standard Products and Services Codes (UNSPSC), and ISO 3166 Geographic Taxonomy (ISO 3166); UDDI replication-related internal tables; and other administration-related views and tables

OracleAS Web Clipping

WCRSYS

Web Clipping Repository for support with OracleAS Wireless—contains clipping definitions, user customizations, and PL/SQL packages for their access

OracleAS Wireless

WIRELESS

Contains user content (folders, services, links, notifications, presets), user customization data, groups, roles, transient user information, style sheets, logical device definitions, Java transformers (serialized), adapters, location data, configuration data, process runtime state, and application metrics

OracleBI Discoverer

DISCOVERER5

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.

N/A

DSGATEWAYFoot 2 

N/A


Footnote 1 Beginning with Oracle Application Server 10g Release 2 (10.1.2), the IP schema contains no data. It has been replaced by the B2B schema and is provided only for backward compatibility.
Footnote 2 Beginning with Oracle Application Server 10g Release 2 (10.1.2), the DSGATEWAY schema is not used. It is provided for backward compatibility.

E.1.3 Management Schemas

Table E-3 lists the management schemas.

Table E-3 Management Schema

Component Schema Description

Distributed Configuration Management (DCM)

DCM

Contains configuration information for OC4J and Oracle HTTP Server instances, application server instances, OracleAS Clusters, and farms

Oracle Enterprise Manager

OEM_REPOSITORY

Repository for Database Control


E.2 Metadata Repository Schemas, Tablespaces, and Default Datafiles

Table E-4 lists the tablespace and default datafile for each Metadata Repository schema. It is sorted alphabetically by component.

Table E-4 Metadata Repository Tablespaces and Default Datafiles

Component Schema Tablespace Default Datafile

Distributed Configuration Management (DCM)

DCM

DCM

dcm.dbf

Metadata Repository Version

INTERNET_APPSERVER_REGISTRY

IAS_META

ias_meta01.dbf

Oracle Enterprise Manager

OEM_REPOSITORY

SYS_AUX

sysaux01.dbf

Oracle Internet Directory

ODS

OLTS_ATTRSTORE

attrs1_oid.dbf

Oracle Internet Directory


ODS

OLTS_BATTRSTORE

battrs1_oid.dbf

Oracle Internet Directory


ODS

OLTS_CT_STORE

gcats1_oid.dbf

Oracle Internet Directory


ODS

OLTS_DEFAULT

gdefault1_oid.dbf

Oracle Internet Directory


ODS

OLTS_SVRMGSTORE

svrmg1_oid.dbf

Oracle Ultra Search

WK_TEST

SYSAUX

sysaux01.dbf

Oracle Ultra Search


WKPROXY

SYSAUX

sysaux01.dbf

Oracle Ultra Search


WKSYS

SYSAUX

sysaux01.dbf

Oracle Workflow

OWF_MGR

IAS_META

ias_meta01.dbf

OracleAS Certificate Authority

OCA

OCATS

oca.dbf

OracleAS Certificate Authority


ORAOCA_PUBLIC

OCATS

oca.dbf

OracleAS Integration B2B

B2B

B2B_DT

b2b_dt.dbf

OracleAS Integration B2B


B2B

B2B_RT

b2b_rt.dbf

OracleAS Integration B2B


B2B

B2B_LOB

b2b_lob.dbf

OracleAS Integration B2B


B2B

B2B_IDX

b2b_idx.dbf

OracleAS Integration B2B


IPFoot 1 

N/A

N/A

Oracle BPEL Process Analytics


BAM

BAM

bam.dbf

Oracle BPEL Process Manager


ORABPEL

ORABPEL

orabpel.dbf

OracleAS Portal

PORTAL

PORTAL

portal.dbf

OracleAS Portal


PORTAL

PORTAL_DOC

ptldoc.dbf

OracleAS Portal


PORTAL

PORTAL_IDX

ptlidx.dbf

OracleAS Portal


PORTAL

PORTAL_LOG

ptllog.dbf

OracleAS Portal


PORTAL_APP

PORTAL

portal.dbf

OracleAS Portal


PORTAL_DEMO

PORTAL

portal.dbf

OracleAS Portal


PORTAL_PUBLIC

PORTAL

portal.dbf

OracleAS Single Sign-On

ORASSO

IAS_META

ias_meta01.dbf

OracleAS Single Sign-On


ORASSO_DS

IAS_META

ias_meta01.dbf

OracleAS Single Sign-On


ORASSO_PA

IAS_META

ias_meta01.dbf

OracleAS Single Sign-On


ORASSO_PS

IAS_META

ias_meta01.dbf

OracleAS Single Sign-On


ORASSO_PUBLIC

IAS_META

ias_meta01.dbf

OracleAS UDDI Registry

UDDISYS

UDDISYS_TS

uddisys01.dbf

OracleAS Web Clipping

WCRSYS

WCRSYS_TS

wcrsys01.dbf

OracleAS Wireless

WIRELESS

IAS_META

ias_meta01.dbf

OracleBI Discoverer

DISCOVERER5

DISCO_PTM5_META

discopltm1.dbf

OracleBI Discoverer


DISCOVERER5

DISCO_PTM5_CACHE

discopltm1

N/A

DSGATEWAYFoot 2 

DSGATEWAY_TAB

oss_sys01.dbf


Footnote 1 Beginning with Oracle Application Server 10g Release 2 (10.1.2), the IP schema does not contain any data. It has been replaced by the B2B schema and is provided only for backward compatibility.
Footnote 2 Beginning with Oracle Application Server 10g Release 2 (10.1.2), the DSGATEWAY schema is not used. It is provided for backward compatibility.