This post is about the commands which is used by Oracle DBA during using OEM 12c.

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

2. SYNC OMS REPOSITORY:

3. Get THE LIST OF TARGETS

For listing only the oracle_database

4. Delete a target from OEM cloud control:

5. Run autodiscovery on a target host

You can configure autodiscover from GUI also, after a target host is added. Below is for doing using EMCLI

Create a property file:

Update the property file:( It will look as below)

Create a job:

Get the job status:

Alternatively we can see the execution detail as :

6 . Add target database to OEM cloud:

SYNTAX:

7. Get list of plugins installed on OMS server:

OMS name is dbadev64.dba.com.sa:4889_Management_Service
Plug-in Name Plugin-id Version [revision]

Oracle Audit Vault oracle.em.soav 12.1.0.4.0
Oracle GoldenGate oracle.fmw.gg 13.1.1.0.0
Oracle Cloud Framework oracle.sysman.cfw 13.2.1.0.0
Oracle Database oracle.sysman.db 13.2.1.0.0
Oracle Fusion Middleware oracle.sysman.emas 13.2.1.0.0
Oracle Fusion Applications oracle.sysman.emfa 13.2.1.0.0
Oracle Siebel oracle.sysman.empa 13.1.1.0.0
Oracle ORAchk Healthchecks oracle.sysman.orhc 13.1.1.0.0
Systems Infrastructure oracle.sysman.si 13.2.1.0.0
Oracle Exadata oracle.sysman.xa 13.2.1.0.0

8 . Get list of plugins installed on a Management Agent:

9 . Create BLACKOUT:

Creating blackout for single database

For multiple databases:
DB NAME – DBATEST1,DBATEST2

Create blackout for a host(target agent) and all this services/database runnin on that server

TARGET AGENT HOST – localhost.dbaclass.com
DURATIO – 30 MIN
START IMMEDIATELY

Get status of a blackout:

SYNTAX

EXAMPLE:

Stop a BLACKOUT:

Delete a blackout:

10 . Decommission an agent and delete the respective targets:

11. Stop and start an agent from OMS server

STOP AN AGENT:

START AN AGENT:

12. Change password for dbsnmp user of target database

This will prompt for old password and new password.

Execute “emcli get_jobs -job_id=50A66C2EF0EB6E7AE0540010E01F328C” to check the status of the job.
Search for job name “CHANGE_PWD_JOB_1496046676449” on the Jobs home page to check job execution details.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Anuradha’s LinkedIn: https://www.linkedin.com/in/dbaanuradhamudgal/

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply