The Oracle DBA wants to run Health Checks command with Health Monitor upon his database. With Oracle 12c/18c, these checks can be done on a regular basis daily/monthly: – DB Structure Integrity Check – CF Block Integrity Check – Data Block Integrity Check – Redo Integrity Check – Transaction Integrity Check – Undo Segment Integrity […]
How to Kill a datapump job and cleanup orphaned jobs in Oracle
Download Brave : Secure, Fast & Private Browser with Adblocker In this article you will learn how to: Kill a datapump job from dba_datapump_jobs using expdp or with an internal package Cleanup orphaned datapump jobs in Oracle Perhaps you were looking for stop/drop job in DBMS_SCHEDULER. How to kill a datapump job in DBA_DATAPUMP_JOBS? You […]
Lock, expire and delete Linux account
Sometimes the Oracle DBA has to I delete a Unix user account under Linux operating systems including the home directory. How do I expire, delete or remove a user’s access from my server? Deleting user account in Linux is an administrative task to remove user login credentials from system configuration files such as /etc/passwd, /etc/shadow […]
Unable to create audit trail file or Read-only file system
This morning, the Cloud Control and other applications are down. Hard for the customer :( but as an Oracle DBA I love problems in production so it’s a great day today! First, I tried to edit a file with vi but a swap error raised: “E297: Write error in swap file“ Another read-only error with […]
DATA GUARD TROUBLESHOOTING
Download Brave : Secure, Fast & Private Browser with Adblocker This post provides help troubleshooting a standby database (dataguard). This article covers the following problems: Troubleshooting Log transport services Troubleshooting Redo Apply services Troubleshooting SQL Apply services Common Problems Log File Destination Failures Handling Logical Standby Database Failures Problems Switching Over to a Standby Database […]