Posts

Oracle GoldenGate 19c Downstream Integrated Capture with ADG Fetch Redirection and Cascaded Archived Redo from Oracle Database 11.2.0.4

Image
This article demonstrates Oracle GoldenGate 19c downstream Integrated Extract using archived redo cascaded through an Oracle Active Data Guard standby. FETCHUSERIDALIAS is used to redirect supported runtime fetch operations to the ADG standby, reducing the need for Extract to query the production primary database directly. Oracle GoldenGate downstream capture is specifically designed to offload the primary/production database from where the data is being captured. This architecture is useful for reducing the source database involvement and overhead but at the cost of additional implementation complexity compared to the normal GoldenGate configuration.
Post a Comment
Read more

Building an End-to-End CI/CD Deployment Workflow on Oracle Cloud Infrastructure Using OCI DevOps and GitHub

Image
Continuous Integration and Continuous Deployment, commonly known as CI/CD, has become an important part of modern application delivery. Instead of manually packaging application files, copying them to servers, restarting services and validating the deployment each time, a CI/CD workflow allows these steps to be automated and repeated with less manual effort. In this article, I will provide an overview of how a CI/CD workflow can be designed using OCI DevOps and other Oracle Cloud Infrastructure services by referencing a CI/CD deployment project I created. The goal of the project was to build a practical deployment workflow for a multi component Laravel based application consisting of a frontend, backend and middleware layer. The project uses OCI DevOps build pipelines, deployment pipelines, OCI Vault, OCI Artifact Registry, OCI Compute, OCI Networking, OCI Load Balancer, OCI Logging, OCI Notifications and GitHub integration.
Post a Comment
Read more

Configuring Oracle APEX on Linux

Image
What is Oracle APEX? Oracle APEX (Application Express) is an enterprise low-code platform that enables you to build scalable, secure web and mobile applications quickly. It runs natively within the Oracle Database, allowing developers to build feature-rich apps using SQL and PL/SQL with minimal traditional programming. Getting Started with Oracle APEX Prerequisites You must have an Oracle database, preferably a pluggable database, installed on the server where the APEX installation is going to be performed. Certain APEX versions require different version databases. In this case, I used APEX 24.2 with an Oracle Database release 19c (base release). But for higher APEX versions, such as APEX 26.1, you require Oracle Database release 19c with Database Release Update 19.18 (January 2023) or newer. You can follow this guide on Installing Oracle Database 19c  to configure a database in your environment. APEX installation is usually done via the same user you used to configure the DB. Step...
Post a Comment
Read more

A Step-by-Step Guide to Backing Up Oracle Databases with Data Pump (expdp & impdp)

 How to Back Up an Oracle Database Using Data Pump (expdp & impdp) Oracle Data Pump is a high-performance utility for exporting ( expdp ) and importing ( impdp ) data and metadata between Oracle databases. It enables fast, flexible and secure data movement for tasks like database backups, migrations and schema transfers. expdp creates dump files of database objects, while impdp restores them into a target database. Data Pump supports parallel execution, fine-grained filtering and remapping options, making it a powerful tool for DBAs handling large-scale Oracle environments. Oracle Data Pump supports a variety of export and import modes: Full database Specific schemas Individual tables On the database server, if OS authentication is properly configured you can issue expdp \"/ as sysdba\" and Data Pump will not require you to enter the SYS password, it connects via OS authentication. Export Process Before taking the export create a directory in the database with the path ...
Post a Comment
Read more

VM Post Provision Steps

Steps to do after provisioning a VM to enable connectivity to the internet and assign an IP address --OLD OS RELEASES-- Edit the following file: /etc/sysconfig/network-scripts/ifcfg-ens192 vi /etc/sysconfig/network-scripts/ifcfg-ens192 TYPE=Ethernet PROXY_METHOD=none BROWSER_ONLY=no BOOTPROTO=static #Changed from dhcp to static or none DEFROUTE=yes IPV4_FAILURE_FATAL=no IPV6INIT=yes IPV6_AUTOCONF=yes IPV6_DEFROUTE=yes IPV6_FAILURE_FATAL=no IPV6_ADDR_GEN_MODE=stable-privacy NAME=ens192 UUID=590dc84a-35ac-40bd-a3d9-0e62950e5018 DEVICE=ens192 ONBOOT=yes #Changed from no to yes IPADDR=172.16.1.17 #Add IP address NETMASK=255.255.255.0 #Add netmask GATEWAY=172.16.1.254 #Add gateway DNS1=8.8.8.8 #Add DNS entry 1 (max 3) DNS2=8.8.8.4 # Add DNS entry 2 [root@slr-app-server network-scripts]# Restart network: systemctl restart network Set the hostname of the server: hostnamectl set-hostname slr-app-server Check ping connectivity: ping 8.8.8.8 Reboot the server to confirm that post-provisioning st...
Post a Comment
Read more

Configuring Oracle Enterprise Manager 24ai

Image
  Step 01 - Install and configure an Oracle Database on the EM server. You can follow the below guide to install an Oracle 19c Database: Installing Oracle Database 19c on Linux 8 (OL8) Server Step 02 - Patch the DB home + DB (Optional) Step 03 -  Install the required software to the server and create the following mkdir -p /home/u01/app/oracle/middleware_24ai mkdir -p /home/u01/app/oracle/agent_24ai Step 04 - Run the following in the Database. sqlplus / as sysdba alter system set "_allow_insert_with_update_check"=true scope=both Step 05 - Extract the zip file unzip V1046951-01.zip unzip V1046952-01.zip unzip V1046953-01.zip unzip V1046954-01.zip unzip V1046955-01.zip The extracted files: em24100_linux64-2.zip em24100_linux64-3.zip em24100_linux64-4.zip em24100_linux64-5.zip em24100_linux64.bin Make sure all the extracted files as well as the zip files are located in the same location or else you will encounter the following error when running the executable: ERROR: Installer ...
Post a Comment
Read more

Configuring Agents on Oracle Enterprise Manager 24ai

Image
  Step 01 - Check ./emctl status oms -details Oracle Enterprise Manager 24ai Release 1 Copyright (c) 1996, 2024 Oracle Corporation.  All rights reserved. Console Server Host        : <redacted> HTTP Console Port          : 7788 HTTPS Console Port         : 7803 HTTP Upload Port           : 4889 HTTPS Upload Port          : 4903 EM Instance Home           : /home/u01/app/oracle/middleware_24ai/gc_inst/em/EMGC_OMS1 OMS Log Directory Location : /home/u01/app/oracle/middleware_24ai/gc_inst/em/EMGC_OMS1/sysman/log OMS is not configured with SLB or virtual hostname Agent Upload is locked. OMS Console is locked. Active CA ID: 1 Console URL: https://<redacted>:7803/em Upload URL: https://<redacted>:4903/empbs/upload WLS Domain Information Domain Name            : GCDomain Admin Se...
Post a Comment
Read more