Author Archives: syedraheeldba.com

How To Find Particular Database Session ID From the SQLID ( ORACLE 19c)

ISSUE: In this Blog we are going to learn about How To Find a Particular Database Session ID From the SQLID.One of my customer informed me I have query running since 10 hours and Healready confirmed with Business user that … Continue reading

Posted in Uncategorised | Leave a comment

How to check status of Managed Servers under weblogic console from linux instead of browser URL.

Issue:While accessing the EBS 12.2.13 Weblogic Console to check health status of EBS managed server the browser redirects to below error as a security restriction:The Server is not able to service this request: [Socket:000445]Connection rejected, filter blocked Socket, weblogic.security.net.FilterException: [Security:090220]rule … Continue reading

Posted in Uncategorised | Leave a comment

After applying EBS 12.2.13 RUP on Redhat Linux 8.9 OS, Viewing the Output and Log Files from any Concurrent Request Shows a Blank Page in the Browser

Environment: Oracle EBS Release that is 12.2.13 with 19c that is 19.22 which is Running on Red Hat Enterprise Linux release 8.9 (Ootpa) Issue: After Applying : SOLUTION: Make sure to shutdown EBS Services including Weblogic Then Run the following … Continue reading

Posted in Uncategorised | Leave a comment

OS Errors sh: scl: line 1: syntax error: unexpected end of file while starting WebLogic Admin service in EBS 12.2 on Redhat Linux 8.9, here’s how to solve it!

OS level error while starting WebLogic Admin adadminsrvctl.sh service in EBS 12.2 on Redhat and or Oracle Linux 8.9 : You are running adadminsrvctl.sh version 120.10.12020000.11 Starting WLS Admin Server…Refer /u01/8005_uat_app/ebiz/fs1/inst/apps/PREUPG_ebsappuat/logs/appl/admin/log/adadminsrvctl.txt for details AdminServer logs are located at /u01/8005_uat_app/ebiz/fs1/FMW_Home/user_projects/domains/EBS_domain/servers/AdminServer/logs adadminsrvctl.sh: … Continue reading

Posted in Uncategorised | Leave a comment

How to extract EBS 12.1.x or EBS 12.2.x Workflow Mailer logs having Error, Exception or UNEXPECTED Keywords in your target logfiles

Goal: Extraction of EBS 12.1.x or EBS 12.2.x Workflow Mailer logs having Error, Exception or UNEXPECTED Keywords in your target logfiles. By following the given below steps you will easily extract EBS 12.1.x or EBS 12.2.x Workflow Mailer logs having … Continue reading

Posted in Uncategorised | Leave a comment

How to perform Basic Health Check, Stop & Start, Oracle E-Business 12.2.x Application & Database 19c – 19.12

Steps to STOP Oracle EBS 12.2.x Application Services:1. Connect Putty to Application Sever IP:    2. Login with Application OS User ( Username / password ) and source EBS Application Env 3. cd $ADMIN_SCRIPTS_HOME4. [applprod@erp scripts]$ pwd /u01/Ebiz/fs1/inst/apps/ERPPROD_erp/admin/scripts [applprod@erp scripts]$ … Continue reading

Posted in Uncategorised | Leave a comment

How to save time and apply ebs 12.2 patch without adop online patching:

GOAL: Avoid long and time taking adop online patching cycle and apply patch in downtime to your run file system quickly SOLUTION: adop phase=apply apply_mode=downtime  << — Patch to be applied when EBS Services are down patchtop=/home/8010_EBS/EBS_Patches/SUPPLIER_PEROFMANCE_PATCH  << — Customer … Continue reading

Posted in Uncategorised | Leave a comment

EBS 12.2: How to Enable Java Web Start for Java Applet Support in Modern Browsers

Step – 1: Apply All EBS 12.2 relevant Patches to your EBS Application from below JWS MOS Doc:Using Java Web Start with Oracle E-Business Suite(Doc ID 2188898.1) Step – 2: Enable Java Web Start : Source EBS Run FS Environment … Continue reading

Posted in Uncategorised | Leave a comment

How to shutdown / start pluggable Database only from a Container Database in 19c

=================================== =========================================

Posted in Uncategorised | Leave a comment

ERROR: while execution of txkPostPDBCreationTasks.pl ( Part of converting noncdb to pdb ) or any other 19c ebs Database phases:

FUNCTION: main::validateAppsSchemaCredentials [ Level 1 ]ERRORMSG: Invalid APPS database user credentials. SOLUTION: Possible areas and tips to review and fix the above issue :Make sure :– Select name from v$active_services and make sure below services are present and configured:( ebs_PROD, … Continue reading

Posted in Uncategorised | Leave a comment