Skip Headers

Oracle Application Server 10g Administrator's Guide
10g (9.0.4)

Part Number B10376-01
Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index

Go to previous page Go to next page

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:

D.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 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 Industy 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


Go to previous page Go to next page
Oracle
Copyright © 2002, 2003 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index