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:

 

ON GENERAL TAB:

CATEGORY - Compliance

SUBCATEGORY - Database Targets

TARGETS -   Select the repository database

PRIVILEGES - Run with SYSMAN privilege

ELEMENTS TAB:

Select ADD :

SELECT TABLE FROM SQL:


 

Here paste the sql query,

COMPLETE QUERY:

 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;

 

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.

cloudCLOUD CONTROLOEM CLOUD


Related Topics

Upgrade database using OEM 12C cloud control
How to change sysman password for oracle 12c cloud control
Change dbsnmp password for target db in oem 12c
Add database as target oracle 12c cloud control
EMCLI command - OEM 12C
Apply database patch from OEM Cloud control
Deinstall Management Agents Oracle 12c cloud control
Generate custom report from OEM cloud control
Install oracle enterprise manager cloud control 12c
Blackout targets in OEM 12c cloud control

You May Also Like

WHAT IS SQL PROFILE IN ORACLE
Shell script to monitor lag in standby datbase using dgmgrl
Tablespace monitoring shell script
How to Downgrade oracle 19C Grid to 12C GRID
Hive Installation with derby
How to multiplex control file in standalone database
How to install postgres database on mac os/linux
Open wallet automatically after starting the database
oraversion utility in oracle 18c - New feature
Exception in thread -main" java.lang.OutOfMemoryError: GC overhead limit exceeded with bsu.sh

From This Website

Setting up Table replication in oracle goldengate
How to flashback a RAC database
Ansible script to run script on remote server and fetch the output
Display sql_id of the sql, using set feedback in oracle 18C - New feature
SKIP_CONSTRAINT_ERRORS as DATA_OPTION in impdp
ERROR: No checkpoint table specified for ADD REPLICAT
Useful flashback related commands
Get sid from ospid
Perform Flashback in pluggable database(PDB) in oracle 12.2
Oswatcher tool for collecting server diagnostic information