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 Directory when patch is unzipped

patches=4968075,  << — Patch to be applied in English Version

4968075_AR:u4968075.drv << — Patch to be applied in Arabic Version

wait_on_failed_job=yes  << — specified this would not burst out the patch session instead it will wait for DBA Action via adctrl

workers=8 << — worker numbers to be adjusted according to the target machine CPU threads

COMMAND TO APPLY WEBLOGIC PATCH:
adop phase=apply apply_mode=downtime patchtop=/home/8010_EBS/EBS_Patches/SUPPLIER_PEROFMANCE_PATCH patches=4968075, 4968075_AR:u4968075.drv wait_on_failed_job=yes workers=8

( Conditional ) After the patch is applied, You may Synch your patch filesystem by running adop phase=fs_clone
Also relevancy of this article must be checked/validated for each / different respective environment like Single / Multiple EBS Nodes etc.

NOTE:
One should make use of adop parameters to add with above patch command:
Primary App Node: allnodes=no action=db
Secondary App Node: allnodes=no action=nodb

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 ( 12.2 )
REGENERATE JAR FILES FORCE = YES

Step -3 : UPDATE EBS CONTEXT FILE VALUE OF s_forms_launch_method FROM browser To jws

BEFORE
[appl8017@erpclone ~]$ cat $CONTEXT_FILE | grep s_forms_launch_method
browser
[appl8017@erpclone ~]$

AFTER
[appl8017@erpclone ~]$ cat $CONTEXT_FILE | grep s_forms_launch_method
jws
[appl8017@erpclone ~]$

Step-4 : FINALLY RUN AUTOCONFIG

Step-5 : Start EBS Services

Posted in Uncategorised | Leave a comment

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

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

  1. Source Container Database Environment
  2. sqlplus “/ as sysdba”
  3. alter pluggable database EBSCLONE close immediate;
  4. alter pluggable database EBSCLONE open read write;

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

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, PROD_ebs_patch, PROD)
-PDB SID in small letters/Capital letters accordingly present in Ebs DB Ctx File.

Make sure below 19c Database Parameters are properly set:
.local_listener=’hostname.domain:dbport’ in parameter file
.service_names=ERPCDB
.db_domain parameter removed from DB parameter file
.sev_case_sensitive should be false

Posted in Uncategorised | Leave a comment

After EBS 11i or EBS 12.1 Upgrade to EBS 12.2.x Some Pdf Reports show Garbage Characters


After EBS 11i or EBS 12.1 Upgrade to EBS 12.2.x Some Pdf Reports show Garbage Characters

OR

After EBS 12.2.x Fresh Installation Some Pdf Reports show Garbage Characters after a Pre-developed Oracle Report is deployed to New EBS 12.2 Install


SITUATION SHOWN ON REPORT VIEW:

Insert IMAGE:


CAUSE: Missing Font settings, Font File and Fornt AFM files

SOLUTION:

1.

===

Transferred Arial Font AFM files from source

/d01/PROD/apps/tech_st/10.1.2/guicommon/tk/admin/AFM

to target at

/d01/PROD/ebiz/fs1/EBSapps/10.1.2/guicommon/tk/admin/AFM

2.

===

Copy the below portion   :

*% Font Information =====================

From Source

/d01/PROD/apps/tech_st/10.1.2/guicommon/tk/admin/PPD/datap462.ppd

To

/d01/PROD/ebiz/fs1/EBSapps/10.1.2/guicommon/tk/admin/PPD/datap462.ppd

3.

==

Update    NLS_LANG variable on EBS 12.2 > 10.1.2 home > bin > reports.sh file ( Same as in EBS 12.1.3 env )

From:
/d01/PROD/apps/tech_st/10.1.2/bin/reports.sh


To:

/d01/PROD/ebiz/fs1/EBSapps/10.1.2/bin/reports.sh

Posted in Uncategorised | Leave a comment

How to Change WebLogic Admin Password in EBS 12.2

Change weblogic admin password in ebs 12.2 environment by following the given below Steps.

In EBS Apps DBA Life whenever you prepare a clone of Production ERP System, It is important to change all critical passwords to make it different from Live Production Enviroment.

