D 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:

Metadata Repository Schema Descriptions
Metadata Repository Schemas, Tablespaces, and Default Datafiles

D.1 Metadata Repository Schema Descriptions

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

The schemas are divided into three categories:

Identity Management Schemas

These schemas are used by Identity Management components, such as OracleAS Single Sign-On and Oracle Internet Directory.
Product Metadata Schemas

These schemas are used by middle-tier application components, such as OracleAS Portal and OracleAS Wireless.
Management Schema

This is a single schema that is used by Distributed Configuration Management (DCM).

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 H.5, "Viewing Metadata Repository Release Numbers" for information on using the INTERNET_APPSERVER_REGISTRY schema to query release numbers

D.1.1 Identity Management Schemas

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

Table D-1 Identity Management Schemas

Component	Schema	Description
Oracle Internet Directory	`ODS`	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
OracleAS Certificate Authority	`OCA`	For internal use
OracleAS Certificate Authority	`ORAOCA_PUBLIC`	For internal use

D.1.2 Product Metadata Schemas

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

Table D-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 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.
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`	Used for authentication of external JSP applications
OracleAS Portal	`PORTAL_DEMO`	Demonstration code
OracleAS Portal	`PORTAL_PUBLIC`	All lightweight users 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 ProcessConnect	`IP`	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 Syndication Services	`DSGATEWAY`	Contains offer, subscription, and content provider information; channel portlet metadata; runtime system properties; escheduling information
OracleAS UDDI Registry	`UDDISYS`	Contains UDDI entities such as business entities, business services, binding templates, tModels, and publisher assertions; taxonomy structures like North American Industry Classification System (NAICS), Universal Standard Products and Services Codes (UNSPSC), and ISO 3166 Geographic Taxonomy (ISO 3166); UDDI replication/subscription related internal tables; and other administration-related views and tables
OracleAS Web Clipping	`WCRSYS`	Web Clipping Repository for support with 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

D.1.3 Management Schema

Table D-3 lists the schema used by Distributed Configuration Management (DCM).

Table D-3 Management Schema

Component	Schema	Description
Distributed Configuration Management (DCM)	`DCM`	Contains configuration information for OC4J and Oracle HTTP Server instances, application server instances, clusters, and farms

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

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

Table D-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 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`	`IAS_META`	ias_meta01.dbf
Oracle Ultra Search	`WKPROXY`	`IAS_META`	ias_meta01.dbf
Oracle Ultra Search	`WKSYS`	`IAS_META`	ias_meta01.dbf
Oracle Workflow	`OWF_MGR`	`IAS_META`	ias_meta01.dbf
OracleAS Certificate Authority	`OCA`	`OCATS`	oca.dbf
OracleAS Certificate Authority	`ORAOCA_PUBLIC`	`IAS_META`	ias_meta01.dbf
OracleAS Discoverer	`DISCOVERER5`	`DISCO_PTM5_META`	discopltm1.dbf
OracleAS Discoverer	`DISCOVERER5`	`DISCO_PTM5_CACHE`	discopltc1.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 ProcessConnect	`IP`	`IP_DT`	ip_dt.dbf
OracleAS ProcessConnect	`IP`	`IP_RT`	ip_rt.dbf
OracleAS ProcessConnect	`IP`	`IP_LOB`	ip_lob.dbf
OracleAS ProcessConnect	`IP`	`IP_IDX`	ip_idx.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 Syndication Services	`DSGATEWAY`	`DSGATEWAY_TAB`	oss_sys01.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