previous

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.

Database Check Mailing Screen

Database

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 (,).

SMTP Server Configuration

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.

Report Details

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.

Sample Reports

horizontal rule

Database Session memory Usage

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

Sample Output From 15 Min Report

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
OPERA User
Resort

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

 

horizontal rule

Sample Output From 1 Hour Report

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!!!

horizontal rule

Sample Output From 24 Hour Report

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
OPERA User
Resort

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


horizontal rule

Report Backup Information

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

horizontal rule

See Also