In this post I have provided steps particularly about how to change the weblogic password before delivering your TEST/Clone environment to Business Users.

SOLUTION:

If you are on R12.AD.C.Delta.7 and R12.TXK.C.Delta.7 or later
In my case I am on AD/TXK 16
Steps 1: 
Source EBS 12.2 Run file system

Step 2:
adstpall.sh -skipNM -skipAdmin 
This will stop All EBS Services ( except Weblogic Admin & Node Mgr )

Step 3:
perl $FND_TOP/patch/115/bin/txkUpdateEBSDomain.pl -action=updateAdminPassword

Confirm if all Mid Tier services are in SHUTDOWN state. Enter “Yes” to proceed or anything else to exit: Yes

Step 4:
Check if the command completes successfully and admin server is started.

Step 5:
Access WLS admin console and try using the new password for Weblogic user.

Step 6:
Now run Command: adstrtal.sh

X=========== Recorded Session Below on EBS 12.2.14==========X
Full Session performed recently:


Stop Only EBS Services ( Excluding NodeManager and Weblogic Admin )
[appluat@ebstest scripts]$ adstpall.sh -skipNM -skipAdmin
You are running adstpall.sh version 120.22.12020000.7
Enter the APPS username: apps
Enter the APPS password:
Enter the WebLogic Server password:

Skipping Admin Server shutdown as option -skipAdmin is passed
Skipping Node Manager shutdown as option -skipNM is passed

All enabled services on this node are stopped.
[appluat@ebstest scripts]$



Better to make sure all FND, FNDLIBR, PALIBR, FNDOPP, frmweb processes are cleared on OS Level

==========================
Source EBS Run File System Env:
[appluat@ebstest scripts]$ . /archive/8010_clone/ebiz/EBSapps.env run
E-Business Suite Environment Information
File System Type : SINGLE
RUN File System : /archive/8010_clone/ebiz/fs1/EBSapps/appl
PATCH File System : NOT APPLICABLE
Non-Editioned File System : /archive/8010_clone/ebiz/fs_ne

DB Host: ebstest.srrco.gov.sa Service/SID: QSMTEST

Sourcing the RUN File System …
[appluat@ebstest scripts]$

==============================
Run the Password change command:
[appluat@ebstest scripts]$ perl $FND_TOP/patch/115/bin/txkUpdateEBSDomain.pl -action=updateAdminPassword
Program: txkUpdateEBSDomain.pl started at Tue Mar 25 11:51:03 2025
AdminServer will be re started after changing WebLogic Admin Password
All Mid Tier services should be SHUTDOWN before changing WebLogic Admin Password
Confirm if all Mid Tier services are in SHUTDOWN state. Enter “Yes” to proceed or anything else to exit: Yes
Enter the full path of Applications Context File [DEFAULT – /archive/8010_clone/ebiz/fs1/inst/apps/QSMTEST_ebstest/appl/admin/QSMTEST_ebstest.xml]:
Enter the WLS Admin Password:
Enter the new WLS Admin Password:
Enter the APPS user password:
Executing: /archive/8010_clone/ebiz/fs1/FMW_Home/webtier/perl/bin/perl /archive/8010_clone/ebiz/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/archive/8010_clone/ebiz/fs1/inst/apps/QSMTEST_ebstest/appl/admin/QSMTEST_ebstest.xml -servername=AdminServer -promptmsg=hide -logfile=/archive/8010_clone/ebiz/fs1/inst/apps/QSMTEST_ebstest/logs/appl/rgf/TXK/txkUpdateEBSDomain_Tue_Mar_25_11_51_03_2025/EBSProvisioner.log

Updating Weblogic Domain in online mode

Backup Location : /archive/8010_clone/ebiz/fs1/inst/apps/QSMTEST_ebstest/logs/appl/rgf/TXK/txkUpdateEBSDomain_Tue_Mar_25_11_51_03_2025
Logfile Location: /archive/8010_clone/ebiz/fs1/inst/apps/QSMTEST_ebstest/logs/appl/rgf/TXK/txkUpdateEBSDomain_Tue_Mar_25_11_51_03_2025/updateAdminPassword.log

