HOW TO DISABLE CPU UTILIZATION (%), MEMORY UTILIZATION (%) AND SWAP UTILIZATION (%) METRICS IN ENTERPRISE MANAGER CLOUD CONTROL (12c, 13c)
ISSUE Enterprise Manager Cloud Control sends me hundreds of emails per day with Memory Utilization warnings. A message looks like: Host=dbpilot.net Target type=Host Target name=dbpilot.net Categories=Capacity Message=Memory Utilization is 95.145%, crossed warning (80) or critical (95) threshold. Severity=Critical Event reported time=Jul 24, 2018 8:21:22…
THE AGENT IS BLOCKED BY THE OMS. AGENT IS OUT-OF-SYNC WITH REPOSITORY
ISSUE When an agent is requested to upload collected metric data the following error appears. [oracle@dbpilot ~] emctl upload agent Oracle Enterprise Manager Cloud Control 13c Release 1 Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved. ————————————————————— EMD upload error:full upload has failed:…
DEINSTALLING THE AGENT THAT WAS INSTALLED THROUGH ENTERPISE MANAGER CLOUD CONTROL CONSOLE
REQUEST The Enterprise Manager Cloud Control Agent must be uninstalled from the target host completely. The agent was installed through the “Add Targets Manually” option in Enterprise Manager Cloud Control Console. SOLUTION 1. Locate the Central Inventory by reviewing the Central Inventory Pointer…
A 13c AGENT DEPLOYMENT PROCESS CRASHES ON REDHAT/OEL 7.X TARGET HOSTS
REQUEST When trying to deploy a 13c agent on the RedHat 7.x or OEL 7.x hosts the deployment process crashes. It crashes both by installing through “Add Targets Manually” option in the OEM console and through .rpm package installation. RELATED A 13c AGENT…
A 13c AGENT DEPLOYMENT ERROR : THE USER “ORACLE” DOES NOT HAVE THE PRIVILEGES TO RUN COMMANDS AS USER “ROOT”
ISSUE The remote prerequisite check fails during a 13c agent deployment process in Enterprise Manager Cloud Control 13c Console. RELATED A 13c AGENT DEPLOYMENT PROCESS CRASHES ON REDHAT/OEL 7.X TARGET HOSTS A 13c AGENT DEPLOYMENT ERROR : THE “VISIBLEPW” IS NOT SET THE…
A 13c AGENT DEPLOYMENT ERROR : THE “VISIBLEPW” IS NOT SET THE SUDOERS FILE
ISSUE The remote prerequisite check fails during a 13c agent deployment process in Enterprise Manager Cloud Control 13c Console. RELATED A 13c AGENT DEPLOYMENT PROCESS CRASHES ON REDHAT/OEL 7.X TARGET HOSTS A 13c AGENT DEPLOYMENT ERROR : THE USER “ORACLE” DOES NOT HAVE…
OUR SYSTEM HAS DETECTED THAT THIS MESSAGE DOES NOT MEET IPV6 [GMAIL]
ISSUE When an email is sent from the server to a Gmail account it fails to deliver. The postfix is used as Mail Transfer Agent to deliver emails. SYMPTOMS In the /var/log/maillog the following error appears [root@dbpilot ~]# cat /var/log/maillog Apr 17 10:41:38…
ORA-01031 WHEN CONNECTING TO ORACLE 12C WITH TOAD 11.6
ISSUE A user cannot connect to Oracle Database 12c with Toad. He gets ORA-01031: insufficient privileges every time when attempting to connect. REASON In 12c release an access to SYS.USER$ table has been restricted. SOLUTION The issue only related to TOAD of…
RECLAIMING WASTED SPACE IN A SEGMENT
QUESTIONS How to reduce the size of a segment? How to run the Segment Advisor manually with a PL/SQL package for a specific segment? How to perform an online segment shrink? SOLUTION Run Segment Advisor against a segment and review results in dba_advisor_*…
FIXING DispatchingTaskScheduler:1071
REQUEST 13c agents generates many DispatchingTaskScheduler alerts. I want to stop them to be generated. SYMPTOMS Host=dbpilot.net Target type=Agent Target name=dbpilot.net:3872 Categories=Diagnostics Message=Internal error detected: java.lang.Throwable: oracle.sysman.gcagent.task.scheduler.DispatchingTaskScheduler:1071. Severity=Critical Event reported time=Feb 12, 2018 7:43:23 AM MSK Customer Support Identifier=10000001 Operating System=Linux Platform=x86_64 Associated…
Categories
- Linux (8)
- Iptables (2)
- Memory Usage (1)
- Postfix (1)
- Yum (4)
- Networker (2)
- Oracle (65)
- Account (2)
- AWR (2)
- Database Errors (6)
- Database Performance (9)
- Datapump (4)
- 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)
- Tablespaces (1)
- Temporary Tablespace (2)