Database Check Mailing
Use Database Check Mailing functionality to receive automatic email reports on OPERA database conditions including those that might indicate database problems or potential database problems. The Database Check Mailing screen allows you to configure the email settings for automatic distribution of database monitoring information. The Database Check Mailing screen is accessed via the Utilities>Utilities> Database Check Mailing menu option.
Provide the following information and select the OK button.
"From" E-mail Address. Enter the email address that will display as the sender of the Database Check emails.
"To" E-mail Address. Enter the email address where the Database Check emails are to be sent. Multiple email addresses can be entered if they are separated by a comma (,).
Server Name. The hostname or IP Address of the (email) SMTP server.
Server Port. The port number of the host on which the email server is running.
User ID. User ID to connect to the email server.
User Password. Password for the User ID to connect to the email server.
DB Memory Limit (MB). Email a list of database sessions that utilize database memory above the threshold set here. ( DB Memory Limit +10 MB = Warning status; DB Memory Limit +20 MB = Danger status.)
For example, assuming the DB Memory Limit is set to 40 MB, a Warning message is sent when DB memory reaches 50 MB and a Danger message is sent when DB memory reaches 60 MB. If the DB Memory Limit is set at 75 MB, a Warning message is sent when DB memory reaches 85 MB and a Danger message is sent when DB memory reaches 95 MB.
Log Results. Select this check box to email database alert log information. This information includes details on failed database jobs and on tablespace usage.
Note: The above reports on database sessions that exceed the set memory limit and on database alert log information will be emailed at the interval specified in the dba_checks.senddbinfo database procedure (the default is every 15 minutes), provided that there is information to report.
Send Daily Reports. Select the check box to automatically email a daily report containing database details such as the status of backup procedures, a list of properties maintained on the database, the OPERA version being run, etc. This report will be emailed for the first time when this check box is initially selected and every 24 hours thereafter.
List of Sessions Memory used over 3Mb
Warning Limit of 50Mb
Danger Limit of 60Mb
Terminal OPERA User Resort |
Machine |
Pga Memory Max(MB) |
Pga Memory (MB) |
Uga Memory (MB) |
Status |
Program |
Module Session ID |
FRIZZOXP.FT.MICROS.COM MWOLFGAMING CASINO |
FRIZZOXP |
30.163 mb |
18.163 mb |
11.513 mb |
OK |
frmweb.exe |
OF_NA BD:08/06/2007 435,1386 |
JOHNUTERA.FT.MICROS.COM SUPERVISOR ODH |
JOHNUTERA |
11.976 mb |
11.101 mb |
6.643 mb |
OK |
frmweb.exe |
OF_CHKOUT02 BD:02/28/2006 421,482 |
FRIZZOXP SUPERVISOR CASINO |
FRIZZOXP |
12.851 mb |
10.476 mb |
8.391 mb |
OK |
frmweb.exe |
OF_FCONFIG BD:08/06/2007 498,15125 |
PDHASXP.FT.MICROS.COM SUPERVISOR HAACK |
PDHASXP |
12.351 mb |
9.351 mb |
7.658 mb |
OK |
frmweb.exe |
OF_PMS BD:04/17/2009 492,872 |
ARAWATXP.FT.MICROS.COM SUPERVISOR ODH |
ARAWATXP |
9.726 mb |
8.726 mb |
6.081 mb |
OK |
frmweb.exe |
OF_FCONFIG BD:02/05/2006 489,36291 |
NPLPMSDB2 NPLPMSDB2 SYS |
NPLPMSDB2 |
8.304 mb |
8.304 mb |
0.149 mb |
OK |
ORACLE.EXE (P001) |
548,1 |
GISAKHANOVXP.FT.MICROS.COM SUPERVISOR ODH |
GISAKHANOVXP |
14.351 mb |
7.913 mb |
6.061 mb |
OK |
frmweb.exe |
OF_RQSCOP00 BD:02/05/2006 442,1115 |
GISAKHANOVXP.FT.MICROS.COM SUPERVISOR ODH |
GISAKHANOVXP |
11.038 mb |
7.351 mb |
6.392 mb |
OK |
frmweb.exe |
OF_RATE_CATEGORY_TEMPLATE BD:02/05/2006 454,2891 |
ABARRERA2.FT.MIC |
ABARRER |
8.288 |
7.28 |
5.64 |
OK |
frmweb. |
OF_MEM_MAINT
|
ROS.COM SUPERVISOR ODH |
A2 |
mb |
8 mb |
3 mb |
|
exe |
BD:02/05/2006 429,2217 |
SIVAXP.FT.MICROS.COM SUPERVISOR ODH |
SIVAXP |
10.163 mb |
6.288 mb |
5.393 mb |
OK |
frmweb.exe |
OF_OUTLOOKVIEW BD:04/17/2009 444,202 |
CROSEXP.FT.MICROS.COM CHARLES CRODH |
CROSEXP |
6.538 mb |
5.351 mb |
3.403 mb |
OK |
frmweb.exe |
OF_HELP BD:01/03/2009 503,1046 |
NPLPMSDB2 NPLPMSDB2 V46_PMSDEV |
NPLPMSDB2 |
26.804 mb |
5.117 mb |
0.884 mb |
OK |
ORACLE.EXE (J000) |
DBA_CHECKS.sendDBInfo 455,3481 |
AMITPXP.FT.MICROS.COM SUPERVISOR ODH |
AMITPXP |
6.038 mb |
4.726 mb |
3.958 mb |
OK |
frmweb.exe |
OF_RTSETUP BD:01/19/2008 509,7028 |
ANDREIXP.FT.MICROS.COM SUPERVISOR WORLD |
ANDREIXP |
5.038 mb |
4.726 mb |
3.396 mb |
OK |
frmweb.exe |
OF_RSSEARCH BD:11/16/2004 446,15844
|
SHIVAXP.FT.MICROS.COM SUPERVISOR ODH |
SHIVAXP |
6.976 mb |
4.726 mb |
4.145 mb |
OK |
frmweb.exe |
OF_FCONFIG BD:02/05/2006 471,36290 |
NPLPMSDB2 NPLPMSDB2 SYS |
NPLPMSDB2 |
7.742 mb |
4.679 mb |
0.087 mb |
OK |
ORACLE.EXE (LGWR) |
564,1 |
FRIZZOXP FTDEV\FRIZZOXP V46_PMSDEV |
FRIZZOXP |
33.367 mb |
4.554 mb |
3.208 mb |
OK |
plsqldev.exe |
PL/SQL Developer 501,20
|
DRAGISAXP2.FT.MICROS.COM SUPERVISOR ODH |
DRAGISAXP2 |
5.601 mb |
4.476 mb |
3.833 mb |
OK |
frmweb.exe |
OF_HOTEL_DELIVERY BD:02/05/2006 445,26228
|
BALAJI.FT.MICROS.COM SUPERVISOR ODH |
BALAJI |
4.226 mb |
4.101 mb |
2.966 mb |
OK |
frmweb.exe |
OF_SV_MAINTAIN BD:02/28/2006 430,258 |
JohnUtera |
|
6.804 mb |
3.804 mb |
2.709 mb |
OK |
|
OPERA Property Interface |
V46_IFCDEV |
|
|
|
|
|
|
448,3835 |
NPLPMSDB2 NPLPMSDB2 SYS |
NPLPMSDB2 |
|
3.554 mb |
|
OK |
ORACLE.EXE (J001) |
556,1224 |
dragisaxp2 V46_PMSDEV |
|
4.304 mb |
3.179 mb |
2.209 mb |
OK |
|
OPERA Property Interface 526,6 |
This report would only be sent out if there are any session that are exceeding the memory limit (in MB) configured under the db_memory_limit column in the SCHEDULED_JOBS_STATUS table. Default value for this is 40.
List of Sessions Memory used over 40Mb
Warning Limit of 50Mb
Danger Limit of 60Mb
Terminal |
Machine |
Pga Memory Max(MB) |
Pga Memory (MB) |
Uga Memory (MB) |
Status |
Program |
Module |
NPLSMOKEDB3 |
NPLSMOKEDB3 |
55.742 mb |
1.117 mb |
0.087 mb |
Warning |
ORACLE.EXE (J009) |
|
NPLOXIS11 |
NPLOXIS11 |
55.429 mb |
55.429 mb |
13.759 mb |
Warning |
mfQueueManager.exe |
WORLD/RATE/1607575 |
List of Broken Jobs or jobs that are failed or jobs with LOG_USER <> SCHEMA_USER
What |
Job# |
Log User |
Schema User |
Failures |
dba_checks.sendDBInfo; |
235824 |
V403_HOTEL1 |
V403_HOTEL1 |
1 |
FORECAST_PROCESSOR.PROCESS_EVENTS(215505); |
235961 |
SYS |
OPERA |
|
Subject: Database Health Check Report from smoke10-NPLSMOKEDB3@micros.com on NPLSMOKEDB3
Alert Log Errors
Thu Jul 27 08:19:36 2006
Errors in file g:\oracle\admin\pms10\udump\pms10_ora_39312.trc:
ORA-00600: internal error code, arguments: [kope2_readstr232], [1], [], [], [], [], [], []
Thu Jul 27 08:19:49 2006
Errors in file g:\oracle\admin\pms10\udump\pms10_ora_39312.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [__VInfreq__kope2pic+11335] [PC:0x60758D13] [ADDR:0x404] [UNABLE_TO_WRITE] []
Disk Space Report
Tablespace Name |
Size Mb |
% Used |
Status |
OPERA_DATA |
18284 |
92.27 |
Danger! |
SYSTEM |
4096 |
80.57 |
Danger! |
LOGINDX |
10092 |
75.70 |
Warning |
NAMEINDX |
4096 |
61.23 |
Warning |
FININDX |
4096 |
60.25 |
Warning |
Danger! Database is in NOARCHIVELOG mode!!!
Subject: Database Health Check Report from smoke10-NPLSMOKEDB3@micros.com on NPLSMOKEDB3
List of Sessions Memory used over 40Mb
Warning Limit of 50Mb
Danger Limit of 60Mb
Terminal |
Machine |
Pga Memory Max(MB) |
Pga Memory (MB) |
Uga Memory (MB) |
Status |
Program |
Module |
NPLSMOKEDB3 |
NPLSMOKEDB3 |
55.742 mb |
1.117 mb |
0.087 mb |
Warning |
ORACLE.EXE (J009) |
|
NPLOXIS11 |
NPLOXIS11 |
55.429 mb |
55.429 mb |
13.759 mb |
Warning |
mfQueueManager.exe |
WORLD/RATE/1607575 |
List of Broken Jobs or jobs that are failed or jobs with LOG_USER <> SCHEMA_USER
What |
Job# |
Log User |
Schema User |
Failures |
dba_checks.sendDBInfo; |
235824 |
V403_HOTEL1 |
V403_HOTEL1 |
1 |
FORECAST_PROCESSOR.PROCESS_EVENTS(215505); |
235961 |
SYS |
OPERA |
|
Alert Log Errors
Tue Jul 25 15:36:46 2006
Errors in file d:\oracle\admin\smoke10\bdump\smoke10_j005_2596.trc:
ORA-12012: error on auto execute of job 235824ORA-29284: file read errorORA-06512: at "SYS.UTL_FILE", line 98ORA-06512: at "SYS.UTL_FILE", line 656ORA-06512: at "V403_HOTEL1.DBA_CHECKS", line 978ORA-06512: at "V403_HOTEL1.DBA_CHECKS", line 1150ORA-06512: at line 1
Tue Jul 25 15:51:46 2006
Errors in file d:\oracle\admin\smoke10\bdump\smoke10_j006_2508.trc:
ORA-12012: error on auto execute of job 235824ORA-29284: file read errorORA-06512: at "SYS.UTL_FILE", line 98ORA-06512: at "SYS.UTL_FILE", line 656ORA-06512: at "V403_HOTEL1.DBA_CHECKS", line 978ORA-06512: at "V403_HOTEL1.DBA_CHECKS", line 1150ORA-06512: at line 1
RMAN Backup completed on 16-jun-06 00:37:33 with status COMPLETED
Danger! Database is in NOARCHIVELOG mode!!!
Database SGA Information
Name |
Bytes |
Total System Global Area |
1610612736 |
Fixed Size |
1292020 |
Variable Size |
805308684 |
Database Buffers |
796917760 |
Redo Buffers |
7094272 |
DB Version Information
Banner |
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod |
PL/SQL Release 10.2.0.2.0 - Production |
CORE 10.2.0.2.0 Production |
TNS for 32-bit Windows: Version 10.2.0.2.0 - Production |
NLSRTL Version 10.2.0.2.0 - Production |
OPERA Version Information
Application |
Version |
OPERA PMS |
4.0.03.01 - |
OPERA SC |
4.0.03.01 - |
OPERA EIS |
4.0.03.01 - |
OPERA QMS |
4.0.03.01 - |
OPERA ORS |
4.0.03.01 - |
OPERA OXI |
4.0.03.01 - |
OPERA WSS |
4.0.03.01 - |
OPERA OIS |
4.0.03.01 - |
OPERA OPC |
4.0.03.01 - |
OPERA IFC |
4.0.03.01 - |
OPERA SFA |
4.0.03.01 - |
OPERA GDS |
4.0.03.01 - |
OPERA ADS |
4.0.03.01 - |
OPERA VOS |
4.0.03.01 - |
OPERA ODR |
4.0.03.01 - |
List of Properties and their Business Dates
Resort |
Date |
Status |
ODH |
07-NOV-2003 |
Warning |
See Also