Executing: /archive/8010_clone/ebiz/fs1/EBSapps/comn/util/jdk32/jre/bin/java -classpath :/archive/8010_clone/ebiz/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/archive/8010_clone/ebiz/fs1/FMW_Home/Oracle_EBS-app1/oui/jlib/srvm.jar:/archive/8010_clone/ebiz/fs1/EBSapps/comn/java/classes:/archive/8010_clone/ebiz/fs1/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/archive/8010_clone/ebiz/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar oracle.apps.ad.util.UpdateEBSDomain updateAdminPassword -contextfile /archive/8010_clone/ebiz/fs1/inst/apps/QSMTEST_ebstest/appl/admin/QSMTEST_ebstest.xml -promptmsg hide -logdir /archive/8010_clone/ebiz/fs1/inst/apps/QSMTEST_ebstest/logs/appl/rgf/TXK/txkUpdateEBSDomain_Tue_Mar_25_11_51_03_2025 -logfile /archive/8010_clone/ebiz/fs1/inst/apps/QSMTEST_ebstest/logs/appl/rgf/TXK/txkUpdateEBSDomain_Tue_Mar_25_11_51_03_2025/updateAdminPassword.log

Domain updated successfully
Restarting AdminServer with new Admin Password.

You are running adadminsrvctl.sh version 120.10.12020000.11
Stopping WLS Admin Server…
Refer /archive/8010_clone/ebiz/fs1/inst/apps/QSMTEST_ebstest/logs/appl/admin/log/adadminsrvctl.txt for details
AdminServer logs are located at /archive/8010_clone/ebiz/fs1/FMW_Home/user_projects/domains/EBS_domain_QSMTEST/servers/AdminServer/logs
adadminsrvctl.sh: exiting with status 0
adadminsrvctl.sh: check the logfile /archive/8010_clone/ebiz/fs1/inst/apps/QSMTEST_ebstest/logs/appl/admin/log/adadminsrvctl.txt for more information …
You are running adnodemgrctl.sh version 120.11.12020000.12
NodeManager log is located at /archive/8010_clone/ebiz/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1
adnodemgrctl.sh: exiting with status 0
adnodemgrctl.sh: check the logfile /archive/8010_clone/ebiz/fs1/inst/apps/QSMTEST_ebstest/logs/appl/admin/log/adnodemgrctl.txt for more information …

You are running adadminsrvctl.sh version 120.10.12020000.11

Starting WLS Admin Server…
Refer /archive/8010_clone/ebiz/fs1/inst/apps/QSMTEST_ebstest/logs/appl/admin/log/adadminsrvctl.txt for details
AdminServer logs are located at /archive/8010_clone/ebiz/fs1/FMW_Home/user_projects/domains/EBS_domain_QSMTEST/servers/AdminServer/logs
adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /archive/8010_clone/ebiz/fs1/inst/apps/QSMTEST_ebstest/logs/appl/admin/log/adadminsrvctl.txt for more information …

* IMPORTANT **
WebLogic Admin Password is changed.
Restart all application tier services using control scripts.

Inside generateMimeMappingsPropFile()…

/archive/8010_clone/ebiz/fs1/FMW_Home/user_projects/domains/EBS_domain_QSMTEST/config/mimemappings.properties already exists, updating it.

Inside updateMimeMappingsPropFile()…


Inside resetExistingMimeMappings()…

Overwriting the value for the parameter: xps
Overwriting the value for the parameter: png
Overwriting the value for the parameter: xml
Overwriting the value for the parameter: js
Overwriting the value for the parameter: svg
Overwriting the value for the parameter: swf

Reset of mime mappings completed.

Inside addMimeMappings()…

Adding of mime mappings completed.
Taking backup of existing mimemappings.properties.

Copying the file

SOURCE : /archive/8010_clone/ebiz/fs1/FMW_Home/user_projects/domains/EBS_domain_QSMTEST/config/mimemappings.properties
TARGET : /archive/8010_clone/ebiz/fs1/FMW_Home/user_projects/domains/EBS_domain_QSMTEST/config/mimemappings.properties_bkp
Copying temporary file as mimemappings.properties.

Copying the file

