STANDARD EM QUERY WITH SQL_ID dx4nqvbtu06bx IS VERY SLOW AND USES LOTS OF TEMPORARY SPACE
ISSUE The standard recurring query of the Enterprise Manager Cloud Control 13c Release 3 with sql_id dx4nqvbtu06bx is running slow and using huge amount of temporary tablespace while executing in a databases of the release 11.2.0.4. The query dx4nqvbtu06bx is executed every 15-20 minutes….
EM Event: Critical:oradb – Number of failed login attempts exceeds threshold value.
ISSUE Just got the “Number of failed login attempts exceeds threshold value” error from the Enterprise Manager Cloud Control 13c? And you aren’t sure what should you do? Bellow the solution using audit option. SYMPTOMS You received the following alert message from the…
HOW TO REPORT MEMORY USAGE PER A PROCESS ON LINUX
REQUEST I wish to know how many memory every process uses on a RedHat server. SOLUTION As all we know every process on a server allocates some amount of memory for itself to be able to function correctly. If a process fails…
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…
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…
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)