R12.2 upgradation from R12.2.0 to R12.2.7

[Amar Jadhav]

Hi Emran,

Recently I have installed R12.2.0 on OEL 7.2 successfully .
This is not stable release . I want to upgrade to latest R2.2.7 .
Please guide me for the same. I can proceed for this.


Thanks

[ErmanArslansOracleBlog]

Follow "Oracle E-Business Suite Release 12.2.7 Readme (Doc ID 2230783.1)" , carefully and step by step.

[Amar Jadhav]

Hi Erman,

I have been following this mentioned doc .
Doc Step 4:Section 4: Apply Required Database Patches and Update Database Initialization Parameters---Completed
Doc Step 5: Section 5: Apply Consolidated Seed Table Upgrade Patch (Required)
     in this step i have tried to apply this patch  Patch 17204589 but got failed.

I am attaching all log file please suggest further action.adopapply.adopapplyu17204589.log

First log file suggest the session of adop phase=apply (this file conaitan adop -status after failing patch)
Second file is logfile of patch

What can i do now

[ErmanArslansOracleBlog]

Read this ->>!!

Note: If the Release 12.2.0 Vision or PROD instance (New Installation) was created using startCD 12.2.0.51 (Patch 22066363), you must apply Consolidated Seed Table Upgrade Patch 17204589:12.2.0 by merging with Patch 21900871:12.2.0 on the run file system using adop hotpatch mode.

$ adop phase=apply patches=17204589,21900871 merge=yes hotpatch=yes

[Amar Jadhav]

HI Erman,

Thanks I have applied patch now.
before I go for AD or TXK 10 patch
I need to install below patch.

This AD-TXK codelevel has a dependency on Oracle Fusion Middleware:

    11.1.1.6: Patch 20642039----> but his patch i am not able to apply to FMW_HOME  /u02/apps/PROD/fs1/FMW_Home/oracle_common.
   
 11.1.1.7: Patch 20756887

any suggestion

[Amar Jadhav]

[applmgr@node1 20642039]$ opatch apply
Java HotSpot(TM) 64-Bit Server VM warning: You have loaded library /u02/apps/PROD/fs1/EBSapps/10.1.2/oui/lib/linux/liboraInstaller.so which might have disabled stack guard. The VM will try to fix the stack guard now.
It's highly recommended that you fix the library with 'execstack -c <libfile>', or link it with '-z noexecstack'.
java.lang.UnsatisfiedLinkError: /u02/apps/PROD/fs1/EBSapps/10.1.2/oui/lib/linux/liboraInstaller.so: /u02/apps/PROD/fs1/EBSapps/10.1.2/oui/lib/linux/liboraInstaller.so: wrong ELF class: ELFCLASS32 (Possible cause: architecture word width mismatch)
        at java.lang.ClassLoader$NativeLibrary.load(Native Method)
        at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1941)
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1824)
        at java.lang.Runtime.load0(Runtime.java:809)
        at java.lang.System.load(System.java:1086)
        at oracle.sysman.oii.oiip.osd.unix.OiipuUnixOps.loadNativeLib(OiipuUnixOps.java:372)
        at oracle.sysman.oii.oiip.osd.unix.OiipuUnixOps.<clinit>(OiipuUnixOps.java:119)
        at oracle.sysman.oii.oiip.oiipg.OiipgEnvironment.ssgetUidux(OiipgEnvironment.java:520)
        at oracle.sysman.oii.oiix.OiixEnvironmentOps.ssgetUidux(OiixEnvironmentOps.java:163)
        at oracle.opatch.OUIReplacer.isRootAccess(OUIReplacer.java:614)
        at oracle.opatch.OPatch.process(OPatch.java:620)
        at oracle.opatch.OPatch.main(OPatch.java:871)

OPatch failed with error code 255
[applmgr@node1 20642039]$ opatch apply -jre $ORACLE_HOME/jdk/jre
Java HotSpot(TM) Server VM warning: You have loaded library /u02/apps/PROD/fs1/EBSapps/10.1.2/oui/lib/linux/liboraInstaller.so which might have disabled stack guard. The VM will try to fix the stack guard now.
It's highly recommended that you fix the library with 'execstack -c <libfile>', or link it with '-z noexecstack'.

OPatch Version : 12.2.0.1.10
  OUI  Version : 10.1.0.6.0
The OPatch version is not applicable for current OUI version.

OPatch failed with error code 19
[applmgr@node1 20642039]$

[Amar Jadhav]

How can i match OPATCH and OUI version

[ErmanArslansOracleBlog]

Are you appyling this to correct oracle home?
As I see, you are trying to apply it to 10.1.2 Oracle home, but the patch is for FMW.
Set your env correctly and then apply the patch using opatch.
You need to have correct ORACLE_HOME and PATH set before applying to your Oracle Home.

----
Set ORACLE_HOME to the required FMW Oracle Home.
For example:
$ export ORACLE_HOME = $FMW_HOME/oracle_common
Include $ORACLE_HOME/OPatch in the PATH.