SOURCE : /archive/8010_clone/ebiz/fs1/FMW_Home/user_projects/domains/EBS_domain_QSMTEST/config/mimemappings.properties_temp
TARGET : /archive/8010_clone/ebiz/fs1/FMW_Home/user_projects/domains/EBS_domain_QSMTEST/config/mimemappings.properties
/archive/8010_clone/ebiz/fs1/FMW_Home/user_projects/domains/EBS_domain_QSMTEST/config/mimemappings.properties updated successfully.
Program: txkUpdateEBSDomain.pl completed at Tue Mar 25 11:55:38 2025
[appluat@ebstest scripts]$

==================
Stop Weblogic after Pwd Change
[appluat@ebstest scripts]$ ./adadminsrvctl.sh stop

You are running adadminsrvctl.sh version 120.10.12020000.11

Enter the WebLogic Admin password:
Enter the APPS Schema password:
Stopping WLS Admin Server…
Refer /archive/8010_clone/ebiz/fs1/inst/apps/QSMTEST_ebstest/logs/appl/admin/log/adadminsrvctl.txt for details
AdminServer logs are located at /archive/8010_clone/ebiz/fs1/FMW_Home/user_projects/domains/EBS_domain_QSMTEST/servers/AdminServer/logs
adadminsrvctl.sh: exiting with status 0
adadminsrvctl.sh: check the logfile /archive/8010_clone/ebiz/fs1/inst/apps/QSMTEST_ebstest/logs/appl/admin/log/adadminsrvctl.txt for more information …
[appluat@ebstest scripts]$

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

Start Weblogic with recently changed new password
[appluat@ebstest scripts]$ ./adadminsrvctl.sh start
You are running adadminsrvctl.sh version 120.10.12020000.11
Enter the WebLogic Admin password:
Enter the APPS Schema password:
Starting WLS Admin Server…
Refer /archive/8010_clone/ebiz/fs1/inst/apps/QSMTEST_ebstest/logs/appl/admin/log/adadminsrvctl.txt for details
AdminServer logs are located at /archive/8010_clone/ebiz/fs1/FMW_Home/user_projects/domains/EBS_domain_QSMTEST/servers/AdminServer/logs
adadminsrvctl.sh: exiting with status 0
adadminsrvctl.sh: check the logfile /archive/8010_clone/ebiz/fs1/inst/apps/QSMTEST_ebstest/logs/appl/admin/log/adadminsrvctl.txt for more information …
[appluat@ebstest scripts]$

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

Start EBS App Services now

[appluat@ebstest scripts]$ ./adstrtal.sh
You are running adstrtal.sh version 120.24.12020000.11
Enter the APPS username: apps
Enter the APPS password: *****
Enter the WebLogic Server password: New Password we changed

==============
Important NOTE:
We can use the following approach to update the Weblogic admin server password if you are on an earlier version of R12.AD.C.Delta.7 or R12.TXK.C.Delta.7.

A) Access the WebLogic Administrative Console by logging in.
B) Select Domain after selecting Lock & Edit.
C) Select the Advanced tab after selecting the Security tab.
D) In the Node Manager Password field, provide the new password you wish to use for the WebLogic Admin User.
E) Click Save, then confirm that the settings were correctly changed. Next, choose “Activate Changes.”
F) Select Myrealm after selecting Security Realms.
G) Choose Users and Groups, then Weblogic User. Then, type the new WebLogic user password.
H) Verify that the settings have been correctly modified.

For reference you can check the given below DOC ID of My oracle support.
MOS  Doc ID 2178617.1

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 Directory when patch is unzipped

patches=4968075,  << — Patch to be applied in English Version

4968075_AR:u4968075.drv << — Patch to be applied in Arabic Version

wait_on_failed_job=yes  << — specified this would not burst out the patch session instead it will wait for DBA Action via adctrl

workers=8 << — worker numbers to be adjusted according to the target machine CPU threads

COMMAND: adop phase=apply apply_mode=downtime patchtop=/home/8010_EBS/EBS_Patches/SUPPLIER_PEROFMANCE_PATCH patches=4968075, 4968075_AR:u4968075.drv wait_on_failed_job=yes workers=8

Posted in Uncategorised | Leave a comment