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.

The post Generate custom report from OEM cloud control appeared first on DBACLASS.

Below are the steps for applying patch using OEM Cloud control.

ENTERPRISE – > PATCHES & UPDATES -> RECOMMENDED PATCH

Select the respective platform and database.

Select the Patch which you are planning to apply

Create the patch plan:

Give a new to the PATCH PLAN:

Select the database targets. You can select multiple databases at a time.

This is screen is very important.

There are two types of patching mode.

– Out of place – In this option, A new Oracle binary will be created and the patch will be applied on top of that. And database will started from the new Oracle home. This is recommended method, because, it reduced DB downtime and also during patching to binary if some issue happens, then also the old ORACLE_HOME is intact.

– In place – Here the database and listeners running from that home will be shut down , Then patch will be applied to that ORACLE_HOME, once done database will be started with post patch.

Here I have selected In place.

Set the ORACLE_HOME credentials , If not then use override and set the database server host username and password.

Now run the validation, to check the conflicts. This validation shouldn’t show any errors.

Now the validation is successful, Now go for DEPLOYMENT.

With this patching has been completed. Now you can log in to the database and check the patch registry.

SQL> SET LINES 200
SQL> select patch_Id,status,description from dba_registry_sqlpatch;

  PATCH_ID STATUS          DESCRIPTION
---------- --------------- -------------------------------------------------------------------------------------------------
  24917972 SUCCESS         Database PSU 12.1.0.2.170117, Oracle JavaVM Component (JAN2017)
  24732082 SUCCESS         DATABASE PATCH SET UPDATE 12.1.0.2.170117

The post Apply database patch from OEM Cloud control appeared first on DBACLASS.

cd $OMS_HOME/bin

Stopping OMS:

 oracle@test:…ta/app/oracle/oms12cr5/oms/bin$ ./emctl stop oms

Oracle Enterprise Manager Cloud Control 12c Release 5

Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved. Stopping WebTier...

WebTier Successfully Stopped Stopping Oracle Management Server...

Oracle Management Server Successfully Stopped
Oracle Management Server is Down

Starting OMS:

 
oracle@test:…ta/app/oracle/oms12cr5/oms/bin$ ./emctl start oms

Oracle Enterprise Manager Cloud Control 12c Release 5

Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved. Starting Oracle Management Server...

Starting WebTier...
WebTier Successfully Started

Oracle Management Server Successfully Started
Oracle Management Server is Up

Checking the OMS status:

oracle@test:…ta/app/oracle/oms12cr5/oms/bin$ ./emctl status oms

Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation.	All rights reserved.
WebTier is Up
Oracle Management Server is Up

The post How to restart OMS in oracle 12c cloud appeared first on DBACLASS.