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 […]
Found 1 new persistent data failures – Cloud Control Event/error
Enterprise Manager / Cloud Control 13c raised this event: EM Event: Critical:my-db.oracle-scripts.net – Checker run found 1 new persistent data failures. By default the database runs the Health Check periodically to find: File corruptions, Physical and logical block corruptions, Undo or redo corruptions, data dictionary corruptions If any failures are detected then a message […]