일반
2012.02.15 19:05

Known schemas in Oracle

댓글 0조회 수 21291
?

단축키

이전 문서

다음 문서

+ - Up Down Comment Print
?

단축키

이전 문서

다음 문서

+ - Up Down Comment Print

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


* Manually install for sample schemas *

When the sample schemas are installed manually, the driving script (mksample.sql) is invoked like so.
The first two arguments are the password for system and sys, respectively, followed by the six passwords for hr, oe, pm, ix, sh and bi, respectively, followed by the default tablspace and the default temp tablespace.

@?/demo/schema/mksample passwd_system passwd_sys pw_hr pw_oe pw_pm pw_ix pw_sh pw_bi users temp c:\temp\ora_schema_log


[From: http://www.adp-gmbh.ch/ora/misc/known_schemas.html]


번호 분류 제목 글쓴이 날짜
8 RAC Testing for Changing hostname via "hostname" cmd on Uinux  secret 김형조 2013.09.12
7 일반 ps 에서 보여주는 priority의 의미  secret 김형조 2013.09.12
6 일반 10060 trace name context forever   김형조 2012.02.21
5 일반 Reference Link - Active Data Guard   김형조 2012.02.16
4 일반 about SPA testing   김형조 2012.02.16
3 일반 DBA HIST desc all   김형조 2012.02.16
2 일반 event trace - method   관리자 2012.02.16
» 일반 Known schemas in Oracle   관리자 2012.02.15
Board Pagination ‹ Prev 1 Next ›
/ 1
Designed by hikaru100

나눔글꼴 설치 안내


이 PC에는 나눔글꼴이 설치되어 있지 않습니다.

이 사이트를 나눔글꼴로 보기 위해서는
나눔글꼴을 설치해야 합니다.

설치 취소

SketchBook5,스케치북5

SketchBook5,스케치북5

SketchBook5,스케치북5

SketchBook5,스케치북5

O R A C L E L A B 로그인 :)