SWA Monitoring HPOM & BMT Environment Overview ECC Landscape PI Landscape GRC Landscape EP Landscape
Components monitored by SAPSPI - Number of free backround work processes! - Last successfu" update statistics - Orac"e Locks #more t$an % $ours& - 'issin primary database inde(es - Spoo" Numbers) w$en *sed Numbers reac$ +,- OS co""ector status - .ia"o response time #runnin more t$an /,0,,, msec in t$e "ast $our& - .ia"o 1ueue time #230,,, msec in t$e "ast 23 minutes& - Spoo" 4ueue "ent$ e(ceeds +5- SAP 6uffer swaps #Proram0 Sin"e Record0 C*A 7 etc& .umps #w$en #w$en t$ere are / dumps dumps in t$e t$e "ast 3 minutes& minutes& - A6AP .umps - 8ai"ed SAP 6asis 6ackround 9obs! Ot$er critica" fai"ed :obs are monitored by Sc$edu"in team t$rou$ 'AES;RO! - O"d SAP Locks #more t$an /< $ours& - SAP *pdate status #a"ert w$en it is not active& - C$eck dia"o work processes w$en t$ey are in PRI= mode! C$eck S'% S'%2 2 for t$e t$e fo"" fo""ow owin in erro errorr codes codes #A,30 #A,30 A,>0 A,>0 6?, 6?, 0 8<+0 8<+0 85?0 85?0 - C$eck 8520 8AI0 8A90 86N0 86*0 GEG0 P,/0 P,+0 P,60 1,S0 1,;0 1,*0 R,O0 R,R0 R2P0 R%,0 R@30 S2/0 S/,0 *S+& - 'onitorin t$e system overa"" status #A"ert w$en SAP is down or $un&
'onitored fi"esystems and processes Filesystem monitoring - % full full warning (IE (IE 80% full) - % full page (IE 90% full) - filesytem filesytem NOT mounted - tunale (warning!page) (warning!page) for ea"# filesytem filesytem on system system - typi"ally monitor $ust $ust filesystems related to &'!asis Ora"le elated - in"orre"tly in a"*up mode (IE no a"*up a"tually running) - Tale monitoring - o$e"ts +, 80% of ma etents etents - &r"#i.e mode - &r"#i.e &r"#i.e mode on!off
- Ora"le errors - tra"e files - /ataase #ealt# - pdates Ora"le statisti"s - pdates net etent si1es - /aily /ataase 2erifi"ations (/23s) - 4ee*ly full Ora"le eports &' - &.ailaility of &ppli"ation ser.er 5 6I - monitor up!down if "onfigured in 667 &'!IT - ITScheck for connectivity between SAP R/3 and ITS
Components monitored by SAPSPI Oracle DB-SPI Base
Description .atabase Status
DBSPI Template/Metric Suspend.own
Frequenc
.6SPIB,,,2
3
.atabase Process C$eck
.6SPIB,,,%
3
of sements t$at cannot e(tend
.6SPIB,,2<
23
of sements approac$in ma( e(tent
.6SPIB,,25
23
;ab"espaces free space
.6SPIB,%,<
3
;ab"espaces free space Emai"
.6SPIB,%,<
3
Orac"e Listener process status
3
.6SPI errors
.6SPIB'essaes!
Oracle DB-SPI Message Interceptor
Description
O!SD Se"erit
.6SPI2,B%% or %/) *nab"e to connect to database!
Critica"
.6SPI2,B%@) Connect to .6 timed out after seconds! P"ease c$eck database!
Critica"
.6SPI2,B%5) Orac"e Listener process is not runnin!
Critica"
.6SPI2,B%>) *nab"e to c$eck Orac"e ListenerD .6SPI is not confiured!
'edium
.6SPI2,B%+) One or more Orac"e network services are not confiured!
Critica"
.6SPI2,B%) *pper bound is "ower t$an "ower bound!
'edium
.6SPI2,B/,) Cannot connect to t$e Orac"e Listener usin userpassF
Critica"
.6SPI2,B/) Inva"id c$aracter in rane #number e(pected&!
'edium
.6SPI2,B32) Interna" Error from I;O interface!
Critica"
.6SPI%,B2) ;$e confiuration fi"e does not e(ist! P"ease confiure t$is node!
*rent
Description
O!SD Se"erit
.6SPI%,B/) Co""ectionAna"ysis $as been turned ONO88
Critica"
.6SPI/,B2) Synta( error!
'edium
.6SPI/2B%) .up"icate definition of database!
i$
.6SPI/2B+) Co""ection for metric fai"ed #dbspiHerror!!!&
*rent
.6SPI@,B2@) ;$e ca"" to function -s in -s fai"ed!
Critica"
.6SPI@,B2<) Sysprofi"e name J-sJ not found! *nab"e to ca"cu"ate metric!
i$
.6SPI2,B2) Inva"id c$aracter in rane! .6SPI2,B%3) Error durin *.' code e (ecution for metric! .6SPI2,B>2) *nab"e to ain "ock fi"e! 8i"e a"ready in use by anot$er process! .6SPI%,B%) 'etric $as no report defined! .6SPI%,B3) .6BSPI .SI "ofi"es need to be converted! .6SPI/,B%) No instance defined for O'EF B inored! .6SPI/,B/) ParmF a"ready defined ear"ier B inorin t$is definition! .6SPI/,B@) 8i"ter for metric K a"ready defined ear"ier B inorin t$is definition .6SPI/2B2,) No *.' confiuration avai"ab"e #confi fi"e insta""ed&! .6SPI/2B22) 'etric a"ready defined! .6SPI/2B2) Report a"ready defined! .6SPI/2B/) COLLEC; statement missin for metric! .6SPI/2B@) COLLEC; statement for metric a"ready defined! .6SPI/2B3) COLLEC; option for metric a"ready defined B inored! .6SPI/2B5) 'etric not defined! .6SPI/2B>) Report not defined! .6SPI@,B22) *nab"e to create view for tab"e tab"eF for metric metricF! .6SPI@,B2/) Connection attempt to server -s wit$ user -s fai"ed! .6SPI@,B23) *nab"e to "oad dbspi stored procedures on server -s! .6SPI) A"" remainin errors!
Oracle DB-SPI Oracle log-#ile
Description
Frequency
OVSD Severity
ORA-00018 Max number of sessions exceeded
10 minutes
Urgent
ORA-00019 Max number of sessions licenses exceeded
10 minutes
Urgent
ORA-00020 Max number of processes exceeded
10 minutes
Urgent
ORA-00025 ailed to allocate memor!
10 minutes
Urgent
ORA-00050 O"# error occurred $%ile obtaining en&ueue
10 minutes
Urgent
ORA-00051 'ime-out occurred $%ile $aiting for resource
10 minutes
Urgent
ORA-00052 Max number of en&ueue resources exceeded
10 minutes
Urgent
ORA-0005( Max number of en&ueues exceeded
10 minutes
Urgent
ORA-00055 Max number of )M*+*O,# exceeded
10 minutes
Urgent
Description
Frequency
OVSD Severity
ORA-0005. Max number of temp table loc/s exceeded
10 minutes
Urgent
ORA-00059 Max number of datafiles exceeded
10 minutes
Urgent
ORA-000( *O+*3# initiali4ation parameter exceeded
10 minutes
Urgent
ORA-0010 )eadloc/ detected 6public ser7ers
10 minutes
Urgent
ORA-00151 #!stem tablespace cannot be broug%t offline
10 minutes
Urgent
ORA-0015 ,annot drop s!stem rollbac/ segment
10 minutes
Urgent
ORA-001550 ,annot drop s!stem tablespace
10 minutes
Urgent
ORA-00155 Out of transaction slots in transaction tables
10 minutes
Urgent
ORA-001555 #naps%ot too old
10 minutes
Urgent
ORA-001558 Out of transaction )s in rollbac/ segment
10 minutes
Urgent
ORA-00152 ailed to extend rollbac/ segment
10 minutes
Urgent
ORA-0015.2 Rollbac/ segment to big
10 minutes
Urgent
ORA-0020 3rror reading control file
10 minutes
,ritical
ORA-0020 3rror $riting control file
10 minutes
,ritical
ORA-00210 ,annot open control file
10 minutes
,ritical
ORA-0021 Unable to determine bloc/ si4e for control file
10 minutes
,ritical
ORA-0021. nconsistent control file bloc/ si4e
10 minutes
,ritical
ORA-00218 ,%anged control file bloc/ si4e
10 minutes
,ritical
ORA-00221 3rror on $rite to control file
10 minutes
,ritical
ORA-00255 3rror arc%i7ing log
10 minutes
Urgent
ORA-0025. Arc%i7er stuc/
10 minutes
Urgent
ORA-0025 nstance reco7er! re&uired
10 minutes
Urgent
ORA-002.0 3rror creating arc%i7e log
10 minutes
Urgent
ORA-002.2 3rror $riting arc%i7e log
10 minutes
Urgent
ORA-00290 Operating s!stem arc%i7ing error
10 minutes
Urgent
ORA-00(02 *imit of number of redo logs exceeded
10 minutes
Urgent
ORA-00(5 Redo log $rite error
10 minutes
Urgent
ORA-00(8 #ingle process redo failure
10 minutes
,ritical
ORA-00(.1 o free buffer %andles a7ailable
10 minutes
Urgent
ORA-00(90 *og file is being cleared: cannot become current log
10 minutes
ORA-00(92 *og file is being cleared: operation not allo$ed
10 minutes
Urgent
ORA-00( Oracle is not licensed
10 minutes
Urgent
ORA-00(. Oracle feature is not licensed
10 minutes
Urgent
ORA-00( bac/ground process did not start
10 minutes
,ritical
ORA-00 bac/ground process failed $%ile starting
10 minutes
,ritical
ORA-005 bac/ground process did not start after n seconds
10 minutes
,ritical
ORA-00 bac/ground process started $%en not expected
10 minutes
Urgent
ORA-00. fatal error in bac/ground process
10 minutes
,ritical
Urgent
Description
Frequency
OVSD Severity
ORA-009 bac/ground process unexpectedl! terminated
10 minutes
,ritical
ORA-00.0 *;R process terminated $it% error
10 minutes
,ritical
ORA-00.1 )<;R process terminated $it% error
10 minutes
,ritical
ORA-00.2 =MO process terminated $it% error
10 minutes
,ritical
ORA-00.( AR,> process terminated $it% error
10 minutes
,ritical
ORA-00. #MO process terminated $it% error
10 minutes
,ritical
ORA-00.5 'R;R process terminated $it% error
10 minutes
,ritical
ORA-00. R3,O process terminated $it% error
10 minutes
,ritical
ORA-00.. #=x process terminated $it% error
10 minutes
,ritical
ORA-0080 *,x process terminated $it% error
10 minutes
,ritical
ORA-008( )uring s%utdo$n a process abnormall! terminated
10 minutes
,ritical
ORA-0000 nternal error code
10 minutes
Urgent
ORA-0001 ,leanup loc/ conflict
10 minutes
Urgent
ORA-0002 nternal programming exception
10 minutes
Urgent
ORA-000( Oracle #er7er session terminated b! fatal error
10 minutes
Urgent
ORA-000 3rror occurred at recursi7e #?* le7el
10 minutes
Urgent
ORA-000 nternal error code
10 minutes
Urgent
ORA-00.0( Maximum number of dictionar! cac%e instance loc/s exceeded
10 minutes
ORA-0111 O error $riting bloc/ to file
10 minutes
,ritical
ORA-01115 O error reading bloc/ from file
10 minutes
,ritical
ORA-0111 3rror in opening datafile
10 minutes
,ritical
ORA-01118 ,annot add more datafiles
10 minutes
Urgent
ORA-01122 datafile failed 7erification c%ec/
10 minutes
Urgent
ORA-0112( ,annot start online bac/up
10 minutes
Urgent
ORA-01128 ,annot start online bac/up
10 minutes
Urgent
ORA-0119 ,annot s%utdo$n because online bac/up set
10 minutes
Urgent
ORA-0115 )atabase bus!
10 minutes
Urgent
ORA-01155 )atabase is being open or closed
10 minutes
Urgent
ORA-0121 3xternal cac%e %as died
10 minutes
Urgent
ORA-0122 )ata file suffered media failure
10 minutes
Urgent
ORA-012( #!stem tablespace file suffered media failure
10 minutes
Urgent
ORA-015. Max number of concurrent transactions exceeded
10 minutes
Urgent
ORA-015.8 Oracle data bloc/ corrupted
10 minutes
,ritical
ORA-01599 ,ac%e space is full
10 minutes
Urgent
ORA-0128 Max number of extents reac%ed for rollbac/ segment
10 minutes
ORA-0129 Max number of extents reac%ed sa7ing undo
10 minutes
Urgent
ORA-01(0 Max number of extents reac%ed in temp segment
10 minutes
Urgent
Urgent
Urgent
Description
Frequency
OVSD Severity
ORA-01(1 Max number of extents reac%ed in table
10 minutes
Urgent
ORA-01(2 Max number of extents reac%ed in index
10 minutes
Urgent
ORA-0150 Unable to extend rollbac/ segment
10 minutes
Urgent
ORA-0151 Unable to extend sa7e undo segment
10 minutes
Urgent
ORA-0152 Unable to extend temp segment
10 minutes
Urgent
ORA-015( Unable to extend table
10 minutes
Urgent
ORA-015 Unable to extend index
10 minutes
Urgent
ORA-0155 Unable to extend cluster
10 minutes
Urgent
ORA-015 Max number of extents reac%ed in cluster
10 minutes
Urgent
#%utting do$n instance 6abort
10 minutes
#%utting do$n instance 6immediate
10 minutes
#%utting do$n instance 6normal
10 minutes
#tarting Oracle instance 6normal
10 minutes
#tarting up Oracle R)
10 minutes
)efault ,ondition for Oracle #er7er
10 minutes
W$at%s Monitore 'Basis Tool(it ) Hig$-le"el* Purpose
BACKUPS ======= - Interation with SAP!" BRToo#" and SAP$BA %"in Tivo#i a" the &backint& %ti#ity - 'onitor" SAPARC( fi#e"y"te) and ca##" BRARC(I*+ when nece""ary - Sin#e "cri,t back%, of co),#ete SAP "y"te) $B ,#%" U.I fi#e"0
*o$
