Modern Oracle DBA

   Tenancy The general meaning of Tenancy is: Tenant = a person who uses or occupies something. Tenancy = the agreement or arrangement under which they use it. When you create OCI services, Oracle creates a tenancy for you. Within the datacenter, you can create multiple tenancies. Tenancy includes all of your OCI resources, including storage, databases, compute instances, and more. While creating the tenancy, we need to provide the region, which is called your home region. We may additionally subscribe to other regions. When you are going to create a tenancy, Oracle will create the compartment called the root compartment. Region The general meaning of Region is an area or a particular place/location. Region is basically the geographical area where Oracle data centers are located. Regions contain physical datacenters. Those datacenters are named Availability Domains. Each region can have multiple datacenters or can have one datacenter. Your cloud account has a home region, an...

In Oracle E-Business Suite (EBS), a DMZ (Demilitarized Zone) setup is used to securely expose selected application services to external users while keeping core services protected inside the corporate intranet. This architecture separates Internal and External application tiers and enforces access control using trust levels. Normally We are implement DMZ setup for :  I-Supplier  I-Receivable setups I-procurement This Post explains: Internal vs External application nodes Node Trust Level and Responsibility Trust Level Important profile options Role of txkChangeProfH.sql Correct AutoConfig sequence Step-by-step DMZ setup procedure Internal and External Application Nodes Internal Node The Internal Application Tier is configured within the corporate intranet and is meant only for internal users. Key characteristics: Sharing application tier with external users is not allowed Services running on Internal Node: Concurrent Manager Serv...

Oracle EBS R12.2 Unified Auditing – Enable, Configure and Validate (Step-by-Step Guide) Unified Auditing is Oracle Database’s consolidated auditing framework that combines standard auditing, fine-grained auditing (FGA), RMAN auditing, Data Pump auditing, and other audit mechanisms into a single unified audit trail (UNIFIED_AUDIT_TRAIL view). In Oracle EBS R12.2, Unified Auditing is used to track sensitive object access, security object modifications, account management, login failures, and tablespace changes. It provides a centralized and secure auditing mechanism to simplify compliance and monitoring. Prerequisites Before proceeding, ensure that the Oracle E-Business Suite environment meets the minimum required AD and TXK code levels. R12.AD.C.Delta.13 (Minimum) R12.TXK.C.Delta.13 (Minimum) Validate Current Auditing Status SQL> SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Unified Auditing'; If the result is FALSE , Unified Auditing is not enabled. Procedure to En...

  As an Oracle DBA, one of our routine responsibilities is to collect critical database information for various operational and strategic activities such as: Pre-clone activities Disaster Recovery (DR) readiness Audits and compliance Migration planning Environment documentation Running multiple SQL queries manually every time is time-consuming, error-prone, and may result in missed configuration details. To address this, I use a single consolidated SQL script that safely gathers all essential Oracle database information in one execution. What Information Does This Script Collect? Database & Environment SPFILE / PFILE details Archive log mode Controlfile locations Storage Details Datafiles and tempfiles Tablespace sizes Autoextend and maxsize settings Physical file paths Redo & Recovery Redo log groups and members Redo log status Security & Objects Database links (with recreate statements) Directory objects (with recreate statements) SYS, SYSTEM, and application users Pa...

s This guide explains how to stop and start Oracle GoldenGate Extract, Replicat, and Manager processes using the GGSCI command-line interface in a classic architecture setup. Checking Current GoldenGate Process Status Use the following command to view the status of all GoldenGate processes: GGSCI> info all Example output: Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EXT19EBS 00:00:04 00:00:08 EXTRACT RUNNING EXT19TST 00:00:03 00:00:07 EXTRACT RUNNING PMP19EBS 00:00:00 00:00:00 EXTRACT RUNNING PMP19TST 00:00:00 00:00:09 Stopping Extract Processes Syntax GGSCI> stop extract <extract_name> Example GGSCI> stop EXTRACT EXT19EBS GGSCI> stop EXTRACT PMP19EBS Verify GGSCI> info all Example output: Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT STOPPED EXT19E...

Purpose In environments using Oracle GoldenGate, enabling Supplemental Logging is a mandatory prerequisite.  Supplemental logging ensures that additional information about database changes is written into redo logs. This allows GoldenGate to correctly capture UPDATE and DELETE operations during replication. In Multitenant Databases (CDB/PDB), supplemental logging must be enabled at the CDB$ROOT container level. This document explains how to check and enable supplemental logging step by step. Prerequisites SYSDBA access to the database Database running in ARCHIVELOG mode Access to the CDB root container GoldenGate environment planning completed Step 1: Check Supplemental Logging Status Verify whether supplemental logging is already enabled. SQL> select SUPPLEMENTAL_LOG_DATA_MIN, SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_UI from gv$database; Example Output SUPPLEME SUP SUP -------- --- --- NO NO NO NO NO NO Explanation Column D...

Microservices Architecture (MA) Adding an Extract in Oracle GoldenGate 21c Microservices Architecture can be done via the Administration Service Console (Web UI) or the Admin Client (Command Line) . Method 1: Administration Service Console (Web UI) 1.      Log in to the Oracle GoldenGate Administration Service URL. 2.      Navigate to the Overview page. 3.      Click the + (plus) button next to Extracts to open the Add Extract wizard. 4.      Select Extract Type     Choose Integrated Extract (most common for Oracle) or Initial Load Extract .     Click Next . 5.      Basic Information     Name : Up to 8 characters     Description : Optional     Intent : Select Unidirectional , High Availability , etc.     Begin Note : Select NOW , Custom Time , or CSN 6.      Trail File ...