adop error while upgrade from EBS 12.2.0 TO 12.2.4
Locked
adop error while upgrade from EBS 12.2.0 TO 12.2.4
 
|
Hi Erman;
I am upgrading EBS 12.2.0 to 12.2.4..All ETCC bug fixes successfully applied and check but when i applied Consolidated seed table upgrade patch on run file in hotpatch mode i found this error. oracle@erp1 scripts]$ adop phase=apply patches=17204589 hotpatch=yes Enter the APPS password: Enter the SYSTEM password: Enter the WLSADMIN password: Please wait. Validating credentials... Enter the RUN file system context file name [/u01/oracle/PROD/fs1/inst/apps/PROD_erp1/appl/admin/PROD_erp1.xml]: [STATEMENT] [END 2018/06/21 01:01:56] Performing verification of parameters [STATEMENT] [START 2018/06/21 01:01:57] Checking for the required ENV setup [STATEMENT] [END 2018/06/21 01:01:57] Checking for the required ENV setup *********** Start of session *********** version: 12.2.0 started at: Thu Jun 21 2018 01:01:57 APPL_TOP is set to /u01/oracle/PROD/fs1/EBSapps/appl [STATEMENT] [START 2018/06/21 01:01:58] Determining admin node [STATEMENT] [END 2018/06/21 01:02:01] Determining admin node [STATEMENT] Recommended Worker Count: 2 Max Allowed Workers: 9 [STATEMENT] [START 2018/06/21 01:02:06] Acquiring lock on sessions table [STATEMENT] [END 2018/06/21 01:02:08] Acquiring lock on sessions table [STATEMENT] [START 2018/06/21 01:02:08] Checking for any pending sessions [STATEMENT] [START 2018/06/21 01:02:15] Staging the current session [STATEMENT] [START 2018/06/21 01:02:21] Checking if node "erp1" is abandoned [STATEMENT] [END 2018/06/21 01:02:23] Checking if node "erp1" is abandoned [STATEMENT] [END 2018/06/21 01:02:26] Staging the current session [STATEMENT] [START 2018/06/21 01:02:29] Unlocking sessions table [STATEMENT] [END 2018/06/21 01:02:31] Unlocking sessions table [STATEMENT] [START 2018/06/21 01:02:31] adzdoptl.pl run [STATEMENT] Session ID: 2 [STATEMENT] Phase: apply [STATEMENT] Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/adop_20180621_010126.log [STATEMENT] [START 2018/06/21 01:02:45] Invoking admerge [STATEMENT] [END 2018/06/21 01:02:46] Invoking admerge [STATEMENT] [START 2018/06/21 01:02:47] apply phase [STATEMENT] APPLY Phase START TIME: 21-06-2018 01:02:49 [STATEMENT] [START 2018/06/21 01:02:52] Performing Check for Logon Trigger existence and enablement [STATEMENT] [END 2018/06/21 01:02:55] Performing Check for Logon Trigger existence and enablement sh: module: line 1: syntax error: unexpected end of file sh: error importing function definition for `module' [STATEMENT] [Start 2018/06/21 01:03:00] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop [STATEMENT] Reading defaults file /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt [STATEMENT] Substituting tokens ... [STATEMENT] Regenerating defaults file ... [STATEMENT] [End 2018/06/21 01:03:01] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop [STATEMENT] Calling: adpatch workers=2 options=hotpatch flags=autoskip console=no interactive=no defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs_ne/EBSapps/patch/17204589 driver=u17204589.drv logfile=u17204589.log [STATEMENT] ADPATCH Log directory: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20180621_010126/PROD_erp1/17204589/log [STATEMENT] Running: adpatch workers=2 options=hotpatch flags=autoskip console=no interactive=no defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs_ne/EBSapps/patch/17204589 driver=u17204589.drv logfile=u17204589.log stdin=yes sh: module: line 1: syntax error: unexpected end of file sh: error importing function definition for `module' Successfully created out directory [STATEMENT] [START 2018/06/21 01:40:33] Running finalize since in hotpatch mode [STATEMENT] [START 2018/06/21 01:46:25] Unlocking sessions table [STATEMENT] [END 2018/06/21 01:46:27] Unlocking sessions table ******FATAL ERROR****** PROGRAM : (/u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl) TIME : Thu Jun 21 01:46:21 2018 FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ] MESSAGES: SQLPLUS error: buffer= SQL*Plus: Release 10.1.0.5.0 - Production on Thu Jun 21 01:40:36 2018 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> SQL> Connected. SQL> begin * ERROR at line 1: ORA-20001: Error: while calling ad_zd.finalize .ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 8 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 /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168 TXK::Error::abort('TXK::Error', 'HASH(0x90ff68)') called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299 TXK::Common::doError('TXK::SQLPLUS=HASH(0x1ed3fe8)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...', undef) called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314 TXK::Common::setError('TXK::SQLPLUS=HASH(0x1ed3fe8)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...') called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 832 TXK::SQLPLUS::_doExecute('TXK::SQLPLUS=HASH(0x1ed3fe8)', 0) called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 234 TXK::SQLPLUS::execute('TXK::SQLPLUS=HASH(0x1ed3fe8)', 'HASH(0x1a786a8)') called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 618 TXK::TechstackDB::_getSQLValue('TXK::TechstackDB=HASH(0x18cf7f0)', ' begin\x{a} ad_zd.finalize;\x{a} exception\x{a} w...') called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 573 TXK::TechstackDB::getSQLValue('TXK::TechstackDB=HASH(0x18cf7f0)', ' begin\x{a} ad_zd.finalize;\x{a} exception\x{a} w...') called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/Phase.pm line 262 ADOP::Phase::executeSQL('ADOP::ApplyPhase=HASH(0x1499c98)', ' begin\x{a} ad_zd.finalize;\x{a} exception\x{a} w...') called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/ApplyPhase.pm line 579 ADOP::ApplyPhase::runAutopatch('ADOP::ApplyPhase=HASH(0x1499c98)', 2) called at /u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl line 421 main::executePhaseSequence() called at /u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl line 863 main::adopMain() called at /u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl line 872 adop exiting with status = 255 (Fail) |
Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4
Administrator
|
This is a duplicate issue.
Please continue from -> http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Adop-error-td6234.html |
Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4
|
|
I run adgrants.sql script and perform steps below this link which you provide me.
http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Adop-error-td6234.html [oracle@erp1 scripts]$ adop phase=apply patches=17204589 hotpatch=yes abandon=yes Enter the APPS password: Enter the SYSTEM password: Enter the WLSADMIN password: Please wait. Validating credentials... Enter the RUN file system context file name [/u01/oracle/PROD/fs1/inst/apps/PROD_erp1/appl/admin/PROD_erp1.xml]: [STATEMENT] [END 2018/06/25 00:00:10] Performing verification of parameters [STATEMENT] [START 2018/06/25 00:00:11] Checking for the required ENV setup [STATEMENT] [END 2018/06/25 00:00:11] Checking for the required ENV setup ************* Start of session ************* version: 12.2.0 started at: Mon Jun 25 2018 00:00:11 APPL_TOP is set to /u01/oracle/PROD/fs1/EBSapps/appl [STATEMENT] [START 2018/06/25 00:00:11] Determining admin node [STATEMENT] [END 2018/06/25 00:00:14] Determining admin node [STATEMENT] Recommended Worker Count: 2 Max Allowed Workers: 9 [STATEMENT] [START 2018/06/25 00:00:18] Acquiring lock on sessions table [STATEMENT] [END 2018/06/25 00:00:19] Acquiring lock on sessions table [STATEMENT] [START 2018/06/25 00:00:19] Checking for any pending sessions [STATEMENT] There is already a hotpatch session which is incomplete. Details are: [STATEMENT] Session Id: 2 [STATEMENT] Prepare phase status: X [STATEMENT] Apply phase status: P [STATEMENT] Cutover phase status: R [STATEMENT] Abort phase status: X [STATEMENT] Session status: F [STATEMENT] [Note: Y denotes that the phase is done [STATEMENT] N denotes that the phase has not been completed [STATEMENT] X denotes that the phase is not applicable [STATEMENT] R denotes that the phase is running (in progress) or ran [STATEMENT] F denotes that the phase has failed [STATEMENT] P (is applicable only to APPLY phase) denotes atleast [STATEMENT] one patch is already applied for the session id [STATEMENT] Will continue with previous session [STATEMENT] [START 2018/06/25 00:00:45] Performing steps to get the previous session inputs [STATEMENT] [END 2018/06/25 00:00:48] Performing steps to get the previous session inputs [STATEMENT] Continuing [STATEMENT] [START 2018/06/25 00:00:53] Unlocking sessions table [STATEMENT] [END 2018/06/25 00:00:54] Unlocking sessions table [STATEMENT] [START 2018/06/25 00:00:54] adzdoptl.pl run [STATEMENT] Session ID: 2 [STATEMENT] Phase: apply [STATEMENT] Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/adop_20180624_235951.log [STATEMENT] [START 2018/06/25 00:01:08] Invoking admerge [STATEMENT] [END 2018/06/25 00:01:09] Invoking admerge [STATEMENT] [START 2018/06/25 00:01:10] apply phase [STATEMENT] APPLY Phase START TIME: 25-06-2018 00:01:12 [STATEMENT] [START 2018/06/25 00:01:15] Performing Check for Logon Trigger existence and enablement [STATEMENT] [END 2018/06/25 00:01:17] Performing Check for Logon Trigger existence and enablement sh: module: line 1: syntax error: unexpected end of file sh: error importing function definition for `module' [STATEMENT] [Start 2018/06/25 00:01:22] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop [STATEMENT] Reading defaults file /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt [STATEMENT] Substituting tokens ... [STATEMENT] Regenerating defaults file ... [STATEMENT] [End 2018/06/25 00:01:23] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop [STATEMENT] Calling: adpatch abandon=yes workers=2 options=hotpatch flags=autoskip console=no interactive=no defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs_ne/EBSapps/patch/17204589 driver=u17204589.drv logfile=u17204589.log [STATEMENT] ADPATCH Log directory: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20180624_235951/PROD_erp1/17204589/log [STATEMENT] Running: adpatch abandon=yes workers=2 options=hotpatch flags=autoskip console=no interactive=no defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs_ne/EBSapps/patch/17204589 driver=u17204589.drv logfile=u17204589.log stdin=yes sh: module: line 1: syntax error: unexpected end of file sh: error importing function definition for `module' Successfully created out directory You should check the file /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20180624_235951/PROD_erp1/17204589/log/u17204589.log for errors. [ERROR] Error occurred while executing <adpatch abandon=yes workers=2 options=hotpatch flags=autoskip console=no interactive=no defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs_ne/EBSapps/patch/17204589 driver=u17204589.drv logfile=u17204589.log> [ERROR] Please check the adpatch log files. [STATEMENT] Autopatch completed with errors/warnings. Please check logfiles [STATEMENT] APPLY Phase END TIME: 25-06-2018 00:01:49 [STATEMENT] [START 2018/06/25 00:01:51] Unlocking sessions table [STATEMENT] [END 2018/06/25 00:01:53] Unlocking sessions table [STATEMENT] Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/adop_20180624_235951.log adop exiting with status = 1 (Fail) |
Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4
|
|
Current Patching Session ID: 2
Node Name Node Type Phase Status Started Finished Elapsed --------------- --------------- ----------- --------------- ------------------------------ ------------------------------ ------------ erp1 master APPLY FAILED 25-JUN-18 12:01:12 +05:00 25-JUN-18 12:01:49 +05:00 0:00:37 PREPARE NOT APPLICABLE CUTOVER NOT APPLICABLE CLEANUP NOT STARTED |
Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4
|
Administrator
|
Still the "module" error?
Currently Oracle Support is not available, so I can check further.. But , I already solved a similiar error caused by module command and explained it in here -> http://ermanarslan.blogspot.com/2014/06/ebs-122-adadminsrvctlsh-start-sh-module.html Following is the action plan; **but if your env is PROD, the risk is yours.. --> Rename /etc/profile.d/modules.sh to /etc/profile.d/modules.sh.bak. Log out, log back in, and set the application environment. Confirm these environment variables are not set: MODULEPATH, LOADEDMODULES and MODULESHOME. Retry. |
Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4
|
|
ok Now i am applying AD.C patches with ALL critical AD patches.I have this issue while upgrade from EBS 12.2.0 TO 12.2.4
[oracle@erp1 scripts]$ adop phase=apply patches=25820806,26720905,24591000,26482811,22889868,27405878,27423814,27595967,26708775 hotpatch=yes merge=yes restart=yes abandon=no Enter the APPS password: Enter the SYSTEM password: Enter the WLSADMIN password: Validating credentials. Initializing. Run Edition context : /u01/oracle/PROD/fs1/inst/apps/PROD_erp1/appl/admin/PROD_erp1.xml Patch edition context: /u01/oracle/PROD/fs2/inst/apps/PROD_erp1/appl/admin/PROD_erp1.xml Patch file system free space: 232.54 GB [ERROR] Cannot connect to database [ERROR] Error Message: [ERROR] Error calling ad_zd_log. Refer to log file for details. [ERROR] Error calling ad_zd_log. Refer to log file for details. [ERROR] Error calling ad_zd_log. Refer to log file for details. [ERROR] Error calling ad_zd_log. Refer to log file for details. [ERROR] Error calling ad_zd_log. Refer to log file for details. [UNEXPECTED]Error occurred identifying Admin server node adop exiting with status = 2 (Fail) |
Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4
|
Administrator
|
This is generic. There is no detail.
Please refer to related log file for details. |
Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4
|
|
Admin server properly working successfully apply consolidated patch but when i apply AD.C patch i have this issue.I check no error found in log.Successfully connect database and apps schema and listener also working
|
Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4
|
Administrator
|
We need to see the logs..
DB and Listener may be up, but the tool may not be connected to the database. (for another reason) Here is an example issue: When Applying the Latest TXK Patches ADOP Apply Phase Fails With Error ' [ERROR] Cannot connect to database Error occurred while calling ad_zd_log.' and '[UNEXPECTED]Error occurred while trying to determine admin node' (Doc ID 2041291.1) -- it is solaris Speficic --Directly implement this, if your issue is similar and if your OS is SOLARIS. If the above note doesn't solve the issue; here is the action plan-> 1)Answer the question -> What is your platform? (OS?) -- 32 bit or 64 bit? version? 2)Send me the adop logs. |
Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4
|
|
OEL 6.5 64bit OS.Again i applied AD.C patches and found this error..Please guide me
[oracle@erp1 admin]$ adop phase=apply patches=25820806,26720905 merge=yes hotpatch=yes Enter the APPS password: Enter the SYSTEM password: Enter the WLSADMIN password: Please wait. Validating credentials... Enter the RUN file system context file name [/u01/oracle/PROD/fs1/inst/apps/PROD_erp1/appl/admin/PROD_erp1.xml]: [STATEMENT] [END 2018/06/27 14:22:17] Performing verification of parameters [STATEMENT] [START 2018/06/27 14:22:18] Checking for the required ENV setup [STATEMENT] [END 2018/06/27 14:22:18] Checking for the required ENV setup ************* Start of session ************* version: 12.2.0 started at: Wed Jun 27 2018 14:22:18 APPL_TOP is set to /u01/oracle/PROD/fs1/EBSapps/appl [STATEMENT] [START 2018/06/27 14:22:18] Determining admin node [STATEMENT] [END 2018/06/27 14:22:21] Determining admin node [STATEMENT] Recommended Worker Count: 2 Max Allowed Workers: 10 [STATEMENT] [START 2018/06/27 14:22:26] Acquiring lock on sessions table [STATEMENT] [END 2018/06/27 14:22:27] Acquiring lock on sessions table [STATEMENT] [START 2018/06/27 14:22:27] Checking for any pending sessions [STATEMENT] Using the session id which is not complete for all phases [STATEMENT] [START 2018/06/27 14:22:37] Unlocking sessions table [STATEMENT] [END 2018/06/27 14:22:39] Unlocking sessions table [STATEMENT] [START 2018/06/27 14:22:39] adzdoptl.pl run [STATEMENT] Session ID: 2 [STATEMENT] Phase: apply [STATEMENT] Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/adop_20180627_142158.log [STATEMENT] [START 2018/06/27 14:22:52] Invoking admerge [STATEMENT] [START 2018/06/27 14:22:54] Running AD Merge Normal Mode [STATEMENT] Calling: /u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/admerge.pl [STATEMENT] Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20180627_142158/PROD_erp1/admrgpch.log [STATEMENT] [END 2018/06/27 14:22:55] Running AD Merge Normal Mode [STATEMENT] [START 2018/06/27 14:22:55] Running AD Merge in AD Mode [STATEMENT] Calling: /u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/admerge.pl [STATEMENT] Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20180627_142158/PROD_erp1/admrgpch.log -console off Executing the merge of the patch drivers -- Processing patch: /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20180627_1530091373/src/25820806 -- Processing file: /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20180627_1530091373/src/25820806/u25820806.drv -- Done processing file: /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20180627_1530091373/src/25820806/u25820806.drv -- Done processing patch: /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20180627_1530091373/src/25820806 -- Processing patch: /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20180627_1530091373/src/26720905 -- Processing file: /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20180627_1530091373/src/26720905/u26720905.drv -- Done processing file: /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20180627_1530091373/src/26720905/u26720905.drv -- Done processing patch: /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20180627_1530091373/src/26720905 Copying files... 5% complete. Copied 25 files of 498... 10% complete. Copied 50 files of 498... 15% complete. Copied 75 files of 498... 20% complete. Copied 100 files of 498... 25% complete. Copied 125 files of 498... 30% complete. Copied 150 files of 498... 35% complete. Copied 175 files of 498... 40% complete. Copied 200 files of 498... 45% complete. Copied 225 files of 498... 50% complete. Copied 249 files of 498... 55% complete. Copied 274 files of 498... 60% complete. Copied 299 files of 498... 65% complete. Copied 324 files of 498... 70% complete. Copied 349 files of 498... 75% complete. Copied 374 files of 498... 80% complete. Copied 399 files of 498... 85% complete. Copied 424 files of 498... 90% complete. Copied 449 files of 498... 95% complete. Copied 474 files of 498... 100% complete. Copied 498 files of 498... Character-set converting files... 2 unified drivers merged. Patch merge completed successfully Please check the log file at /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20180627_142158/PROD_erp1/admrgpch.log. [STATEMENT] [END 2018/06/27 14:22:56] Running AD Merge in AD Mode [STATEMENT] [END 2018/06/27 14:22:57] Invoking admerge [STATEMENT] [START 2018/06/27 14:22:59] apply phase [STATEMENT] APPLY Phase START TIME: 27-06-2018 14:23:00 [STATEMENT] [START 2018/06/27 14:23:03] Performing Check for Logon Trigger existence and enablement [STATEMENT] [END 2018/06/27 14:23:05] Performing Check for Logon Trigger existence and enablement [STATEMENT] [Start 2018/06/27 14:23:11] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop [STATEMENT] Reading defaults file /u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt [STATEMENT] Substituting tokens ... [STATEMENT] Regenerating defaults file ... [STATEMENT] [End 2018/06/27 14:23:11] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop [STATEMENT] Calling: adpatch workers=2 options=hotpatch flags=autoskip console=no interactive=no defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20180627_1530091373 driver=u_ad_20180627_1530091373.drv logfile=u_ad_20180627_1530091373.log [STATEMENT] ADPATCH Log directory: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20180627_142158/PROD_erp1/ADOP_MRG_20180627_1530091373/log [STATEMENT] Running: adpatch workers=2 options=hotpatch flags=autoskip console=no interactive=no defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20180627_1530091373 driver=u_ad_20180627_1530091373.drv logfile=u_ad_20180627_1530091373.log stdin=yes Successfully created out directory AutoPatch error: Error while inserting row in AD_TIMESTAMPS AutoPatch error: ORA-01400: cannot insert NULL into ("APPLSYS"."AD_TIMESTAMPS"."ATTRIBUTE") AutoPatch error: aijhip(): Error calling aijmgrInsertHangingRowInAdTmStmp() AutoPatch error: Failed running aidinv() in adprim() AutoPatch error: Failed running Invoker's Rights maintanance logic You should check the file /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20180627_142158/PROD_erp1/ADOP_MRG_20180627_1530091373/log/u_ad_20180627_1530091373.log for errors. [ERROR] Error occurred while executing <adpatch workers=2 options=hotpatch flags=autoskip console=no interactive=no defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/log/ADOP_MRG_20180627_1530091373 driver=u_ad_20180627_1530091373.drv logfile=u_ad_20180627_1530091373.log> [ERROR] Please check the adpatch log files. [STATEMENT] Autopatch completed with errors/warnings. Please check logfiles *******FATAL ERROR******* PROGRAM : (/u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl) TIME : Wed Jun 27 14:35:07 2018 FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ] MESSAGES: SQLPLUS error: buffer= SQL*Plus: Release 10.1.0.5.0 - Production on Wed Jun 27 14:35:06 2018 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> SQL> Connected. SQL> where adop_session_id = 2 and appltop_id = and node_name='erp1' * ERROR at line 3: ORA-00936: missing expression 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 /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168 TXK::Error::abort('TXK::Error', 'HASH(0x19db440)') called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299 TXK::Common::doError('TXK::SQLPLUS=HASH(0x1ede100)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...', undef) called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314 TXK::Common::setError('TXK::SQLPLUS=HASH(0x1ede100)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...') called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 832 TXK::SQLPLUS::_doExecute('TXK::SQLPLUS=HASH(0x1ede100)', 0) called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 234 TXK::SQLPLUS::execute('TXK::SQLPLUS=HASH(0x1ede100)', 'HASH(0x1f627f0)') called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 618 TXK::TechstackDB::_getSQLValue('TXK::TechstackDB=HASH(0x1c31110)', ' update ad_adop_sessions \x{a} set status=\'F\'\x{a} ...') called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 573 TXK::TechstackDB::getSQLValue('TXK::TechstackDB=HASH(0x1c31110)', ' update ad_adop_sessions \x{a} set status=\'F\'\x{a} ...') called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/Phase.pm line 262 ADOP::Phase::executeSQL('ADOP::CommonUtil=HASH(0x147cfe8)', ' update ad_adop_sessions \x{a} set status=\'F\'\x{a} ...') called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/CommonUtil.pm line 1304 ADOP::CommonUtil::setADOPSessionStatus('ADOP::CommonUtil=HASH(0x147cfe8)', 'F') called at /u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl line 95 main::__ANON__('*******FATAL ERROR*******\x{a}PROGRAM : (/u01/oracle/PROD/fs1/EBS...') called at /u01/oracle/PROD/fs1/FMW_Home/webtier/perl/lib/5.10.0/Carp.pm line 45 Carp::confess('*******FATAL ERROR*******\x{a}PROGRAM : (/u01/oracle/PROD/fs1/EBS...') called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168 TXK::Error::abort('TXK::Error', 'HASH(0x8f36d0)') called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299 TXK::Common::doError('TXK::SQLPLUS=HASH(0x1d72480)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...', undef) called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314 TXK::Common::setError('TXK::SQLPLUS=HASH(0x1d72480)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...') called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 832 TXK::SQLPLUS::_doExecute('TXK::SQLPLUS=HASH(0x1d72480)', 0) called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 234 TXK::SQLPLUS::execute('TXK::SQLPLUS=HASH(0x1d72480)', 'HASH(0x1c1f460)') called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 618 TXK::TechstackDB::_getSQLValue('TXK::TechstackDB=HASH(0x25bdcf8)', ' update ad_adop_sessions \x{a} set status=\'F\'\x{a} ...') called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 573 TXK::TechstackDB::getSQLValue('TXK::TechstackDB=HASH(0x1c31110)', ' update ad_adop_sessions \x{a} set status=\'F\'\x{a} ...') called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/Phase.pm line 262 ADOP::Phase::executeSQL('ADOP::CommonUtil=HASH(0x147cfe8)', ' update ad_adop_sessions \x{a} set status=\'F\'\x{a} ...') called at /u01/oracle/PROD/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/CommonUtil.pm line 1304 ADOP::CommonUtil::setADOPSessionStatus('ADOP::CommonUtil=HASH(0x147cfe8)', 'F') called at /u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl line 424 main::executePhaseSequence() called at /u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl line 863 main::adopMain() called at /u01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl line 872 adop exiting with status = 1 (Fail) |
Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4
|
Administrator
|
Check this note -> Error ORA-01400 while Applying Latest AD&TXK Patches (Doc ID 2343015.1)
|
Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4
|
|
Dear i really don't have this DOC.Kindly tell me its solution please
|
Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4
|
Administrator
|
You probably did something wrong during your patching activities...
Probably, you applied some patches using merge option.. But those patches were probably not compatible with the merge option.. Please review the things that you have done so far. Try to find those patches that I mentioned above... If you find them, your action plan is -> Restore the system back to the previous point before applying the two patches with merge=y. After restoring the patches have to be applied separately. |
Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4
|
|
i understand..Thanx
|
|
|
In reply to this post by ErmanArslansOracleBlog
Hello Erman,
I faced exact issue yesterday. After a extensive R&D, I am able to resolve the issue. I am preparing the solution document and will share soon. Can I have your emailid so that I can forward the document. Regards, Azhar |
Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4
|
Administrator
|
Okay Azhar, lets see..
|
|
|
Hello Erman,
Please find the below solution for the above error. Observation: 1. Before applying patch APPS.AD_ZD_MVIEW package was in VALID state 2. But while the patch was started, package body APPS.AD_ZD_MVIEW became INVALIDATED 3. Tried to compile manually but resulting in error. PLS-00201: identifier 'DBMS_SQL2.EXPAND_SQL_TEXT' must be declared Issue Resolution: 1. Before the patch applied, package APPS.AD_ZD_MVIEW was taken backup. 2. Verified the identifier “'DBMS_SQL2.EXPAND_SQL_TEXT” in the package. Before Applying the Patch : Function(Expand_Query) in APPS.AD_ZD_MVIEW package /* Formatted on 11/28/2018 3:40:50 PM (QP5 v5.294) */ FUNCTION EXPAND_QUERY (p_query CLOB) RETURN CLOB IS l_exp_select_query CLOB; BEGIN -- Expand the select query $IF DBMS_DB_VERSION.VER_LE_11 $THEN dbms_sql2.expand_sql_text (p_query, l_exp_select_query); $ELSE -- change by Kevin DBMS_UTILITY.expand_sql_text (p_query, l_exp_select_query); $END RETURN l_exp_select_query; END; After applying the patch: function EXPAND_QUERY(p_query clob) return clob is l_exp_select_query clob; begin -- Expand the select query dbms_sql2.expand_sql_text(p_query, l_exp_select_query); return l_exp_select_query; end; Solution: 3. Replaced the existing function “EXPAND_QUERY” in the package body “AD_ZD_MVIEW” from the package backup that was taken before applying the patch. 4. Compiled the package body and the status of the package changed to VALID. After this the error was resolved and was able to proceed further. Thanks, Azhar |
«
Return to EBS 12.2
|
1 view|%1 views
| Free forum by Nabble | Edit this page |