Oracle DBA Role Explained
Before diving into memory, storage, or processes, it’s important to understand what an Oracle DBA really does. This gives you a mental model so…
CATEGORY
Database
Master SQL, PostgreSQL, MySQL, MongoDB, and trending open-source databases. Learn optimization, design patterns, and best practices for modern data management.
323 articles
Automate ORACLE_HOME and Oracle Inventory Backup (with One-Click Restore) Before Patching
Patching Oracle? Smart move — but never patch without a full backup of ORACLE_HOME and Oracle Inventory. If anything breaks during patching, you’ll need…
How to Backup Oracle oratab, .bash_profile, and Environment Variables
Before performing system-level or Oracle patching activities, it’s a best practice to back up not only your Oracle binaries and inventory but also critical…
How to Backup and Restore ORACLE_HOME Binaries and Oracle Inventory Before Patching
Backing up your Oracle software environment — including the software binaries (ORACLE_HOME) and inventory metadata (oraInventory) — is a critical safety step before applying…
Why Fast Queries Suddenly Slow Down — And What Causes Execution Plan Changes in Oracle
Have you ever run a SQL query that used to be lightning-fast… and now it crawls? The likely culprit? The Execution Plan Changed. As…
How to Open the Standby Database When the Primary Is Lost
In critical scenarios where the Primary Oracle Database is lost or unrecoverable, and only the Standby Database remains, we must convert the standby into…
How to Perform Tablespace-Level Export/Import Between Two Oracle Databases
🔹 Step 1: Create OS-Level Directories (Source & Target) On Source Server (192.168.10.165) sudo mkdir -p /u02/dpdump/practicesudo chown oracle:oinstall /u02/dpdump/practicesudo chmod 777 /u02/dpdump/practice On…
How to Perform Tablespace-Level Export/Import Within the Same Oracle Database
Migrating a tablespace within the same Oracle DB instance can be useful for backup testing, development scenarios, or cloning environments. This step-by-step guide covers…
Test Network Latency Using ping -c 900 Command
The ping command is a go-to tool for checking network connectivity. When combined with the -c option, it becomes a great way to monitor…
Purge Unified Audit Trail in Oracle to Free Up SYSAUX Space
Oracle’s unified audit trail can silently consume significant space in the SYSAUX tablespace, especially when audit logs aren’t purged regularly. If you’re noticing SYSAUX…
Oracle DB Shutdown Steps on Linux
Manually shutting down an Oracle database on Linux is a critical task for DBAs, often required during maintenance, patching, or system reboots. This guide…
Top Network Ports Every IT Pro Should Remember
Network ports are like digital doorways used by applications to communicate over the internet or internal networks. Whether you’re managing servers, troubleshooting issues, or…