[ERROR] First Run The Tool For The Prepare Phase Before Trying The Apply Phase (Doc ID 1912258.1)

Last updated on JANUARY 12, 2016

Applies to:

Oracle Applications DBA - Version 12.2 to 12.2 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Problem Summary
Ran <adop phase=apply patches=17766337,18491990 merge=yes> to start patching phase which errored:

[ERROR] First run the tool for the prepare phase before trying the apply phase


Problem Description
Completed running adop phase=prepare and went on to run to start patching phase.

The patching phase fails with the following:
[STATEMENT] [START 2014/07/17 13:08:18] adzdoptl.pl run
  [STATEMENT] Session ID: 2
  [STATEMENT] Phase: apply
  [STATEMENT] Log file: /u01/fire/applmgr/1200/fs_ne/EBSapps/log/adop/2/adop_20140717_103147.log
  [ERROR] First run the tool for the prepare phase before trying the apply phase
  [STATEMENT] [START 2014/07/17 13:08:29] Unlocking sessions table
  [STATEMENT] [END 2014/07/17 13:08:31] Unlocking sessions table
  [STATEMENT] Log file: /u01/fire/applmgr/1200/fs_ne/EBSapps/log/adop/2/adop_20140717_103147.log

adop exiting with status = 1 (Fail)
The following was also observed from the run:

[STATEMENT] There is already a session which is incomplete. Details are:
[STATEMENT] Session Id: 2
[STATEMENT] Prepare phase status: Y
[STATEMENT] Apply phase status: N
[STATEMENT] Cutover phase status: N
[STATEMENT] Abort phase status: N
[STATEMENT] Session status: F

Changes

Found 3 synonyms for AD_ADDL and dropped them all.
drop synonym OHS_ACCNT.apps_ddl;
drop synonym RAC_ACCNT.apps_ddl;
drop synonym ENCE.apps_ddl;

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms