Implementation

High level Steps Involved to do the R12.2.6 Fresh Implementation upgrade steps are:

Install R12.2.0 with 12c Database

1. Download EBS Installation Packages, Oracle E-Business Suite (12.2.0)

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...

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

At this point, EBS 12.2.0 installation is complete, so we continue with the EBS 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

we removed the below patches using following commands

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.

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

Upgrade to AD.C.8 and TXK.C.8

7.Apply the R12.AD.C.Delta.8 and R12.TXK.C.Delta.8 Release Update Packs

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

8. Apply Oracle E-Business Suite 12.2.6 Release Update Pack

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 the Help patch.

9.Post-Update Steps

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.