Run the command:
$ opatch lsinventory

ensure you are seeing the correct oracle home..
Then use opatch to apply the aptch.

[Amar Jadhav]

I am not able to apply patch fusion middleware

 11.1.1.6: Patch 20642039
    11.1.1.7: Patch 20756887

above patch i want to apply . please suggest
how can i set oracle home , opatch dire loc

[ErmanArslansOracleBlog]

I already gave you an example above. Read my previous reply.

[Amar Jadhav]

Thanks, Now it is showing below status

[applmgr@node1 20642039]$ opatch version
OPatch Version: 11.1.0.12.9

OPatch succeeded.
[applmgr@node1 20642039]$ opatch apply
Oracle Interim Patch Installer version 11.1.0.12.9
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


Oracle Home       : /u02/apps/PROD/fs1/FMW_Home/oracle_common
Central Inventory : /u03/oraInventory
   from           : /u02/apps/PROD/fs1/FMW_Home/oracle_common/oraInst.loc
OPatch version    : 11.1.0.12.9
OUI version       : 11.1.0.11.0
Log file location : /u02/apps/PROD/fs1/FMW_Home/oracle_common/cfgtoollogs/opatch/20642039_Nov_03_2017_12_00_41/apply2017-11-03_12-00-41PM_1.log


OPatch detects the Middleware Home as "/u02/apps/PROD/fs1/FMW_Home"

Applying interim patch '20642039' to OH '/u02/apps/PROD/fs1/FMW_Home/oracle_common'
Verifying environment and performing prerequisite checks...
OPatch system modification phase did not start:
Patch "20642039" is not needed since it has no fixes for this Oracle Home. Please see log file for details.
Log file location: /u02/apps/PROD/fs1/FMW_Home/oracle_common/cfgtoollogs/opatch/20642039_Nov_03_2017_12_00_41/apply2017-11-03_12-00-41PM_1.log

OPatch stopped on request.

[Amar Jadhav]

Second patch I am getting below issues


[applmgr@node1 20642039]$ opatch version
OPatch Version: 11.1.0.12.9

OPatch succeeded.
[applmgr@node1 20642039]$ opatch apply
Oracle Interim Patch Installer version 11.1.0.12.9
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


Oracle Home       : /u02/apps/PROD/fs1/FMW_Home/oracle_common
Central Inventory : /u03/oraInventory
   from           : /u02/apps/PROD/fs1/FMW_Home/oracle_common/oraInst.loc
OPatch version    : 11.1.0.12.9
OUI version       : 11.1.0.11.0
Log file location : /u02/apps/PROD/fs1/FMW_Home/oracle_common/cfgtoollogs/opatch/20642039_Nov_03_2017_12_00_41/apply2017-11-03_12-00-41PM_1.log


OPatch detects the Middleware Home as "/u02/apps/PROD/fs1/FMW_Home"

Applying interim patch '20642039' to OH '/u02/apps/PROD/fs1/FMW_Home/oracle_common'
Verifying environment and performing prerequisite checks...
OPatch system modification phase did not start:
Patch "20642039" is not needed since it has no fixes for this Oracle Home. Please see log file for details.
Log file location: /u02/apps/PROD/fs1/FMW_Home/oracle_common/cfgtoollogs/opatch/20642039_Nov_03_2017_12_00_41/apply2017-11-03_12-00-41PM_1.log

OPatch stopped on request.

[ErmanArslansOracleBlog]

It says : 20642039" is not needed since it has no fixes for this Oracle Home.

How did you decide to apply this patch?
The relevant Oracle Home of yours may already have this patch installed.
Did you check that?

[Amar Jadhav]

yes i was verified . oparch lsinventory|grep <patch no> but this did not showned status. then i gone to aaply this patch

. Now I applied next patch
adop phase=apply patches=25820806,26720905 merge=yes hotpatch=yes  AD,TXK but this is also failing.

what action should i perform.


[applmgr@node1 ~]$ adop -status -details


Enter the APPS password:
Enter the APPS password:
Connected.
==============================================================
Session Id: 2
Command: status
Output: /u02/apps/PROD/fs_ne/EBSapps/log/adop/2/20171104_095353/adzdshowstatus.out
===============================================================


File System Synchronization Type: None




Generating full adop status report: /u02/apps/PROD/fs_ne/EBSapps/log/adop/2/20171104_095353/adzdshowstatus.out

adop exiting with status = 0 (Success)
[applmgr@node1 ~]$

[ErmanArslansOracleBlog]

You are confusing..

don't skip patches..

If you have a problem, describe it with the details and send me the output and log.. (showing the error)

for ex: what do you mean by "yes i was verified . opatch lsinventory|grep <patch no> but this did not showned status." ?? -- send me the output when you are asking something about a failing command..

Maybe you are trying to apply it to a wrong Oracle Home... or maybe you are applying a patch which is written for a different version Oracle Home...

Where did you find this patch? Send me the reference document .