Adding Targets and checking Database Performance in OEM 13.4
Tags: monitoring, tutorial, oem, oracle
Published: 2021-02-13 11:46:01

After my recent [OEM 13.4 Installation](https://project42.site/installing-oem-1…as-repository-db/) I needed to start adding targets to it.

Like previously, I just followed [Oracle-Base](https://oracle-base.com/) article to complete the same: [Oracle Enterprise Manager Cloud Control 13c Post-Installation Setup Tasks
](https://oracle-base.com/articles/13c/cloud-control-13c-post-installation-setup-tasks)

I added the Software Library location in the OEM host, but skipped the MOS configuration and Update, to go directly to add Agents and Targets

## Install Agents
Let's add Agents to a couple of our *raclab*, rac2-node1 and rac2-node2

To do that, just go to Configuration > Add Target > Add Targets Manually
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/y1n85z6pohlcg9tgfict.png)
</br>
Select Install Agent on host
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/1n6lb6vyldbaeugwujcu.png)
</br>
Add the hosts where you want the Agents installed, and make sure you add the host FQDN to avoid issues
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/8hlhlczad433ial7dy03.png)
</br>
Select Oracle and root credentials (you can also use SSH keys if you want to)
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/6sf6nfa40c0jw1668lpl.png)

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/13a5qjoq3zqx4fqw7he8.png)
</br>
Add now Agent Installation location details
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/p1lc3lhdiods8jovcq65.png)
</br>
Now just review the details and click in Deploy Agent
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/nhm0tjqqijivrrinn3pi.png)

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/1xn0jlfkb6occ8at407b.png)
</br>
You can also monitor the deplyomet checking the OEM *agentpush* logs:
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/0jbwqcig5nf00pck4yvu.png)
```bash
[oracle@oem13 ~]# cd /u01/app/oracle/gc_inst/em/EMGC_OMS1/sysman/agentpush/2021-01-29_13-29-58-PM/applogs/
[oracle@oem13 applogs]# ls -lrth
total 312K
-rw-r----- 1 oracle oinstall   0 Jan 29 13:36 ui.log.lck
-rw-r----- 1 oracle oinstall 39K Jan 29 13:44 ui.log
-rw-r----- 1 oracle oinstall 74K Jan 29 13:44 rac2-node1.raclab.local_deploy.log
-rw-r----- 1 oracle oinstall 74K Jan 29 13:45 rac2-node2.raclab.local_deploy.log
-rw-r----- 1 oracle oinstall 14K Jan 29 13:45 deployfwk.log
[oracle@oem13 applogs]# 

[oracle@oem13 ~]# tail -f /u01/app/oracle/gc_inst/em/EMGC_OMS1/sysman/agentpush/2021-01-29_13-29-58-PM/applogs/rac2-node2.raclab.local_deploy.log
2021-01-29_13-39-39:INFO:Install Args OMS_HOST=oem13
2021-01-29_13-39-39:INFO:Install Args EM_UPLOAD_PORT=4903
2021-01-29_13-39-39:INFO:Install Args AGENT_INSTANCE_HOME=/u01/app/oracle/product/agent13c/agent_inst
2021-01-29_13-39-39:INFO:Install Args b_doDiscovery=false
2021-01-29_13-39-39:INFO:Install Args START_AGENT=false
2021-01-29_13-39-39:INFO:Install Args b_forceInstCheck=true
2021-01-29_13-39-39:INFO:Install Args -force
2021-01-29_13-39-39:INFO:Install Args AGENT_PORT=3872
2021-01-29_13-39-39:INFO:Action description Execution of command /bin/sh -c 'cd /u01/app/oracle/product/agent13c/ADATMP_2021-01-29_13-29-58-PM;/u01/app/oracle/product/agent13c/ADATMP_2021-01-29_13-29-58-PM/agentDeploy.sh -ignorePrereqs ORACLE_HOSTNAME=rac2-node2.raclab.local AGENT_BASE_DIR=/u01/app/oracle/product/agent13c OMS_HOST=oem13 EM_UPLOAD_PORT=4903 AGENT_INSTANCE_HOME=/u01/app/oracle/product/agent13c/agent_inst b_doDiscovery=false START_AGENT=false b_forceInstCheck=true -force AGENT_PORT=3872'  on host rac2-node2.raclab.local
2021-01-29_13-39-39:INFO:Attempt :1 pty required false  with no inputs
```
</br>
After some time, you should get the Agent Deployment completed

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/mf8qa4caofm86etm8efo.png)

</br>
## Discover Targets on Host

Let's now add some Targets from the systems we added Agents to
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/c166xwdfqnrkwlf9mclv.png)
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/ciz2n9lrjhh42014six4.png)
</br>
Let's add the Cluster Components of our Rac2
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/ip57ucp2lw9ecdz3lqxd.png)
</br>
Fill the Cluster details making sure you have the right details for you GI home and Scan name and port
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/1hfqjp3th6sym1p4f24e.png)
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/4nqv90i3hc4b15j1mpru.png)
</br>
Let's now add a Cluster Database
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/fiqham2008qdvrlqjmon.png)
</br>
Make sure you complete all the details including ORacle Home path, service, etc.. 
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/yhwwi8zcyb35257tww18.png)
</br>
Add at least one instance adding the details for the DBSNMP user and connection details
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/oxunnjvcwjlmo3q5f2tz.png)
</br>
You can do a Test Connection to make sure is all fine
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/81yyjcca32jzqfploarz.png)
</br>
Review the details and Submit
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/6x30hh89ypr1gudlu805.png)
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/59mz9p0s8ggeo9k6xt6c.png)
</br>
We can now check the system from our Targets > Databases
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/lhww60opagjxzp6nvjtn.png)
</br>
## Database Performance

We can now check our System performance from the Target Performance Home (No Adobe Flash needed!!)

Select the Database and go to Performance > Performance Home.
You will get prompted to use Database login (you can use dbsnmp, but you can also use sys changing the role to "dba")

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/5kmtulec4zatsi2vpe0s.png)
![](https://project42.site/wp-content/uploads/2021/01/OEM_03_DB_Performance_03.png)
</br>
If we enable some workload using [Swingbench](http://dominicgiles.com/swingbench.html), we can see some nice Performance graphics
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/nytl8tdquvet0vr5845u.png)
</br>
You can also go to Performance Hub and see more detailed Performance details including Active Session History (ASH) analytics
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/tot2rkcvqb70d9df2leg.png)
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/uhxb5y50hsyug4jz9pxh.png)
</br>
There is much more about it than these simple tasks, but wanted to start from the beginning and see if I start to use OEM more regularly and can learn to do much more with it