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 […]
Generate user DDL with dbms_metadata.get_ddl user
Download Brave : Secure, Fast & Private Browser with Adblocker The oracle DBA can use these 2 scripts to generate DDL statements for a user with their roles, system and object privileges. For Oracle 18c / 12c / 11g / 10g: clear screen accept uname prompt ‘Enter User Name : ‘ accept outfile prompt ‘ […]