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