Skip Headers

Oracle9i Application Server Administrator's Guide
Release 2 (9.0.2)

Part Number A92171-02
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

C
Metadata Repository Schemas

The metadata repository, which is installed as part of every infrastructure installation, is an Oracle9i Enterprise Edition database that is pre-seeded with schemas to support Oracle9iAS components and features.

During installation, most metadata repository schemas are assigned randomized passwords and components are configured to access schemas using these passwords. If you want to change the password for any of these schemas, you must do so with the Enterprise Manager Web site. This ensures that the change is registered with the component as well as in the metadata repository.

See Also:

"Changing Component Schema Passwords" for instructions on changing passwords using Enterprise Manager Web site

A few schemas are assigned known passwords so that users can manually access them. You can change their passwords directly in the metadata repository using your preferred method, such as the SQL*Plus ALTER USER command.

Table C-1 lists each metadata repository schema that is used by an Oracle9iAS component or feature, provides its tablespace name, and indicates whether the password should be changed using the Enterprise Manager Web site, or directly in the metadata repository using your preferred method.

Table C-1 Metadata Repository Schemas  
Schema Tablespace Method for Changing Password

SCOTT

SYSTEM

Directly in metadata repository using preferred method (eg: SQL*Plus)

Note: It is not recommended that you change the SCOTT password since some demos may not work as a result.

SYS

SYSTEM

Directly in metadata repository using preferred method (eg: SQL*Plus)

SYSTEM

SYSTEM

Directly in metadata repository using preferred method (eg: SQL*Plus)

Oracle9iAS Clickstream Intelligence

CLKANA

CLK

EM Web site

CLKRT

CLK

EM Web site

Distributed Configuration Management (DCM)

DCM

DCM

EM Web site

Oracle9iAS Discoverer

DISCOVERER5

DISCO_PTM5_META

EM Web site

Oracle9iAS InterConnect (OAI)

OAIHUB902

USERS

EM Web site

Oracle Certificate Manager (OCM)

OCM_DB_ADMIN

OCM

EM Web site

Oracle Enterprise Manager

OEM_REPOSITORY

OEM_REPOSITORY

Directly in metadata repository using preferred method (eg: SQL*Plus)

Oracle Internet Directory

ODS

OLTS_DEFAULT

Directly in metadata repository using preferred method (eg: SQL*Plus)

ODSCOMMON

OLTS_DEFAULT

Directly in metadata repository using preferred method (eg: SQL*Plus)

Oracle9iAS Portal

PORTAL

PORTAL

EM Web site

PORTAL_APP

PORTAL

EM Web site

PORTAL_DEMO

PORTAL

EM Web site

PORTAL_PUBLIC

PORTAL

EM Web site

Oracle9iAS Single Sign-On

ORASSO

USERS

EM Web site

ORASSO_DS

USERS

EM Web site

ORASSO_PA

USERS

EM Web site

ORASSO_PS

USERS

EM Web site

ORASSO_PUBLIC

USERS

EM Web site

Oracle9iAS Syndication Server

DSGATEWAY

DS_GATEWAY

EM Web site

Oracle9iAS Web Services

DSSYS

DS_REGISTRY

EM Web site

UDDISYS

UDDISYS_TS

EM Web site

Oracle9iAS Wireless

WIRELESS

USERS

EM Web site

Oracle Workflow

BLEWIS

USERS

EM Web site

CDOUGLAS

USERS

EM Web site

KWALKER

USERS

EM Web site

OWF_MGR

USERS

EM Web site

SYSADMIN

USERS

EM Web site

WFADMIN

USERS

EM Web site


Go to previous page Go to next page
Oracle
Copyright © 2002 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