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 […]

With help of OEM cloud control, we can apply patch on multiple databases easily. No need to download the patch and copy that to the database server, OEM will download the patch if require and do the rest of patching activities. Below are the steps for applying patch using OEM Cloud control. ENTERPRISE – > […]

EMCLI – Enterprise Command Line Interface . Though Managing OEM cloud control from GUI is easy. Few people like to use emcli command line tool. Here i have listed few useful commands.   1. Login to syman ./emcli login -username=SYSMAN 2. SYNC OMS REPOSITORY: ./emcli login -username=SYSMAN ./emcli sync 3. Get THE LIST OF TARGETS […]

  Update_db_password command can be used to updates DBNSMP password of the target in the Enterprise Manager Credential sub-system and change the password on the target database as well. The command need to be run from OMS home. SYNTAX: emcli login -username=sysman -password= emcli update_db_password -target_name=”” -target_type=”oracle_database” -user_name=”dbsnmp” -change_at_target=yes -old_password=”” -new_password=”” -retype_new_password=”” For standalone database:(TESTDB) 1. […]

 We can upgrade an oracle database using OEM 12c cloud control also.  Here I will show how to upgrade database from 12.1.0.1 to 12.1.0.2 .  Note – Make sure that 12.1.0.2 ORACLE_HOME is installed.  SOURCE ORACLE_HOME(12.1.0.1) – /oracle/app/oracle/product/12.1.0 TARGET ORACLE_HOME(12.1.0.2)  – /oracle/app/oracle/product/12.1.0.2_CRM/dbhome_1   Enable Flashback: Before starting the upgrade, Enable flashback in the database, so […]

           Below are the steps for Deinstall/Decomission Management Agents in oracle 12c cloud control.   Shutdown the Agent: SETUP – > MANAGE CLOUD CONTROL -> AGENTS    Select the HOST and click on SHUT DOWN     Decommission Agent: Go to the Home page of the target host AGENT  – > […]

                             Once agents are deployed on target host, you can add the database and listeners  residing on the target host for monitoring by cloud control.   If you haven’t deployed Agents yet, click here First we need to configure Auto Discover the […]

  Before any planned outage on the target database or hot , we need to create blackout for that target, to avoid incident alerts. Blackouts allow Enterprise Manager Administrators to suspend all data collection activity.   ORACLE DATABASE – > MONITORING – > BLACKOUTS   Select the databases or services  which want to include in […]

                          Oracle Enterprise Manager Cloud control 12c Architecture Oracle enterprise Manager Cloud control 12c is used for managing and monitoring multiple oracle database and related targets from a single console.Although Enterprise Manager Cloud Control is viewed as single entity, It has below components. […]

     Below are the steps for changing the sysman password for oracle 12c cloud control. 1. update the passwordn using emctl config   syntax –  ./emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd <sys password>  -new_pwd < new sysman password>  oracle@bttstdev64:…ta/app/oracle/oms12cr5/oms/bin$ ./emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd oracle1234 -new_pwd oracle1234 Oracle Enterprise Manager Cloud Control 12c […]