Document: Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
Step - 1 Source Apps
Environment and Start Adadmin Server
$ cd
/u01/install/patches/apps/ad_txk_patches
$ cd
/u01/applmgr/upg/fs_ne/EBSapps/patch/26834480/admin
adgrants_nt.sql adgrants.sql
adgrants.sql
$ sqlplus /nolog
SQL> @adgrants.sql APPS
Step - 4 Apply AD Patch 26834480
Enter the SYSTEM password: manager
Enter the WLSADMIN password: Oracle_123
Enter the SYSTEM password: manager
Enter the WLSADMIN password: Oracle_123
TXK Error & Solution
###################################################################################-------------------------------------------- ERROR --------------------------------------------
###################################################################################sqlplus -s APPS/apps @/u01/applmgr/upg/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/applmgr/upg/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/ADZDWRKR.sql apps manager CUTOVER 0 7 12'
Connected.
PL/SQL procedure successfully completed.
Connected.
Session altered.
PL/SQL procedure successfully completed.
declare
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SESSION", line 122
ORA-06512: at "APPS.AD_ZD_CTX", line 7
ORA-06512: at "APPS.AD_ZD_PARALLEL_EXEC", line 538
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SESSION", line 122
ORA-06512: at "APPS.AD_ZD_CTX", line 7
ORA-06512: at "APPS.AD_ZD_PARALLEL_EXEC", line 524
ORA-01031: insufficient privileges
ORA-06512: at line 16
###################################################################################------------------------------------------- SOLUTION -------------------------------------------
###################################################################################[oracle@upgebs sql]$ source /u01/applmgr/upg/fs1/EBSapps/appl/APPSDELL_upgebs.env
[oracle@upgebs sql]$ sqlplus apps/apps
SQL> set lines 250 pages 250
SQL> col NAMESPACE format a15
SQL> col SCHEMA format a15
SQL> col PACKAGE format a20
SQL> run
1* select * from dba_context where namespace='AD_ZD_CTX'
NAMESPACE SCHEMA PACKAGE TYPE
--------------- --------------- -------------------- ----------------------
AD_ZD_CTX APPLSYS AD_ZD_CTX ACCESSED LOCALLY
SQL> create or replace context AD_JAR using AD_JAR;
Context created.
SQL> create or replace context AD_ZD_CTX using AD_ZD_CTX;
Context created.
SQL> select * from dba_context where namespace='AD_ZD_CTX';
NAMESPACE SCHEMA PACKAGE TYPE
--------------- --------------- -------------------- ----------------------
AD_ZD_CTX APPS AD_ZD_CTX ACCESSED LOCALLY
[oracle@upgebs log]$ sqlplus -s APPS/apps @/u01/applmgr/upg/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/applmgr/upg/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/ADZDWRKR.sql apps manager CUTOVER 0 7 12'
PL/SQL procedure successfully completed.
Connected.
Session altered.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Note: Before Apply TXK you will must apply above solution.
Step - 6 Unzip TXK Main Patches & Others Critical Patches
$ unzip -o p28840822_R12.TXK.C_R12_GENERIC.zip
$ unzip -o p29965377_R12.TXK.C_R12_GENERIC.zip
$ unzip -o p29781255_R12.TXK.C_R12_GENERIC.zip
$ unzip -o p28371446_R12.TXK.C_R12_GENERIC.zip
Step - 7 Apply TXK Main & Others Critical Patches with Merge Option
$ adop phase=apply patches=28840822,29965377,29781255,28371446 hotpatch=yes merge=yes
Enter the APPS password: apps
Enter the SYSTEM password: manager
Enter the WLSADMIN password: Oracle_123
Step -8 Source the run edition environment file
$ cd /u01/applmgr/upg/
$ ls
EBSapps.env fs1 fs2 fs_ne
$ source EBSapps.env run
E-Business Suite
Environment Information
----------------------------------------
RUN File
System :
/u01/applmgr/upg/fs1/EBSapps/appl
PATCH File
System :
/u01/applmgr/upg/fs2/EBSapps/appl
Non-Editioned File System : /u01/applmgr/upg/fs_ne
DB Host:
upgebs.hinopak.com Service/SID: DELL
Sourcing the RUN File System ...
Step -9 Stop the Oracle Weblogic Server Admin Server on the run file system
$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
Enter the WebLogic Admin password: Oracle_123
Enter the APPS Schema password: apps
Step -10 Update Database Tier to Latest Code
A- Source the run edition environment file.
$ cd /u01/applmgr/upg/
$ source EBSapps.env run
B- Execute the admkappsutil.pl utility to create the appsutil.zip file in $INST_TOP/admin/out.
$
perl $AD_TOP/bin/admkappsutil.pl
$ source /u02/oracle/db/tech_st/12.1.0/DELL_upgebs.env
$ cd $ORACLE_HOME
$ unzip -o appsutil.zip
$ sh $ORACLE_HOME/appsutil/scripts/<CONTEXT_NAME>/adautocfg.sh
D- Source Apps Environment & Run AutoConfig on the run file system
AD TXK Completed
No comments:
Post a Comment