Posts

How to Stop and Start Oracle GoldenGate Processe

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

Oracle 19c Data Guard Switchover Procedure – Step-by-Step Guide

By -
Purpose This guide describes a step-by-step approach to perform a switchover in an Oracle Data Guard configuration. Prerequisites Primary and Standby are healthy and synchronized. Both databases are under clusterware control. SYSDBA connectivity is available. Application services are stopped before switchover. Environment Details Primary Database  PRD_CDB Standby Database  STBY_CDB Primary Server  PRD_NODE1 Standby Server  STBY_NODE1 Switchover Procedure (With Actual Output) 1. Remove DelayMins (if configured) DGMGRL> connect sys/<password> DGMGRL> show database PRD_CDB delaymins; DGMGRL> edit database PRD_CDB set property 'DelayMins'='0'; DGMGRL> show database PRD_CDB delaymins; Sample Output: DelayMins = '180' Property "DelayMins" updated...
Post a Comment
Read more

The Future of Oracle DBA Work in a AI Era

By -
Artificial Intelligence is entering a new era. What started as productivity assistance has now evolved into digital teammates capable of performing business tasks independently. Microsoft CEO Satya Nadella recently outlined a three-phase roadmap that explains how AI will reshape workplaces in the coming years. This article breaks down these phases and explains how this transformation will impact Oracle DBAs specifically.   Phase 1: Copilot- AI as a Personal Assistant The first evolution in workplace AI began with tools like Microsoft Copilot. Copilot functions as a personal digital assistant inside daily-use applications such as Word, Excel, PowerPoint, Outlook, Teams, and coding tools.   What Copilot Helps With Drafting documents and emails Summarising long reports and meetings Analysing Excel data Creating PowerPoint slides Generating or reviewing code Automating routine writing tasks   Phase 2: Digital Labor - AI Agents as Virtual...
Post a Comment
Read more

Understanding and Configuring PCP in Oracle EBS

By -
  1. What is PCP? PCP stands for Parallel Concurrent Processing . It allows Concurrent Managers in Oracle E-Business Suite to run on multiple nodes instead of just one. Why use PCP? Load Balancing – Distributes workload across multiple nodes for better performance. High Availability – If one node fails, managers can failover to another node. Failover and Failback – Automatically moves managers to available nodes during failure and back when the node is restored.   2. PCP Setup Types RAC Database Setup – Commonly used with PCP. Non-RAC Setup – PCP can still work without RAC by using TNS aliases for connectivity.   3. How PCP Works Each node runs Concurrent Managers. Managers connect to the database using TWO_TASK (TNS alias) defined in: adcmctl.sh gsmstart.sh   4. Internal Monitor (IMON) Optional Service but recommended. Monitors the  Internal Concurrent M...
Post a Comment
Read more

The Art of Asking the Right Questions in Oracle EBS Troubleshooting

By -
When dealing with performance or functional issues in Oracle E-Business Suite (EBS), asking the right questions can help identify the root cause faster. Below are some commonly used questions categorized by the type of issue.   General Questions 1.      Since when is the issue happening? 2.      Are you facing similar issues in any other instances? 3.      Was it working fine earlier?   If the Application is Slow 1.      Which part of the application is slow? (e.g., HTTP pages, Forms, or everything?) 2.      If it's Forms, are they seeded, custom, or third-party integrations? 3.      If it's related to customizations, can you disable them and retest? 4.      Can you provide screenshots or navigation steps to help replicate the issue? 5.      Is the slowness constant or does it occur at specific t...
Post a Comment
Read more

ADOP Troubleshooting Tools in Oracle E-Business Suite (EBS)

By -
1. ADOP Validate – Quick Health Check Purpose : To check if the current patching cycle is healthy. Command:  adop -validate What it does: Runs a quick system check Alerts you if there are any configuration or edition issues Often the first step Oracle Support asks you to run Location:  $AD_TOP/bin Use case:  Before starting or during a patching cycle, run this to ensure everything is OK.   2. ADOPSCANLOG – Scan ADOP Log Files Easily Purpose:  To check patching logs quickly from current or past sessions. Why it is important: Saves time by scanning all logs in one go Helps you find errors, warnings, or specific messages You can search older ADOP sessions too Command examples: adopscanlog                --> Scans latest session logs adopscanlog session_id=0   --> Scans ALL past sessions adopscanlog loglevel=error...
Post a Comment
Read more

How to Recover Weblogic Pssword in R12.2

By -
When managing Oracle E-Business Suite R12.2, system administrators often need to decrypt the WebLogic boot.properties password for troubleshooting or configuration validation. Below is a step-by-step guide to perform this securely using WLST (WebLogic Scripting Tool). Step 1: Locate the boot.properties File Copy cd $EBS_DOMAIN_HOME/servers/AdminServer/security/ cat boot.properties Sample Output: Copy username={AES}32WjQKxRgxZu23m3gohzso8sSV4IlB3xCfW+fVMLbf0 password={AES}traTrS34UEZ4bfIuDeJBFpLIjJXL+laajBDGyikOzsM= This file stores encrypted credentials used for WebLogic Server auto-start. Step 2: Set Required Environment Make sure your $EBS_DOMAIN_HOME and $FMW_HOME are correctly set. In this example: Copy echo $EBS_DOMAIN_HOME /apps/applmgr/r12/fs1/FMW_Home/user_projects/domains/EBS_domain Step 3: Launch WLST Navigate to the WLST location: Copy cd $FMW_HOME/oracle_common/common/bin/ ./wlst.s...
Post a Comment
Read more