Oracle® Application Server Administrator's Guide
10g Release 2 (10.1.2) B13995-06 |
|
Previous |
Next |
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:
This section lists the Metadata Repository schemas and describes their contents.
The schemas are divided into three categories:
These schemas are used by Identity Management components, such as OracleAS Single Sign-On and Oracle Internet Directory.
These schemas are used by middle-tier application components, such as OracleAS Portal and OracleAS Wireless.
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.
See Also: Section I.5, "Viewing Metadata Repository Release Numbers" for information on using the INTERNET_APPSERVER_REGISTRY schema to query release numbers |
Table E-1 lists the schemas used by Identity Management components, sorted alphabetically by component.
Table E-1 Identity Management Schemas
Component | Schema | Description |
---|---|---|
For internal use |
||
For internal use |
||
OracleAS Certificate Authority |
For internal use |
|
For internal use |
||
OracleAS Single Sign-On |
For internal use |
|
OracleAS Single Sign-On |
For internal use |
|
OracleAS Single Sign-On |
For internal use |
|
OracleAS Single Sign-On |
For internal use |
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 default instance schema—contains the document information and document index of the default Oracle Ultra Search instance |
||
Oracle Ultra Search |
Oracle Ultra Search proxy database user—does not contain any data |
|
Oracle Ultra Search |
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 |
|
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 |
||
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 |
N/AFoot 1 |
|
BAM |
Contains instance and metadata database objects for Oracle BPEL Process Analytics. |
|
ORABPEL |
Contains instance and metadata database objects for Oracle BPEL Process Manager. |
|
Contains Portal database objects and code. This schema also represents the proxy user account that |
||
OracleAS Portal |
Contains information for authentication of external JSP applications |
|
OracleAS Portal |
Contains demonstration code |
|
OracleAS Portal |
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 |
|
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 |
||
Web Clipping Repository for support with OracleAS Wireless—contains clipping definitions, user customizations, and PL/SQL packages for their access |
||
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 |
||
Contains metadata for Discoverer Portlet Provider, portlet definitions for user portlets, and cached data obtained by running scheduled Discoverer queries. Has |
||
N/A |
DSGATEWAYFoot 2 |
N/A |
Table E-3 lists the management schemas.
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 |
---|---|---|---|
DCM |
dcm.dbf |
||
Metadata Repository Version |
INTERNET_APPSERVER_REGISTRY |
ias_meta01.dbf |
|
OEM_REPOSITORY |
sysaux01.dbf |
||
ODS |
attrs1_oid.dbf |
||
Oracle Internet Directory |
ODS |
battrs1_oid.dbf |
|
Oracle Internet Directory |
ODS |
gcats1_oid.dbf |
|
Oracle Internet Directory |
ODS |
gdefault1_oid.dbf |
|
Oracle Internet Directory |
ODS |
svrmg1_oid.dbf |
|
WK_TEST |
sysaux01.dbf |
||
Oracle Ultra Search |
WKPROXY |
sysaux01.dbf |
|
Oracle Ultra Search |
WKSYS |
sysaux01.dbf |
|
OWF_MGR |
ias_meta01.dbf |
||
OCA |
oca.dbf |
||
OracleAS Certificate Authority |
ORAOCA_PUBLIC |
oca.dbf |
|
B2B |
b2b_dt.dbf |
||
OracleAS Integration B2B |
B2B |
b2b_rt.dbf |
|
OracleAS Integration B2B |
B2B |
b2b_lob.dbf |
|
OracleAS Integration B2B |
B2B |
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 |
PORTAL |
portal.dbf |
||
OracleAS Portal |
PORTAL |
ptldoc.dbf |
|
OracleAS Portal |
PORTAL |
ptlidx.dbf |
|
OracleAS Portal |
PORTAL |
ptllog.dbf |
|
OracleAS Portal |
PORTAL_APP |
portal.dbf |
|
OracleAS Portal |
PORTAL_DEMO |
portal.dbf |
|
OracleAS Portal |
PORTAL_PUBLIC |
portal.dbf |
|
ORASSO |
ias_meta01.dbf |
||
OracleAS Single Sign-On |
ORASSO_DS |
ias_meta01.dbf |
|
OracleAS Single Sign-On |
ORASSO_PA |
ias_meta01.dbf |
|
OracleAS Single Sign-On |
ORASSO_PS |
ias_meta01.dbf |
|
OracleAS Single Sign-On |
ORASSO_PUBLIC |
ias_meta01.dbf |
|
UDDISYS |
uddisys01.dbf |
||
WCRSYS |
wcrsys01.dbf |
||
WIRELESS |
ias_meta01.dbf |
||
DISCOVERER5 |
discopltm1.dbf |
||
OracleBI Discoverer |
DISCOVERER5 |
discopltm1 |
|
N/A |
DSGATEWAYFoot 2 |
oss_sys01.dbf |