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:

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

E.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 Schemas

These schemas are used for Oracle Application Server management.

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.

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/A^Foot 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	DSGATEWAY^Foot 2	N/A

^Footnote 1Beginning 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 2Beginning 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	IP^Foot 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	DSGATEWAY^Foot 2	DSGATEWAY_TAB	oss_sys01.dbf

^Footnote 1Beginning 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 2Beginning with Oracle Application Server 10g Release 2 (10.1.2), the DSGATEWAY schema is not used. It is provided for backward compatibility.