René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Known schemas in Oracle

This is a (most probably unfinished) list of users that come with an Oracle installation or with installing the Oracle sample schemas.
For most of these users, the default password is the same as the username. Where this is not the case, I have noted it.

anonymous

Used for HTTP access to XML DB.

apex_public_user

apex_030200

appqossys

bi

This user is created with the oracle sample schemas. It owns the Business Intelligence schema.

ctxsys

The owner of Oracle text (formerly: interMedia text).

dbsnmp

Part of the Oracle intelligent agent.
The password is assigned during the installation.
This user is created (or re-created) with ORACLE_HOME/rdbms/admin/catsnmp.sql and dropped with $ORACLE_HOME/rdbms/admin/catnsnmp.sql.

dip

Used by the Directory Integration Platform (DIP) which synchronizes changes in the Oracle Internet Directory with applications in the database.

dmsys

This user is used for Data Mining.

exfsys

This schema is used for expression filters.

flows_XXXXXX

This seems to be the user for APEX (Oracle Application Express) (on Oracle Express Edition???). XXXXXX seems to be the version number of APEX. So, APEX 2.1 has flows_020100.

hr

Installed with Oracle sample schemas. It owns the Human Resource schema.

ix

Installed with Oracle sample schemas. It owns the Information Transport schema.

lbacsys

The administration account for Oracle Label Security.

mddata

Used by Oracle Spatial to store Geocoder and router data.

mdsys

The owner of spatial (which is a part of interMedia).

mgmt_view

Used for the Oracle Enterprise Manager Database Control.
Its password is generated randomly.

odm

The Data mining schema. Since Oracle 10g, the name can be freely chosen.

odm_mtr

Used for the data repository for data mining samples.
Default password: mtrpw.

oe

Installed with Oracle sample schemas. It owns the Order Entry schema.

olapsys

The schema that owns the OLAP catalogs.
Default password: manager.

oracle_ocm

orddata

ordplugins

Like mdsys: part of interMedia. Third party plugins (as well as Oracle plugins) for interMedia are installed into this schema.

ordsys

The administration account for interMedia.

outln

Used for the query plan stability feature.
outln owns ol$, ol$hints and ol$nodes.

pm

Installed with Oracle sample schemas. It owns the Product Media schema.

scott

Used for Oracle examples.
Its default password is tiger.
This schema is created by executing $ORACLE_HOME/sqlplus/demo/demobld.sql (demodrop.sql drops scott.)

sh

Installed with Oracle sample schemas. It owns the Sales History schema.

si_informtn_schema

Used for SQL/MM Still Image Standard.

spatial_csw_admin_usr

spatial_wfs_admin_usr

sys

Used for database administration. See this link.
The password is set when the database is installed.

sysman

The default super user account used to set up and administer enterprise manager.
The password is set when the database is installed.

system

Used for database administration. See this link.
The password is set when the database is installed.

tracesrv

Used for Oracle trace. Not used anymore since Oracle 8.

mtssys

Used for Microsoft transaction server support.

oaspublic

olapsys

Used for OLAP.

owbsys

owbsys_audit

websys

wk_proxy

Used for ultrasearch.
Default password: wksys.

wksys

Used for ultrasearch.
Default password: wmsys.

wk_test

wmsys

The owner for Workspace Manager.

xdb

Used for XML DB.

OSE$HTTP$ADMIN

AURORA$JIS$UTILITY$

AURORA$ORB$UNAUTHENTICATED