HOW TO FIND WHO AND WHAT SQL IS USING TEMP TABLESPACE?
REQUEST I need details about what exactly is using the space in a Temporary Tablespace. SOLUTION With the TEMP_USAGE view you can point out which a user, a session or a sql_id is currently using your temp space. CREATE OR REPLACE…
Enterprise Manager 13C Cloud control Authentication Fails: The User Name or Password is invalid
ISSUE Accessing Enterprise Manager Cloud Control 13c from the authentication page with a correct username and password fails with the following error – “The User Name or Password is invalid.” SYMPTOMS SOLUTION The one of the reason of the issue is…
NWBACKUP.sh – A free script to perform a full or incremental backup of a directory to a NetWorker Pool
The nwbackup.sh is the bash script that uses the save and the mminfo command of the lgto* packages. To be able to use the script you must install both the lgtoxtdclnt and lgtoxtdclnt packages. [root@dbpilot.net ~]# rpm -qa |egrep “lgtoclnt|lgtoxtdclnt” lgtoxtdclnt-19.1.0.3-1 lgtoclnt-19.1.0.3-1 Also, At the…
OEM Agent has “COLLECTIONS_HALTED” status
ISSUE emctl status agent‘s output shows that an agent is “Running and Ready” but its collection status is [COLLECTIONS_HALTED(UPLOAD SYSTEM Threshold – unable to purge files in upload system)] SYMPTOMS oracle@dbpilot|09:23|~/scripts:emctl status agent Oracle Enterprise Manager Cloud Control 12c Release 5 Copyright…
ADF_FACES-60097: FOR MORE INFORMATION, PLEASE SEE THE SERVER’S ERROR LOG
ISSUE After a 12.1.0.5.0 agent was successfully installed on a target host and a database was discovered in Enterprise Manager the selecting a Database Target link in Enterprise Manager 13c Release 3 Cloud Control Results in Errors. It’s very likely the other versions…
REMOVING AN AGENT DIRECTLY FROM AN OEM DATABASE
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…
3 WAYS TO RUN iptables -L AS NON ROOT USER
ISSUE When I try to list all iptables rules as non-root user I get the following error [maxpatrol@rhel75 ~]$ iptables -vnL iptables v1.4.21: can’t initialize iptables table `filter’: Permission denied (you must be root) Perhaps iptables or your kernel needs to be upgraded. …
RUNNING IPTABLES TOOL AS A NON-ROOT USER
REQUEST Listing iptables rules without being root user, without providing a sudo password, without setting SUID on the iptables executiable, without using sudo keyword. RELATED SOLUTION In this example, the user maxpatrol is being used. First, you should back up your sudoers…
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:…
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)