Configuring Oracle Data Guard Broker for High Availability   How I recently standardized an existing Primary/Standby setup using Broker (DGMGRL) for simpler HA operations. In one of my recent HA/DR …

Check Directories ==================   SQL> desc DBA_DIRECTORIES;   SQL> select * from dba_directories where directory_name=’DATA_PUMP_DIR’;   =================================================================== Change datapump directory ===================================================================   SQL> CREATE OR REPLACE DIRECTORY “DATA_PUMP_DIR” as ‘/app/oracle/product/11.2.0/dbhome_1/rdbms/log/’; …

Copy Password File From Primary to Standby ASM        If you’ve worked with Oracle Real Application Clusters (RAC) or Data Guard, you know that because the password file …

A Deep Dive into Huge Pages       Recently, was working on optimising an Oracle database server that was struggling with memory management overhead. The server was beefy, sporting …

ASM Command-Line Utility (ASMCMD) – Complete Guide for Oracle DBAs Introduction Oracle ASM Command-Line Utility (ASMCMD) is a powerful and essential tool for Oracle DBAs and Grid Infrastructure administrators working …