Source: http://clikir.blogspot.in/2017/01/oracle-ebs-r1226-implementation-with.html
High level Steps Involved to do the R12.2.6 Fresh Implementation upgrade steps are:
p22066363_R12_GENERIC.zip ( StartCD 51 )
V100052-01_1of3.zip
V100052-01_2of3.zip
V100052-01_3of3.zip
V100059-01_1of2.zip
V100059-01_2of2.zip
V100060-01_1of3.zip
V100060-01_2of3.zip
V100060-01_3of3.zip
V100061-01.zip
V100102-01.zip
V29856-01.zip
V35802-01.zip
V35803-01_1of3.zip
V35803-01_2of3.zip
V35803-01_3of3.zip
V35804-01_1of2.zip
V35804-01_2of2.zip
V46095-01_1of2.zip
V46095-01_2of2.zip
V75792-01.zip
========================================================================
2. Download EBS Installation Packages, Oracle E-Business Suite (12.2.6)
V776670-01_10of10.zip
V776670-01_1of10.zip
V776670-01_2of10.zip
V776670-01_3of10.zip
V776670-01_4of10.zip
V776670-01_5of10.zip
V776670-01_6of10.zip
V776670-01_7of10.zip
V776670-01_8of10.zip
V776670-01_9of10.zip
========================================================================
3. Create Stage << R12.2: How To Create the Stage In Preparation For Installation (Doc ID 1596433.1) >>
cd /home/admin/Downloads/12.2.0/
unzip p22066363_R12_GENERIC.zip
cd /home/admin/Downloads/12.2.0/startCD/Disk1/rapidwiz/bin/
./buildStage.sh
Oracle E-Business Suite Rapid Install
Version 12.2.0
Press Enter to continue...
Build Stage Menu
--------------------------------------------------------
1. Create new stage area
2. Copy patches to existing stage area
3. List files in TechPatches directory
4. Exit menu
Enter your choice [4]: 1
Rapid Install Platform Menu
1. Oracle Solaris SPARC (64-bit)
2. Linux x86 (64-bit)
3. IBM AIX on Power Systems (64-bit)
4. HP-UX Itanium
5. Exit Menu
Enter your choice [5]: 2
Running command:
……………..........
Specify the directory containing the zipped installation media:
/ebssetupfiles/EBS1226/
File list:
/ebssetupfiles/EBS1226/startCD/Disk1/rapidwiz/bin/stageData/zipFiles.dat
Return to the Oracle Software Delivery Cloud and download them:
================================================================
Part number: V100053-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 1
File name: V100053-01_1of2.zip
================================================================
Part number: V100053-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 1
File name: V100053-01_2of2.zip
================================================================
Part number: V100054-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 2
File name: V100054-01.zip
================================================================
Part number: V100055-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 3
File name: V100055-01.zip
================================================================
Part number: V100056-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 4
File name: V100056-01.zip
================================================================
Part number: V100057-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 5
File name: V100057-01.zip
================================================================
Part number: V100058-01
Description:
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 6
File name: V100058-01.zip
================================================================
WARNING: Some of the required zip files have not yet been downloaded. Do you want to continue, and obtain them later? (Y)/N
Y
Since we are doing a fresh Install of R12.2 we do not require the files for VISION, so we can skip the above Warning message.
Note that: During creation of stage , enter to continue couple of times
========================================================================
4.Start E-Business Installation / EBS 12.2.0 installation
cd /home/admin/Downloads/12.2.0/startCD/Disk1/rapidwiz
./rapidwiz
Now follow the screens
Click on next
Click on next
Disable security updates via My Oracle Support and click on next button
Enter the Port values for both Filesystem1 and Filesystem2 and click on next
Enter the values and click on next
Choose the Suite licensing and click on next
Select the additional products and click on next
Select the additional products and click on next
Click on next
Choose the language and click on next
Enter the application node configuration details and click on next
Choose the Password and Click on next
Click on next
If we get Inventory related errors for database pre-install checks and/or for filesystems, fix them as documented below ;
Database Pre-installchecks;
Create oraInst.loc file and point it to the inventory location, which can be ORACLE_BASE directory.
ORACLE_HOME=/u01/oracle/CRP/12.1.0
ORACLE_BASE=/u01/oracle/CRP
So the orainventory should be in ora base directory
Example:
$ cat /etc/oraInst.loc
inventory_loc=/u01/oracle/CRP/oraInventory
inst_group=dba
For filesystem check error ;
chmod –R 777 /u01 (or any appropriate file permissions)
Click on next
Click on next
If we get the error for "Virtual directory" follow the below steps.
Error:
RW-50016: Error: - {0} was not created:
File = {1}
Solution
=======
To implement the solution please perform following:
1. Please check whether the following two rpms are present:
a. compat-libstdc++-33-3.2.3-69.el6.i686.rpm
b. compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm
2. If not install them and perform relink as below:
$ adrelink.sh force=y "fnd FNDWRR.exe"
Stop all application services
3. Retry rapidwiz and then your installation will get completed successfully
Click on next
After installation is completed we can connect to the EBS and check the version 12.2.0 and go for next step for 12.2.6 upgrade...
=============================================================================================
Run ETCC in both database tier and Application tier to get the list of required patches and apply.
5.PREPARING for 12.2.0 to 12.2.6 upgrade
APPLYING TECHNOLOGY PATCHES FOR 12.2.0 Oracle E-Business Suite Release 12.2.6 Readme Master Note
1 EBS Technology Codelevel Checker (ETCC) (Doc ID 1594274.1)
Note: This patch verifies the missing bugfixes which is not applied for db and middle tiers.
Download patch 17537119
Upload patch to DB and APP node
For DB Node :
mkdir –p $ORACLE_HOME/appsutil/etcc
copy all files in the patch to the directory “mkdir –p $ORACLE_HOME/appsutil/etcc”
cd $ORACLE_HOME/appsutil/etcc
./checkDBpatch.sh
Patch recommendation summary for Database
Patch 23595848
- Filename: p23595848_121020_Linux-x86-64.zip
Patch 18793246--
- Filename: p18793246_121020_Generic.zip
Patch 23745950--
- Filename: p23745950_121020_Linux-x86-64.zip
Patch 19591608
- Filename: p19591608_121020_Linux-x86-64.zip
Patch 19908836--
- Filename: p19908836_121020_Linux-x86-64.zip
Patch 24481723--
- Filename: p24481723_121020_Linux-x86-64.zip
Patch 22098146--
- Filename: p22098146_121020_Linux-x86-64.zip
Patch 21286665--
- Filename: p21286665_121020_Linux-x86-64.zip
Patch 21321429--
- Filename: p21321429_121020_Generic.zip
Patch 21387964--
- Filename: p21387964_121020_Linux-x86-64.zip
Patch 21864513--
- Filename: p21864513_121020_Linux-x86-64.zip
Patch 21904072--
- Filename: p21904072_121020_Linux-x86-64.zip
Patch 21967332
- Filename: p21967332_121020_Linux-x86-64.zip
Patch 22338374
- Filename: p22338374_121020_Linux-x86-64.zip
Patch 22496904--
- Filename: p22496904_121020_Linux-x86-64.zip
Patch 22731026--
- Filename: p22731026_121020_Generic.zip
Patch 23089357--
- Filename: p23089357_121020_Linux-x86-64.zip
Apply the above patches using opatch
Example:
export PATH=$PATH:$ORACLE_HOME/OPatch
To Check the patch:
opatch lsinventory | grep 19908836
cd 18793246
To Apply the Patch:
opatch apply
For APP Node :
cd <ETCC patchdirectory>
./checkMTpatch.sh
Patch recommendation summary
One or more products have bugfixes missing.
The default patch recommendations to install these missing bugfixes are:
Oracle Forms and Reports 10.1.2.3.0
Patch 22698265
- Filename: p22698265_101232_LINUX.zip
Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0
Patch 22288381
- Filename: p22288381_111190_Generic.zip
Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0
Patch 9905685
- Filename: p9905685_111190_Generic.zip
Patch 21366277
- Filename: p21366277_111190_Generic.zip
Patch 21628307
- Filename: p21628307_111190_Generic.zip
Oracle WebLogic Server (WLS) 10.3.6.0.7
Patch 20780171 [SU Patch [EJUW]: WLS PSU 10.3.6.0.12]
- Filename: p20780171_1036_Generic.zip
Patch 22323006 [SU Patch [DI8E]]
- Filename: p22323006_1036_Generic.zip
EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR 161018 AND 160719
CheckMTpatch Apply
Connecting to database.
Database connection successful.
Oracle Forms and Reports
1.unzip Patch file
2.set Oracle home
export Oracle Home = /u01/oracle/CRP/fs1/EBSapps/10.1.2.
3.set path
export PATH=$ORACLE_HOME/OPatch:$PATH
4.opatch lsinventory|grep 22698265
5.cd 22698265
6.opatch apply
Oracle Fusion Middleware (FMW) - Web Tier
1.unzip Patch file
2.set Oracle home
export Oracle Home = /u01/oracle/CRP/fs1/FMW_Home/webtier
3.set path
export PATH=$ORACLE_HOME/OPatch:$PATH
4.opatch lsinventory|grep 22288381
5.cd 22288381
6.opatch apply
Oracle Fusion Middleware (FMW) - oracle_common
1.unzip Patch file
2.set Oracle home
export Oracle Home = /u01/oracle/CRP/fs1/FMW_Home/oracle_common
3.set path
export PATH=$ORACLE_HOME/OPatch:$PATH
4.opatch lsinventory|grep 9905685
5.cd 9905685
6.cd oui
7.opatch apply
Oracle WebLogic Server (WLS)
1. copy file (20780171) to /u01/oracle/CRP/fs1/FMW_Home/util/bsu/cache_dir
2. unzip file (20780171)
3. check the .jar file
ls -ltr *.jar
4. cd /u01/oracle/CRP/fs1/FMW_Home/util/bsu
5. check the Display
echo$DISPLAY
echo$DISPLAY=:1:0
6 To apply the Patch
. ./bsu.sh -install -patch_download_dir=/u01/oracle/CRP/fs1/FMW_Home/utils/bsu/
cache_dir -patchlist=EJUW - prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3
7. To apply patches, first you have to apply patch number 20780171 but you may have conflict warning with the previous patches which has older PSU patches because 20780171 patch number is PSU 10.3.6.0.12 patch
Delete the files - YSAP,BLTC,1LRI,VKXF,2GYW,CWGT,FCX7
./bsu.sh -remove -patchlist=Y5AP -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose
./bsu.sh -remove -patchlist=BLTC -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose
./bsu.sh -remove -patchlist=1LRI -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose
./bsu.sh -remove -patchlist=VKXF -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose
./bsu.sh -remove -patchlist=2GYW -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose
./bsu.sh -remove -patchlist=CWGT -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose
./bsu.sh -remove -patchlist=FCX7 -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose
8. Once again apply
./bsu.sh -install -patch_download_dir=/u01/oracle/CRP/fs1/FMW_Home/utils/bsu/cache_dir - patchlist=EJUW -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3
9. Run ETCC again to get the patch list
13729611 [L34G]
17319481 [N5FK]
19259028 [TY4S]
19687084 [8FBW]
22128205 [GK5N]
22323006 [DI8E]
9. Download the above patch list
10.Unzip patches.
11.To install the the patches using following commands
bsu.sh -install -patch_download_dir=/u01/oracle/CRP/fs1/FMW_Home/utils/bsu/cache_dir - patchlist=L34G -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3
bsu.sh -install -patch_download_dir=/u01/oracle/CRP/fs1/FMW_Home/utils/bsu/cache_dir - patchlist=N5FK -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3
bsu.sh -install -patch_download_dir=/u01/oracle/CRP/fs1/FMW_Home/utils/bsu/cache_dir - patchlist=TYHS -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3
bsu.sh -install -patch_download_dir=/u01/oracle/CRP/fs1/FMW_Home/utils/bsu/cache_dir - patchlist=8FBW -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3
bsu.sh -install -patch_download_dir=/u01/oracle/CRP/fs1/FMW_Home/utils/bsu/cache_dir - patchlist=GK5N -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3
bsu.sh -install -patch_download_dir=/u01/oracle/CRP/fs1/FMW_Home/utils/bsu/cache_dir - patchlist=DI8E -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3
12. To check the MTpatchlist again run the following
./checkMTpatch.sh
Now you should get the message as "All required patches are present"
13. Download the Consolidated seed patches and AD C, TXK and Postpatches
Consolidated seed patches:
p17204589_12.2.0_R12_GENERIC.zip
p21900871_12.2.0_R12_GENERIC.zip
AD C.8 patches:
p21841299_R12.AD.C_R12_LINUX.zip
p24578455_R12.AD.C_R12_GENERIC.zip
p24494551_R12.AD.C_R12_GENERIC.zip
p25025325_R12.AD.C_R12_GENERIC.zip
TXK.C.8 patches:
p18525466_R12.TXK.C_R12_GENERIC.zip
p23569114_R12.TXK.C_R12_GENERIC.zip
p23705992_R12.TXK.C_R12_GENERIC.zip
14. All Downloaded files are moved to /u01/oracle/CRP/fs_ne/EBSapps/Patch
15. Unzip the patch files.
=============================================================================================
6.Apply Consolidated Seed Table Upgrade Patch (Required)
sh$ADMIN_SCRIPTS_HOME/adstpall.sh
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
adop phase=apply patches=17204589,21900871 merge=yes hotpatch=yes
Start up all application tier services.
=============================================================================================
Start up only the Oracle Weblogic Admin Server on the run edition application tier file system.
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
Run the adgrants.sql script as a user that can connect as SYSDBA to grant privileges to selected SYS objects and create PL/SQL profiler objects.
AD.C
Usage:
**** Patch 21841299 ****
1. Create $ORACLE_HOME/appsutil/admin on the database server.
2. Compare the version of adgrants.sql(UNIX) in $APPL_TOP/admin to that in patch directory.
3. Copy the higher version of adgrants.sql (UNIX) to
$ORACLE_HOME/appsutil/admin.
4. Set the environment to point to ORACLE_HOME on the database server.
5. Use SQL*Plus to run the script:
UNIX:
$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql<APPS schema name>
adop phase=apply patches=21841299 hotpatch=yes
Instructions for running AD Grants *** check adgrants in patch 24494551.
Run the adgrants.sql script as a user that can connect as SYSDBA to grant privileges to selected SYS objects and create PL/SQL profiler objects.
Usage:
1. Create $ORACLE_HOME/appsutil/admin on the database server.
2. Compare the version of adgrants.sql(UNIX) in $APPL_TOP/admin to that in patch directory.
3. Copy the higher version of adgrants.sql (UNIX) to
$ORACLE_HOME/appsutil/admin.
4. Set the environment to point to ORACLE_HOME on the database server.
5. Use SQL*Plus to run the script:
UNIX:
$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql<APPS schema name>
adop phase=apply patches=24578455,24494551,25025325 merge=yes
TXK C
adop phase=apply patches=21830810 hotpatch=yes
adop phase=apply patches=18525466,23569114,23705992 hotpatch=yes merge=yes
After applying this patch, update all Database Tier Nodes with the code level provided by this patch, by performing the following steps :
**** After applying the above Patch 23705992 ***
1. On the Application Tier (as the APPLMGR user):
. Run AutoConfig on the RUN file system.
Note:
Customers using the AutoConfig Customizations feature must merge any customizations with the AutoConfigtemplates provided via this patch before running AutoConfig.
. Source the environment variables for Oracle Applications
UNIX:
. ./<APPL_TOP>/APPS<CONTEXT_NAME>.env
. Execute admkappsutil.pl utility to create the file appsutil.zip
perl<AD_TOP>/bin/admkappsutil.pl
This will create appsutil.zip in <INST_TOP>/admin/out
Note:
For exact details on how to run Autoconfig and how to create appsutil.zip, please refer to the Oracle E-Business Suite Setup Guide for Release 12.2.
2. On the Database Tier (as the ORACLE user):
. Source the environment variables for RDBMS ORACLE_HOME
UNIX:
cd <RDBMS ORACLE_HOME>
. ./<RDBMS ORACLE_HOME>/<CONTEXT_NAME>.env
. Copy or FTP the appsutil.zip file to the <RDBMS ORACLE_HOME>
. Uncompress appsutil.zip under the <RDBMS ORACLE_HOME>
cd <ORACLE_HOME>
unzip -o appsutil.zip
3. Re-run adpreclone.pl on the database tier and on the primary node of the Application tier
Note:
Since new updates included in this patch have been applied to the system, adpreclone must be executed again in order to apply them into the clone directory structures used during cloning.
perl adpreclone.pl dbTier
perl adpreclone.pl appsTier
Migrate Latest Code to Database Tier
Update all database tier nodes with the latest code, by performing the following steps:
On the Application Tier (as the APPLMGR user):
Source the environment variables for Oracle E-Business Suite.
UNIX
$ . ./<APPL_TOP>/APPS<CONTEXT_NAME>.env
Execute the admkappsutil.pl utility to create the appsutil.zip file in <INST_TOP>/admin/out.
$ perl<AD_TOP>/bin/admkappsutil.pl
On the Database Tier (as the ORACLE user):
Source the environment variables for RDBMS ORACLE_HOME.
UNIX
$ cd <RDBMS ORACLE_HOME>
$ . ./<RDBMS ORACLE_HOME>/<CONTEXT_NAME> .env
Copy or FTP the appsutil.zip file to <RDBMS ORACLE_HOME>.
Uncompress appsutil.zip, under <RDBMS ORACLE_HOME>.
$ cd <ORACLE_HOME>
$ unzip -o appsutil.zip
Run AutoConfig on <RDBMS ORACLE_HOME>.
Note: For more details, refer to Oracle E-Business Suite Setup Guide, Release 12.2.
Run AutoConfig on the run file system.
On the Application Tier (as the APPLMGR user):
Run AutoConfig on the run file system.
Note: Before running AutoConfig, customers using the AutoConfig Customizations feature must merge any customizations with the AutoConfig templates provided via this patch.
Note: For exact details on how to run AutoConfig and how to create appsutil.zip, refer to the Oracle E-Business Suite Setup Guide, Release 12.2.
=============================================================================================
Apply the R12.2.6 upgrade patch
1.Source the run edition applications environment.
UNIX:
$.<INSTALL_BASE>/EBSapps.env run
2.Stop the Oracle Weblogic Admin Server and Node Manager services.
Applying the patch in downtime mode requires all application tier services to be down. Therefore, WeblogicAdminServer and Node Manager that were started previously when applying the latest Release Update Packs for AD and TXK for Release 12.2 need to be shut down.
a.Stop the Oracle Weblogic Admin Server on the run file system.
UNIX:
$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
b.Stop the Node Manager service on the run file system.
UNIX:
$ sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
3.Apply Oracle E-Business Suite 12.2.6 Release Update Pack Patch 21900901 on the run edition application environment, using downtime mode.
UNIX:
adop phase=apply apply_mode=downtime patches=21900901
4.Start all application tier services on the run file system.
UNIX:
sh $ADMIN_SCRIPTS_HOME/adstrtal.sh
FS_CLONE for filesystem cloning
5.Perform adop cleanup action.
UNIX:
adop phase=cleanup
6. Synchronize file systems
Synchronize the file systems using the command shown below. This action will copy the new run edition code and configuration to the other file system, to ensure that both file systems are in sync before applying patches using the regular adop cycle on the other file system.
UNIX:
adop phase=fs_clone
Apply Oracle E-Business Suite Release 12.2.6 Online Help Patch 21900918 using adophotpatch mode on the run file system.
adop phase=apply patches=21900918 hotpatch=yes
Cleaning Up A Failed Install Attempt
There is no rapidwiz -restart option available with R12.2 and hence once the installation fails then perform the below steps to clean up failed installation first. And then perform the installation.
A. Restart the server or make sure to kill ALL oracle and applmgr processes.
B. Delete the install directory, oraInventory and /tmp.
Note: If there are multiple EBS Instances or Oracle homes are present on server then central inventory needs to be cleaned up properly so that other existing environment should not get impacted. De-register Oracle homes first for the failed installation and then remove the install directory of failed installation. Also if some other process is running in /tmp directory then make sure that only process and files related to failed installation from /tmp directory needs to be deleted.
C. Run rapidwiz to start installation again.