Thursday, 6 June 2013

IDs of SAP in Oracle DB #whatIlearned #work

During my search for proper scheme and ID I found out interesting document which is summarizing ID created by Oracle and SAP during initial system installation.

Interesting is, that nearly half of them is not used in my work *grin*.

IDs used by SAP are:
SAPR3 / SAP<sid> / SAP<xyz> / SAPSR3 
owner of all R/3 object
SAPR3SHD / SAP<sid>SHD / SAP<xyz>SHD / SAPSR3SHD 
- not required in BAU (only for SAP shadow upgrade)
SYSTEM 
- used and is pretty powerful (and owner of some objects)
SYS  
- powerful owner of most system tablespaces 
OPS$<sid>ADM (NT, UNIX) / OPS$SAPSERVICE<sid> (NT) 
- for BRTOOLS and used by R/3 itself
OUTLN 
Stored Outlines are managed in the OUTLN user.
SAP<sid>DB / SAP<xyz>DB / SAPSR3DB
- for J2EE environment as of Release 6.30

SAPPCD
- for EP environment.
SAPWCM
- for EP environment.

TSMSYS
- no use in R/3 environment.
DBSNMP
- no use in R/3 environment.
DIP
- no use in R/3 environment.
CTXSYS
no use in R/3 environment (except for Requisite/BugsEye)

INTERNAL
- no more available (from 9.0).

There is link to original and very interesting document:
 http://kmit4u.blogspot.cz/2010/09/sap-basis-sap-env-for-oracle-schemapriv.html

No comments:

Post a Comment