ENABLING DEAD CONNECTION DETECTION(DCD) IN AN ORACLE DATABASE
GOAL All abnormally terminated sessions between a database server and a client must be disconnected automatically SOLUTION Dead Connection Detection (DCD) is intended primarily for environments in which clients power down their systems or client machines crash unexpectedly without disconnecting from Oracle Database sessions….
WHY MY DATABASE HAS SO MANY PROCESSES CONNECTED
GOAL An instance has reached the maximum number of processes. I want to know why I have so many and if there is any to be disconnected safely. SYMPTOMS The following query shows that my instance has almost reached the number of permited processes. SET…
EM Event: Warning:ORCL_dbpilot.net – Metrics Process Limit % is at 98
SYMPTOMS Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0.0) sends you emails like the EM Event: Warning:ORCL_dbpilot.net – Metrics Process Limit % is at 98 with the following error messages Host=dbpilot.net Target type=Database Instance Target name=ORCL_dbpilot.net Categories=Capacity Message=Metrics Process Limit % is at…
ORA-31671: Worker process DW00 had an unhandled exception.
ISSUE During a datapump import you got the error like the following impdp system/password schemas=XXCDB NETWORK_LINK=PROD_SYSTEM DIRECTORY=DROPZONE LOGFILE=your_logfile.log … Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS ORA-39014: One or more workers have prematurely exited. ORA-39029: worker 1 with process name “DW00” prematurely terminated ORA-31671: Worker process DW00…
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…
Categories
- Linux (8)
- Iptables (2)
- Memory Usage (1)
- Postfix (1)
- Yum (4)
- Networker (2)
- Oracle (69)
- Account (2)
- AWR (4)
- Database Errors (7)
- Database Performance (10)
- Datapump (4)
- Enterprise Manager (25)
- Enterprise Manager Metrics (4)
- Environments (4)
- High CPU Usage (3)
- High IO Load (4)
- Historical Session Information (3)
- 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)