Intro Post for Mubashir Khan Database and Linux Administrator with strong expertise in managing, optimizing, and securing enterprise IT environments. Skilled in Oracle, MySQL, and PostgreSQL administration, as well as …

Creating LVM In Oracle Linux   1. Ask the System Admin to add a raw disk into the Server   2. Check if the new RAW disk is available / …

How to redact a Column in a Table Object in Oracle Database 19c Important Considerations 1. Oracle Redaction use requires license for Oracle Advance Security for Oracle Database2. Identify the …

ORA-15041: Diskgroup “DATA” Space Exhausted — How to Diagnose & Fix the Issue When working in Oracle RAC/ASM environments, one of the common storage-related issues is ORA-15041: diskgroup space exhausted.This …

Oracle Home 19c Cloning   1. Check the groups assigned to the Oracle Home owner [oracle@test ~]$ . db.env[oracle@test ~]$ cd $ORACLE_HOME/rdbms/lib/[oracle@test lib]$ cat config.c |grep define/* SS_DBA_GRP defines the …

ADJRIINITPASSWD.sql ORA-01031 Error in Oracle E-Business Suite When running ADJRIINITPASSWD.sql, you may encounter an ORA-01031: insufficient privileges error. This typically occurs when Oracle EBS is unable to retrieve password information …

Troubleshooting Workflow Mailer Errors in Oracle E-Business Suite   The Workflow Mailer in Oracle E-Business Suite is a critical component for sending notifications and driving business processes. When it fails …

Oracle Optimizer: A Practical Guide For a Good Execution Plan    Have you ever seen a critical SQL query run lightning fast one day and unbelievably slow the next—without a …