Posts

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

Master Your EBS R12.2 Environment: Gathering Installed Module Information

By -
 If you need to gather details about the installed modules, product installation statuses, and configurations, you can leverage the following SQL utility. The Query  sqlplus apps/<apps_pw>@AD_TOP/sql/adutconf.sql Why use this  This script particularly using for during: Upgrades : Ensure all modules are dependencies are installed correctly. System Diagostics : Verity the product version and statues when trubleshooting   
Post a Comment
Read more

Step-by-Step Guide to Creating a New Forms Server in EBS R12.2

By -
In this guide, we will walk you through the steps to add and manage a new managed server in Oracle E-Business Suite (EBS). This process involves creating the managed server, updating configuration files, and starting the server. 1. Creating a Managed Server To create a new managed server, execute the following command. This will create the managed server and add a new entry to the context file, enabling you to start and stop the server using the adstrtal and adstpall scripts: Copy $ perl /patch/115/bin/adProvisionEBS.pl \ ebs-create-managedserver -contextfile=$CONTEXT_FILE \ -managedsrvname=MANAGED_SERVER_NAME -servicetype=forms \ -managedsrvport=MANAGED_SERVER_PORT -logfile=LOGFILE For example, to create a forms_server4 with port 7405: Copy $ perl $AD_TOP/patch/115/bin/adProvisionEBS.pl \ ebs-create-managedserver -contextfile=$CONTEXT_FILE \ -managedsrvname= forms_server4 -servicetype= forms \ -managedsrvport= 7405 -logfile=$APPLRGF/TXK/addMS_formsserver4...
1 comment
Read more