- Introduction: In this article, we will see how to add or configure target in the OEM on Linux environment step by step.
- Prerequisites: Below are the minimum requirements for Linux environment:
- Connectivity between OEM & Target server.
- Must add target Hostname/IP entry in OEM "/etc/hosts" file and vice-versa.
- Minimum 5GB free disk space on target machine.
- Must have root user or sudo access of target machine.
- Disable the firewall. OR allow ports such as 1521, 3872 between OEM & target machine.
- Environment:
- Approach: We will first add target host in OEM and then we will add targets (Database,Listener) in that host.
- Now let's proceed to add the target host in OEM step by step:
| Hostname | oem.oraeasy.com |
|---|---|
| OS | OL 7.3 |
| OEM Version | 13c Release 5 (13.5) |
| OMS Home | /oem/app/oracle/middleware |
| Agent Base | /oem/app/oracle/agent |
| Hostname | uat.oraeasy.com |
|---|---|
| OS | OL 8.5 |
| Database Name | ORCLDB |
| Database Version | 19c (19.27) |
| Oracle Home | /u01/app/oracle/product/19c/db_home |
1. First we need to verify that the database serives are runnning on target. Also create required directories for agent on target.
SQL> select name,open_mode,database_role,log_mode from v$database;
NAME OPEN_MODE DATABASE_ROLE LOG_MODE
--------- -------------------- ---------------- ------------
ORCLDB READ WRITE PRIMARY ARCHIVELOG
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE NO
[oracle@uat ~]$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-SEP-2025 20:15:42
Copyright (c) 1991, 2025, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=uat.oraeasy.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 06-SEP-2025 20:15:04
Uptime 0 days 1 hr. 10 min. 40 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19c/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/uat/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=uat.oraeasy.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "3d7f7aee5db8a4eee0650a00273ebb20" has 1 instance(s).
Instance "orcldb", status READY, has 1 handler(s) for this service...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
Instance "orcldb", status READY, has 1 handler(s) for this service...
Service "orcldb" has 1 instance(s).
Instance "orcldb", status READY, has 1 handler(s) for this service...
Service "orcldbXDB" has 1 instance(s).
Instance "orcldb", status READY, has 1 handler(s) for this service...
Service "orclpdb" has 1 instance(s).
Instance "orcldb", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@uat ~]$
[oracle@uat ~]$ mkdir -p /u01/app/oracle/agent
[oracle@uat ~]$ mkdir -p /u01/app/oracle/agent_inst
Click on Setup -> Add Target -> Add Targets
In Add Host Target, click on Install Agent on Host.
Click On Add. Then provide the target Hostname & its platform and click Next.
Provide Base & Instance directory. Also click on + sign against Credential and add credential details for Oracle & Root user as shown in following snips.
For Oracle user.
For Root user.
Click Next.
Review and click Deploy Agent.
Monitor the progress.
Now Agent has been successfully deployed.
3. Now we need to add targets like Database & Listener in that host. So for this follow below:
Click on Setup -> Add Target -> Add Targets, then click on Add Using Guided Process
In the Guided Discovery, type & select Database, Listener ..etc. Then click Add.
Click on search icon to add host.
Click on the hostname and then click Select.
Click Next.
Target discovery in progress.
Check for the database. Also provide the crdential for "DBSNMP" user & click Test Connection.
Reset the DBSNMP user password if required.
SQL> select username,account_status from dba_users where username='DBSNMP';
USERNAME ACCOUNT_STATUS
-------------------- ----------------
DBSNMP LOCKED
SQL>
SQL> alter user DBSNMP identified by Dbsnmp_123 account unlock;
User altered.
SQL> select username,account_status from dba_users where username='DBSNMP';
USERNAME ACCOUNT_STATUS
-------------------- -----------------
DBSNMP OPEN
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------ - ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE NO
SQL> alter session set container=ORCLPDB;
Session altered.
SQL> select username,account_status from dba_users where username='DBSNMP';
USERNAME ACCOUNT_STATUS
-------------------- -----------------
DBSNMP OPEN
Test connection is successfull.
Now select for Listener & click Next.
Reveiw the details & click Save.
Target saving in progress.
Targets have been saved successfully. Click Close.
4. We can view the added targets via navigating the Targets menu. Follow below
Click on Targets -> Host. Then click on the host you want to view.
You can view target host details like CPU or Memory.
Similarly you can view the database. Click on Targets -> Database. Then click on the database you want to view.
Here you can view the details like Active Sessions.
By this way, we have added target host and its related services. We will be doing more activities with OEM in further artilcles. Stay connected!!
Thank you for reading!
I hope this content has been helpful to you. Your feedback and suggestions are always welcome — feel free to leave a comment or reach out with any queries.
Abhishek Shrivastava
Comments
Post a Comment