adop error while upgrade from EBS 12.2.0 TO 12.2.4

classic Classic list List threaded Threaded
17 messages Options
Reply | Threaded
Open this post in threaded view
|

adop error while upgrade from EBS 12.2.0 TO 12.2.4

kabir zain
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)
Reply | Threaded
Open this post in threaded view
|

Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4

ErmanArslansOracleBlog
Administrator
This is a duplicate issue.
Please continue from -> http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Adop-error-td6234.html

Reply | Threaded
Open this post in threaded view
|

Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4

kabir zain
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)
Reply | Threaded
Open this post in threaded view
|

Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4

kabir zain
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

 
Reply | Threaded
Open this post in threaded view
|

Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4

ErmanArslansOracleBlog
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.
Reply | Threaded
Open this post in threaded view
|

Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4

kabir zain
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)
Reply | Threaded
Open this post in threaded view
|

Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4

ErmanArslansOracleBlog
Administrator
This is generic. There is no detail.
Please refer to related log file for details.
Reply | Threaded
Open this post in threaded view
|

Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4

kabir zain
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
Reply | Threaded
Open this post in threaded view
|

Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4

ErmanArslansOracleBlog
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.
Reply | Threaded
Open this post in threaded view
|

Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4

kabir zain
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)
Reply | Threaded
Open this post in threaded view
|

Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4

ErmanArslansOracleBlog
Administrator
Check this note -> Error ORA-01400 while Applying Latest AD&TXK Patches (Doc ID 2343015.1)
Reply | Threaded
Open this post in threaded view
|

Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4

kabir zain
Dear i really don't have this DOC.Kindly tell me its solution please
Reply | Threaded
Open this post in threaded view
|

Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4

ErmanArslansOracleBlog
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.
Reply | Threaded
Open this post in threaded view
|

Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4

kabir zain
i understand..Thanx
Reply | Threaded
Open this post in threaded view
|

Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4

Azhar
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
Reply | Threaded
Open this post in threaded view
|

Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4

ErmanArslansOracleBlog
Administrator
Okay Azhar, lets see..
Reply | Threaded
Open this post in threaded view
|

Re: adop error while upgrade from EBS 12.2.0 TO 12.2.4

Azhar
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