Assumption:
DB version : 12.1.0.1.0
EBS: 12.1.3
Patches to be applied
9239089- R12.AD.B.DELTA.3
9239090- Oracle E-Business Suite Release 12.1.3
9239095- Consolidated online help
Post-Applying above patches
9817770- POST-R12.ATG_PF.B.DELTA.3 CONSOLIDATED PATCH
9966055- TRANSLATED VERSION OF FNDSCSGN NOT LAUNCHED
2.1 Enable Maintenance mode using adadmin
[applmgr@fbsebs ~]$ . /u01/app/FBS/apps/apps_st/appl/APPSFBS_fbsebs.env
[applmgr@fbsebs ~]$ adadmin AD Administration Main Menu
--------------------------------------------------
1. Generate Applications Files menu
2. Maintain Applications Files menu
3. Compile/Reload Applications Database Entities menu
4. Maintain Applications Database Entities menu
5. Change Maintenance Mode
6. Exit AD Administration
Select option 5 and then select option 1. Once maintenance mode is set, please exit.
Enter your choice [6] : 5
Change Maintenance Mode
----------------------------------------
Maintenance Mode is currently: [Disabled].
Maintenance mode should normally be enabled when patching
Oracle E-Business Suite and disabled when users are logged on
to the system. See the Oracle E-Business Suite Maintenance
Utilities manual for more information about maintenance mode.
Please select an option:
1. Enable Maintenance Mode
2. Disable Maintenance Mode
3. Return to Main Menu
Enter your choice [3] : 1
sqlplus -s &un_apps/***** @/u01/app/FBS/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql ENABLE
Successfully enabled Maintenance Mode.
Review the messages above, then press [Return] to continue.
2.2 Download 12415211 and unzip.
Then perform the below steps:
[applmgr@fbsebs app]$ cd /u01/app/FBS/apps/tech_st/10.1.2/lib/
[applmgr@fbsebs lib]$ cp -p -R stubs stubsORIG
[applmgr@fbsebs lib]$ cd stubs
[applmgr@fbsebs stubs]$ cp /u01/patches/app/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so .
[applmgr@fbsebs stubs]$ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
[applmgr@fbsebs stubs]$ ln -s libgcc_s.so.1 libgcc_s.so
The instructions for the 10.1.3 Oracle Home are:
[applmgr@fbsebs stubs]$ cd /u01/app/FBS/apps/tech_st/10.1.3/lib/
[applmgr@fbsebs lib]$ cp -p -R stubs stubsORIG
[applmgr@fbsebs lib]$ cd stubs
[applmgr@fbsebs stubs]$ cp /u01/patches/app/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so .
[applmgr@fbsebs stubs]$ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
[applmgr@fbsebs stubs]$ ln -s libgcc_s.so.1 libgcc_s.so
2.3 Before Applying Patch: 9239089
Copy adgrants.sql from 9239089/admin folder to $DB_ORACLE_HOME/appsutil/admin, if the admin directory doesn't exist please create.
[oracle@fbsebs ~]$ cd /u01/app/FBS/db/tech_st/11.1.0/
[oracle@fbsebs 11.1.0]$ . FBS_fbsebs.env
[oracle@fbsebs 11.1.0]$ sqlplus /nolog
SQL*Plus: Release 11.1.0.7.0 - Production on Mon Dec 2 12:40:35 2024
Copyright (c) 1982, 2008, Oracle. All rights reserved.
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql apps
Also, add the below parameter in database level and restart.
_disable_fast_validate=TRUE
[oracle@fbsebs 11.1.0]$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Mon Dec 2 12:46:45 2024
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create spfile from pfile;
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2166536 bytes
Variable Size 427819256 bytes
Database Buffers 624951296 bytes
Redo Buffers 14000128 bytes
Database mounted.
Database opened.
SQL> alter system set "_disable_fast_validate"=true scope=both;
System altered.
Note:
For 11gR1 and 11.2.0.1 databases, before performing any Applications upgrade or maintenance operations, customers must add the following to the database initialization file to disable fast validation for PL/SQL recompilations:
_disable_fast_validate=TRUE
The line should be commented out during the normal operation of the Applications system.
2.4 Apply patches using adpatch utility.
- 9239089
[applmgr@fbsebs stubs]$ . /u01/app/FBS/apps/apps_st/appl/APPSFBS_fbsebs.env
[applmgr@fbsebs stubs]$ cd /u01/patches/app/9239089/
[applmgr@fbsebs 9239089]$ adpatch apply=yes driver=u9239089.drv
- 9239090- Please perform the below steps before applying this patch.
Replace the following line under the Linux section of the $AD_TOP/bin/adrelinknew.sh:
e.g.
vi /u01/app/FBS/apps/apps_st/appl/ad/12.0.0/bin/adrelinknew.sh
CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh'
with
CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh -Wl,--noinhibit-exec'
Run the adadmin utility and relink application executables
Please note the upgrade patch will take time depending upon on what hardware you are using.
[applmgr@fbsebs 9239089]$ cd /u01/patches/app/9239090/
[applmgr@fbsebs 9239090]$ adpatch apply=yes driver=u9239090.drv
- 9239095
[applmgr@fbsebs 9239090]$ cd /u01/patches/app/9239095/
[applmgr@fbsebs 9239095]$ adpatch apply=yes driver=u9239095.drv
- 9817770
[applmgr@fbsebs 9239095]$ cd /u01/patches/app/9817770/
[applmgr@fbsebs 9817770]$ adpatch apply=yes driver=u9817770.drv
- 9966055
[applmgr@fbsebs 9817770]$ cd /u01/patches/app/9966055/
[applmgr@fbsebs 9966055]$ adpatch apply=yes driver=u9966055.drv
2.5 Post Upgrade steps
2.5.1 Recreate appsutil and copy to DB server Oracle Home
[applmgr@fbstes ~ 05:57 PM]$cd $APPL_TOP
[applmgr@fbstes ~ 05:58 PM]$. APPSFBS_fbstes.env
[applmgr@fbstes ~ 05:58 PM]$ perl $AD_TOP/bin/admkappsutil.pl
Starting the generation of appsutil.zip
Log file located at /u01/app/FBS/inst/apps/FBS_fbstes/admin/log/MakeAppsUtil_12011758.log
output located at /u01/app/FBS/inst/apps/FBS_fbstes/admin/out/appsutil.zip
MakeAppsUtil completed successfully.
[applmgr@fbstes ~ 05:58 PM]$
2.5.2 Copy the apputil.zip file to Database oracle home On DB-Tier:
[oracle@fbstes ~ 05:59 PM]$. FBS_fbstes.env
[oracle@fbstes ~ 05:59 PM]$cd $ORACLE_HOME
[oracle@fbstes 11.1.0 06:00 PM]$mv appsutil.zip appsutil.zip_orig
[oracle@fbstes 11.1.0 06:00 PM]$cp /u01/app/FBS/inst/apps/FBS_fbstes/admin/out/appsutil.zip .
unzip -o appsutil.zip
Recreate Context File on DB -Tier
[oracle@fbsebs ~]# cd $ORACLE_HOME/appsutil/bin
[oracle@fbsebs bin]$ perl adbldxml.pl appsuser=apps appspasswd=apps
Starting context file generation for db tier..
Using JVM from /u01/app/FBS/db/tech_st/11.1.0/appsutil/jre/bin/java to execute java programs..
The log file for this adbldxml session is located at:
/u01/app/FBS/db/tech_st/11.1.0/appsutil/log/adbldxml_06221753.log
UnsatisfiedLinkError exception loading native library: njni11
Could not Connect to the Database with the above parameters, Please answer the Questions below
Enter Hostname of Database server: fbsebs
Enter Port of Database server: 1531
Enter SID of Database server: FBS
Enter the value for Display Variable: fbsebs:0.0
Context File /u01/app/FBS/db/tech_st/11.1.0/appsutil/FBS_fbsebs.xml
already exists.
Overwriting Context File may cause loss of existing settings, hence
backing it up as: /u01/app/FBS/db/tech_st/11.1.0/appsutil/FBS_fbsebs.xml.bak
The context file has been created at:
/u01/app/FBS/db/tech_st/11.1.0/appsutil/FBS_fbsebs.xml
2.5.3 Run autoconfig on DB-Tier
[oracle@fbsebs FBS_fbsebs]$ adautocfg.sh
2.5.4 Run autoconfig on Apps-Tier
2.6 Validate the New EBS version
SQL> select release_name from apps.fnd_product_groups; RELEASE_NAME--------------------------------------------------12.1.3Note:
If forms are not opening
Stop the application tier services
Run adadmin regenerate JAR file
Compile all the forms.
cd $ORACLE_HOME/forms/lib
make -f ins_forms.mk install
Reference Docs:
Oracle E-Business Suite Release 12.1.3 Readme (Doc ID 1080973.1)
Applying Patch 9239090 Failed During The Relink of FEMCCE module (Doc ID 1303269.1)
Relink Of Modules ENCACN or WICMEX or WICMLX Fails While 12.1.3 Upgrade on EL 6 (Doc ID 1583440.1)
Database Preparation Guidelines for an E-Business Suite Release 12.1 Upgrade (Doc ID 761570.1)
Known Issue:
No comments:
Post a Comment