Apply the Latest AD and TXK Release Update Packs for Release 12.2
Beauty_and_dBest Apr 11, 2019 9:11 AMUgrading 12.0.6 to 12.2.7
Db is already 12.1.0.2
Hi ALL,
We have finished installing 12.2.0
We are now in steps:
Preparation steps to Upgrade EBS 12.2.0 to 12.2.7
Set the following database parameter,
SQL> alter system set optimizer_adaptive_features=false;
Run adgrants.sql and recreate grants and synonyms
Execute adgrants.sql from patch 27405878 and then recreate grants and synonyms from adadmin (Choose option 4 and then 2 from adadmin)
(Source RUN file system env)
Apply the Latest AD and TXK Release Update Packs for Release 12.2:
Upgrade AD to latest code level (R12.AD.C.Delta.10),
Patch 25820806 (R12.AD.C.Delta.10)
Patch 26720905:R12.AD.C
$ cd /crpapp/crp/apps/fs_ne/EBSapps/patch
$ unzip /crpapp/patches/patches_1227_prereq/p25820806_R12.AD.C_R12_LINUX.zip
$ unzip /crpapp/patches/patches_1227_prereq/p26720905_R12.AD.C_R12_GENERIC.zip
Apply both AD patches
Start adminserver from run fs
$ cd $ADMIN_SCRIPTS_HOME
$ adadminsrvctl.sh start
Apply AD patches separately,
$ cd /crpapp/crp/apps/fs_ne/EBSapps/patch
$ adop phase=apply patches=25820806 hotpatch=yes
$ adop phase=apply patches=26720905 hotpatch=yes
Patch 25820806 is successful, but patch 26720905 has error
[applmgr@oraapps UPGRADE_PATCH_APP]$ adop phase=apply patches=26720905 hotpatch=yes patchtop=/mnt/UPGRADE_PATCH_APP
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /mnt/applmgr/PPAPROD/fs1/inst/apps/PPAPROD_oraapps/appl/admin/PPAPROD_oraapps.xml
Patch edition context: /mnt/applmgr/PPAPROD/fs2/inst/apps/PPAPROD_oraapps/appl/admin/PPAPROD_oraapps.xml
*******FATAL ERROR*******
PROGRAM : (/mnt/applmgr/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME : Thu Apr 11 16:52:25 2019
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
MESSAGES:
SQLPLUS error: buffer=
SQL*Plus: Release 10.1.0.5.0 - Production on Thu Apr 11 16:52:25 2019
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> SQL> Connected.
SQL> from fnd_nodes fn, adop_valid_nodes avn
*
ERROR at line 3:
ORA-00942: table or view does not exist
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
STACK TRACE
at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168
TXK::Error::abort('TXK::Error', 'HASH(0x1a45e68)') called at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299
TXK::Common::doError('TXK::SQLPLUS=HASH(0x3eeb558)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...', undef) called at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314
TXK::Common::setError('TXK::SQLPLUS=HASH(0x3eeb558)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...') called at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 832
TXK::SQLPLUS::_doExecute('TXK::SQLPLUS=HASH(0x3eeb558)', 0) called at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 234
TXK::SQLPLUS::execute('TXK::SQLPLUS=HASH(0x3eeb558)', 'HASH(0x42475b8)') called at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 618
TXK::TechstackDB::_getSQLValue('TXK::TechstackDB=HASH(0x3a57678)', ' select count(1) from\x{a} ( select distinct fn.host\x{a} ...') called at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 573
TXK::TechstackDB::getSQLValue('TXK::TechstackDB=HASH(0x3a57678)', ' select count(1) from\x{a} ( select distinct fn.host\x{a} ...') called at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 1219
ADOP::GlobalVars::_GetMandatoryArgs() called at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 3112
ADOP::GlobalVars::ValidateArgs('ADOP::GlobalVars') called at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/AdopMain.pm line 1842
ADOP::AdopMain::adopMain('ADOP::AdopMain') called at /mnt/applmgr/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl line 148
[STATEMENT] Please run adopscanlog utility, using the command
"adopscanlog -latest=yes"
$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 11 17:09:07 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select * from dba_objects where object_name = 'ADOP_VALID_NODES';
no rows selected
SQL>
Please help....
Kind regards,
jc