upgrade from 12.1.3 to R12.2. on solaris 10

[syed raza]

Hi Emran,
I am upgrading EBS R12.1.3 to R12.2
I am already upgrade the db from 11.2.0.4 to 12c and apply all ETCC patches on db tier. And after that install the 12.2 application in upgrade mode for creating the xml file.While upgrading the main drivers file i am facing the issue
STRT_TASK: [Prereq checking logic] [] [Sun Jan 14 2018 01:36:30]

For the Current View:
   l_appl_top_id .............. 5233
   l_eav_patch_release_name ... 12.0.0

AutoPatch error:
Error while executing statement

AutoPatch error:
ORA-04063: package body "APPS.AD_ZD" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.AD_ZD"
ORA-06512: at "APPS.AD_FILE_SYS_SNAPSHOTS_PKG", line 58
ORA-06512: at "APPS.AD_PATCH", line 95
ORA-06512: at line 3


AutoPatch error:
Error calling adpcdlvlIsPatchApplied


AutoPatch error:
--------
A fatal error related to codelines or codelevels has occurred.

See messages above for details.
--------

 Freeing includes hash table
Freeing fixes hash table
 Freeing basedons hash table
Freeing entities hash table

so please help me

[syed raza]

SQL> show errors
Errors for PACKAGE BODY AD_ZD:

LINE/COL ERROR
-------- -----------------------------------------------------------------
927/3    PL/SQL: Statement ignored
927/51   PLS-00302: component 'C_PHASE_ABORT' must be declared

[ErmanArslansOracleBlog]

Did you check this note? -> After Installation of Patch 20745242 During Database Upgrade From 11.2.0.3 to 12c Autoconfig on the Apps Tier Fails with ORA-04063: Package Body "APPS.AD_ZD_ADOP" Has Errors (Doc ID 2114302.1)

[syed raza]

Hi Emran,
But that doc is for upgrading db 11.2.0.3 to 12c for R12.2
and i am upgrading db from 11.2.0.4 to 12c in 12.1.3 environment and after that i am try to upgradge application from R12.1.3 to R12.2. at that time i am facing this issue

[ErmanArslansOracleBlog]

Concantrate on the solutions documented in that document..

2 things the check...

Follow and Update me ->

1. If instance is already at R12.AD.C.DELTA.7 BUNDLE II and package body APPS.AD_ZD_ADOP is invalid, confirm the readme was followed along with the Delta 7 Installation Notes when Patch 20745242 and Patch 22123818 were applied.

2. If not you may need to run adgrants located in $APPL_TOP/admin directory or in the following directory for Patch 22123818:

Please run the adgrants.sql with the highest version between the two directories.

  22123818/admin adgrants.sql

3. Note: The adgrants script should be copied to your database $ORACLE_HOME/appsutil/admin directory and run as SQLDBA with the APPS schema name passed as a parameter, as indicated in the README.

[syed raza]

Hi Emran,
After db upgrade and applying all the patches in ETCC on db side just install the R12.2. and apply the preinstall patches and now apply the main upgrade patch and that patch is fail

[syed raza]

Hi EMRAN,
IF i miss some preinstall patches and apply the main upgrade patch so at that situation can we apply the preinstall patch again and after that apply the main upgrade patch after merge it or we can do the fresh clone do the same activity again .
and currently in my environment i am using the two more languages one is polish and latin american spanish so after upgrade we can enable this languages and apply the patch corresponding patches  

[ErmanArslansOracleBlog]

It depens on the patch and the situation..

If you are doing a critical upgrade, I would suggest you doing it from scratch.

You skipped some actions(prereq or postreq), right?

[syed raza]

Hi ERMAN, First of all thanks for your fast reply and writing a book in R12.2. i.e Practical oracle E-Business Suite i must say you do a wonderful jobs and every apps dba have this book in his library.

[ErmanArslansOracleBlog]

Thanks for your feedback Syed.

[syed raza]

Hi Emran,
Now my db is upgraded 12.1.0.2 and application is 12.1.3 when i ran the ETCC on my db side it shows me around 29 db patches can i apply this patches with one opatch command . i.e opatch napply -id and patch numbers and do post patch after that i.e datapatch only once

[ErmanArslansOracleBlog]

I don't the patches listed by ETCC and I didn't read their readmes... So I find it a little bit risky..
Anways, I usually don't use napply for patching the DB home for EBS upgrades.
But, why don't you install the latest PSU to your database tier first?
Latest PSU will deliver lots of bug fixes and that list with the 29 patch items, will be shorten after it.

[syed raza]

Hi Emran,
Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1) how to apply the patches can you please explain,
Prerequisite: Apply the AD Upgrade Patch for Release 12.2 (Patch 10117518) by merging it with the latest Consolidated Upgrade Patch (CUP) for AD (Patch 24690501:R12.AD.C).

    The AD Upgrade Patch for Release 12.2 (Patch 10117518) readme contains information about the latest Consolidated Upgrade Patch (CUP) for AD (Patch 24690501:R12.AD.C).
    You must follow the Patch 10117518 readme and apply it by merging it with the latest Consolidated Upgrade Patch for AD, along with any other patches mentioned in the Readme, as instructed in the readme and by referring to the Upgrade Guides.

