Apply the Latest AD and TXK Release Update Packs for Release 12.2
Ugrading 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
