REMOVING AN AGENT DIRECTLY FROM AN OEM DATABASE
Enterprise Manager
0
ISSUE
An OEM 12c agent was removed from a monitored host but it’s still displayed in the Targets menu of Enterprise Manager Cloud Control 12c console. Despite it was removed completely from a host (stopped and removed) his target status is UP.

The Agent Decommission option does not work in this case and it raises the error if you try to perform this operation
Agent must be in down status for Decommission. Please bring down the agent and wait for the status to become down and retry.
SOLUTION
Issue the following SQL statement against an Oracle Enterprise Manager Cloud Control database to remove the agent from OMS
SQL> exec sysman.mgmt_admin.cleanup_agent('dbpilot.net:3872');
PL/SQL procedure successfully completed.
Confirm that it was successfully decommissioned and the Oracle Enterprise Manager console does not display the removed agent
Version : 05:01 PM 23.02.2019
Platform : Red Hat 6.6
OEM : 12.1.0.4.0
Platform : Red Hat 6.6
OEM : 12.1.0.4.0
Tags In
Related Posts
Leave a Reply Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Categories
- Linux (8)
- Iptables (2)
- Memory Usage (1)
- Postfix (1)
- Yum (4)
- Networker (2)
- Oracle (63)
- Account (2)
- AWR (2)
- Database Errors (6)
- Database Performance (9)
- Datapump (3)
- Enterprise Manager (24)
- Enterprise Manager Metrics (4)
- Environments (4)
- High CPU Usage (2)
- High IO Load (4)
- Initialization Parameters (5)
- job_queue_processes (1)
- Processes (3)
- NLS (1)
- Objects (1)
- Objects DDL (2)
- OJVM/PSU/DRU Patches (1)
- PL/SQL (5)
- UTL_FILE (4)
- Prerequisites (1)
- Privileges (1)
- Profile (1)
- Queries (2)
- Redologs (1)
- Resource Limits (1)
- Segment Shrink (1)
- Session (6)
- Spfile (3)
- SQL PLUS (1)
- Spooling (1)
- Standard Queries (7)
- Statistics (2)
- Temporary Tablespace (2)
Tags
/etc/sudoers
Account
Agent
Agent 12c Deinstall
Agent 13c Deployment
Automated Maintenance Tasks
AWR
BLOCKING SESSION
Database Auditing
Database Directory
Database Performance
Datapump
DBMS_SYSTEM
Enterprise Manager
Enterprise Manager Metrics
Failed Logins (Historical) Metric
Failed Logins Metric
Gather Statistics Job
GET_ENV
High IO Load
Idle Sessions
Initialization Parameters
LOCKED(TIMED)
OEM
OEM 12.1.0.4
OEM 13.1.0.0.0
OMS
Processes
Repository
Retrieve Object DDL
ROW LOCK
Scheduler
Schema Statistics
Scripts
Sessions
spfile
SQL_ID
Standard Query
TRANSACTION
User Grants
UTL_FILE
WAITING SESSION
Window Group
Window Name
Yum