|
Oracle® Application Server Administrator's Guide
10g Release 2 (10.1.2) Part No. B13995-01 |
|
 Previous |
 Next |
|
Oracle® Application Server Administrator's Guide
10g Release 2 (10.1.2) Part No. B13995-01 |
|
|
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 theINTERNET_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
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
|
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 |
| 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 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-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 |
| 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 |
Table E-3 lists the management schemas.
Table E-3 Management Schema
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 |
| 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 |