Apply the Consolidated Upgrade Patch (CUP) for Release 12.2.0 (Patch 24690520:12.2.0) in pre-installation mode on the Run Edition File System.

Note: Before applying Patch 24690520:12.2.0 for the latest CUP in pre-installation mode:

If you have applied any other patch previously in pre-installation mode and do not intend to merge it with 12.2.0 upgrade driver u10124646.drv, clean up the directory <APPL_TOP>/admin/<TWO_TASK>/preinstall on run file system after taking the backup of the current directory.
$ adpatch preinstall=y

    Apply the pre-upgrade patches that were released after the Consolidated Upgrade Patch 24690520:12.2.0.

    Refer to My Oracle Support Knowledge Document 1448102.2 for the Oracle E-Business Suite Release 12.2 Pre-install Patches Report; it provides a list of essential patches that you must apply in pre-install mode before upgrading from Release 11i/12.0/12.1 to Release 12.2. Follow the recommendations within My Oracle Support Knowledge Document 1448102.2 and apply the additional pre-install patches.

    Individual pre-install patches that are listed in the Oracle E-Business Suite Release 12.2 Pre-install Patches Report can be merged with Consolidated Upgrade Patch 24690520:12.2.0 and applied together.

Merge the patch drivers in $APPL_TOP/admin/$TWO_TASK/preinstall directory with the 12.2.0 upgrade driver $AU_TOP/patch/115/driver/u10124646.drv

Note: All of the patch driver files located under $APPL_TOP/admin/<TWO_TASK>/preinstall are merged with the 12.2.0 upgrade driver <AU_TOP>/patch/115/driver/u10124646.drv. Therefore, carefully evaluate the content of the directory - <APPL_TOP>/admin/<TWO_TASK>/preinstall and retain only those patch drivers including u22742071.drv ; it is intended to be merged with 12.2.0 upgrade driver - u10124646.drv

Merging patch drivers in run file system's <APPL_TOP>/admin/<TWO_TASK>/preinstall with <AU_TOP>/patch/115/driver/u10124646.drv:

    Change directory to <AU_TOP>/patch/115/driver
    $ cd $AU_TOP/patch/115/driver
    $ admrgpch -d . -preinstall -master u10124646.drv


The above we i am confusing about the note
Patch 10117518
is merge with patch#24690501:R12.AD.C) and 26321002:R12.AD.C
After running the adgrants.sql
we have to merge above three patches and apply it
Then according to 10117518 patch readme  apply critical patch 6767273:R12.AD.A

may i right then
24690520:12.2.0
then apply the above patch with preinstall mode
and after that from Document 1448102.2
we have to apply all the patches in preinstall mode and then finally we have to merge with master american patch

[ErmanArslansOracleBlog]

I couldn't understand your question.
Don't copy paste the contents of the documents here. It makes your comments messy.
Please be more specific and clearly ask your question by revising your explanations.

[syed raza]

Hi Emran,
Sorry for the messy
Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1) how to apply the patches can you please explain

[syed raza]

Hi Emran,
 Document 1448102.2 appl patches with cup8 a applied in preinstall mode then Merge the patch drivers in $APPL_TOP/admin/$TWO_TASK/preinstall directory with the 12.2.0 upgrade driver $AU_TOP/patch/115/driver/u10124646.drv

 2 unified drivers merged.

Patch merge completed successfully

but in that note

Note: All of the patch driver files located under $APPL_TOP/admin/<TWO_TASK>/preinstall are merged with the 12.2.0 upgrade driver <AU_TOP>/patch/115/driver/u10124646.drv. Therefore, carefully evaluate the content of the directory - <APPL_TOP>/admin/<TWO_TASK>/preinstall and retain only those patch drivers including u22742071.drv ; it is intended to be merged with 12.2.0 upgrade driver - u10124646.drv
why u22742071.drv  cup 7 patch mention it will confuse

[ErmanArslansOracleBlog]

Well.. Now, I understand what you are talking about..

It seems like there is a documentation bug..
You need to go with 24690520..
The line with 22742071 should be ignored. It should be 24690520.

22742071 is superseded by 24690520 anyways.

[syed raza]

Hi Emran ,
While running the American upgrade drivers one worker is failed
sqlplus -s APPS/***** @/app/oracle/PROD/apps/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/app/oracle/PROD/apps/fs1/EBSapps/appl/pos/12.0.0/patch/115/sql/POSCREATENTRPRS.sql '
Connected.

PL/SQL procedure successfully completed.

declare
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.POS_PARTY_MANAGEMENT_PKG", line 172
ORA-06512: at line 53

[ErmanArslansOracleBlog]

This is unexpected and undocumented.

How did you end up with this?
What  documents & steps did you follow?

[syed raza]

        Error on POSCREATENTRPRS.sql When Applying Maintenance Pack (Doc ID 392530.1) To BottomTo Bottom