Installation/Configurations19c

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/’; …

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 …

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 …

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 …

Export & Import Process in Oracle 19c Container Database (CDB/PDB)   In this guide, we’ll walk through how to use the Data Pump (expdp/impdp) utility for export and import when …

How to Enable Archive Log Mode in Oracle 19c RAC Database: Step-by-Step Guide   In this article, we will learn how to enable Archive Log Mode in an Oracle 19c …

Disable SYS Auto Jobs from the Database   ======================================== DBMS_AUTO_TASK_ADMIN.DISABLE still shows the client_name enabled in DBA_AUTOTASK_CLIENT view (Doc ID 1565768.1) for Reference: Disable database jobs (DBMS_SCHEDULER , AUTOTASKS and …

Installing 19.18 Oracle Database on Linux 8.7 [root@oratest u01]# cat /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6192.168.209.128 oratest.oracle.com oratest [root@oratest ~]# uname -arLinux oratest.oracle.com 5.15.0-3.60.5.1.el8uek.x86_64 #2 SMP Wed …