DBA Hub

📋Steps in this guide1/5

Generate custom report from OEM cloud control DBACLASS

Generate custom report from OEM cloud control 12c /13c. Go to REPORT -> Information Publisher Report , Click create and, Follow easy steps to generate repor

oracle monitoringintermediate
by OracleDba
15 views
1

Overview

REPORTING module can be used in oem cloud control to generate custom reports like , database status report of all target databases. Repository database contains all the target details and metric information . So best way is to run query against the repository database. Here we have provided steps for generating database consolidation report ENTERPRISE -> REPORT -> INFORMATION PUBLISHER REPORT Click on CREATE:
Step 1
2

Section 2

ON GENERAL TAB: CATEGORY – Compliance SUBCATEGORY – Database Targets
3

Section 3

TARGETS –   Select the repository database PRIVILEGES – Run with SYSMAN privilege ELEMENTS TAB:
Step 3
4

Section 4

Select ADD : SELECT TABLE FROM SQL: Here paste the sql query, COMPLETE QUERY:
Step 4
5

Section 5

This query you can customize as per your requirement: Now schedule it: You can preview the report also. Once the preview is fine, you can save it. HTML formatted report will be sent the the mentioned email addresses.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
SELECT A.HOST_NAME,
        A.DATABASE_NAME,
		TO_CHAR(A.STARTUP_TIME,'DD-MON-YYYY') "STARTUP_DATE" ,
        TO_CHAR(A.creation_date,'DD-MON-YYYY') "CREATION_DATE",
        A.LOG_MODE,A.CHARACTERSET,A.DBVERSION,
        AVAILABILITY_STATUS,E.SGASIZE,
		G.HOME_LOCATION "ORACLE_HOME",
		F.property_value "PORT",
		C.cpu_count,
		C.CPU_CORE_COUNT,
		SUBSTR(D.OS_SUMMARY,1,40) "OS PLATFORM" 
		FROM  SYSMAN.MGMT$DB_DBNINSTANCEINFO A, 
				SYSMAN.MGMT$AVAILABILITY_CURRENT B,
				SYSMAN.MGMT$DB_CPU_USAGE C ,  
				sysman.mgmt$os_hw_summary D,
				sysman.mgmt$db_sga_all E ,
				SYSMAN.MGMT$TARGET_PROPERTIES F  , 
				SYSMAN.MGMT$ORACLE_SW_ENT_TARGETS G 
	WHERE B.TARGET_TYPE='oracle_database' and
	A.TARGET_NAME=B.TARGET_NAME AND
	A.TARGET_NAME=C.TARGET_NAME AND 
	A.HOST_NAME=D.HOST_NAME and 
	a.target_name=E.target_name  AND 
	E.SGANAME='Total SGA (MB)'  AND
   A.TARGET_NAME=F.TARGET_NAME AND
   a.target_name=G.TARGET_NAME and  
   F.PROPERTY_NAME='Port' 
ORDER BY host_name desc;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!