Posts

OCI: Gateway Types and Network Routing Fundamentals Part-4

By -
When working with Oracle Cloud Infrastructure (OCI), understanding the different types of gateways is essential for designing secure and efficient network connectivity. In this article, I will explain Internet Gateway, NAT Gateway, Service Gateway, and Dynamic Routing Gateway (DRG) in simple terms. Internet Gateway (IGW) An Internet Gateway (IGW) is an optional gateway that can be attached to a Virtual Cloud Network (VCN) to enable direct connectivity between the VCN and the internet. The Internet Gateway supports both inbound and outbound internet traffic. By default, a compute instance deployed in a public subnet cannot access the internet unless: An Internet Gateway is created and attached to the VCN. The route table is configured to direct internet traffic through the Internet Gateway. The instance has a public IP address assigned. Oracle manages the availability, redundancy, and maintenance of the Internet Gateway internally. Key Points Used p...
Post a Comment
Read more

OCI: Basic Naming and Terminology's Part-3

By -
Image
   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...
Post a Comment
Read more

Oracle E-Business Suite DMZ Setup in R12.2

By -
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...
Post a Comment
Read more

How to Enable Unified Auditing in Oracle E-Business Suite 12.2

By -
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...
Post a Comment
Read more

Oracle DBA Daily Health Check & Pre-Clone Information Script

By -
  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...
Post a Comment
Read more

How to Stop and Start Oracle GoldenGate Processe Part -6

By -
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...
Post a Comment
Read more

Step-by-Step Guide to Enable Supplemental Logging in Oracle Database for GoldenGate Part -5

By -
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...
Post a Comment
Read more