INITIAL ERROR
===========================

(oraclehost(oravis):/ord80/ohfvis/ora/app/fs_ne/EBSapps/patch)$  adop phase=cleanup                

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Validating credentials.

Initializing.
    Run Edition context  : /ord80/ohfvis/ora/app/fs1/inst/apps/OHFVIS_oraclehost/appl/admin/OHFVIS_oraclehost.xml
    Patch edition context: /ord80/ohfvis/ora/app/fs2/inst/apps/OHFVIS_oraclehost/appl/admin/OHFVIS_oraclehost.xml
    Patch file system free space: 114.30 GB

Validating system setup.
    Node registry is valid.
    [WARNING]   MTCC has not been run. Apply Patch 17537119 and run checkMTpatch.sh.

Checking for existing adop sessions.

===========================================================================
ADOP (C.Delta.9)
Session ID: 2
Node: oraclehost
Phase: cleanup
Log: /ord80/ohfvis/ora/app/fs_ne/EBSapps/log/adop/2/20170724_171041/adop.log
===========================================================================

Processing cleanup actions in parallel.
    Log: /ord80/ohfvis/ora/app/fs_ne/EBSapps/log/adop/2/20170724_171041/cleanup/oraclehost/log/cleanup.log

Generating report of queued DDL actions.
    Output: /ord80/ohfvis/ora/app/fs_ne/EBSapps/log/adop/2/20170724_171041/cleanup/oraclehost/adzdallddls.out

Running cleanup in STANDARD mode.
    Log: @ADZDSHOWLOG.sql "2017/07/24 17:58:47"
    [ERROR]     [CLEANUP 1:1 ddl_id=26481] ORA-04021: timeout occurred while waiting to lock object  SQL: begin sys.ad_grants.cleanup; end;

Generating log report.
    Output: /ord80/ohfvis/ora/app/fs_ne/EBSapps/log/adop/2/20170724_171041/cleanup/oraclehost/adzdshowlog.out

The cleanup phase completed successfully.


adop exiting with status = 0 (Success)




APPLY FIX AS PER 2285537.1
===========================
(oraclehost(oravis):/ord80/ohfvis/ora/app/fs_ne/EBSapps/patch)$  /
(oraclehost(oravis):/ord80/ohfvis/ora/app/fs_ne/EBSapps/patch)$  sqlplus apps/apps

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Jul 24 18:21:45 2017

Copyright (c) 1982, 2005, 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> exec sys.ad_grants.cleanup;

PL/SQL procedure successfully completed.

SQL> select count(1)
from dba_tab_privs
where table_name='DBMS_SYS_SQL'
and privilege='EXECUTE'
and grantee='APPS'  2    3    4    5  ;

  COUNT(1)
----------
         0

SQL> exit
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

RE-TRY adop phase=cleanup
===========================
(oraclehost(oravis):/ord80/ohfvis/ora/app/fs_ne/EBSapps/patch)$  adop phase=cleanup

Enter the APPS password:

Enter the SYSTEM password:
Enter the WLSADMIN password:

Validating credentials.

Initializing.
    Run Edition context  : /ord80/ohfvis/ora/app/fs1/inst/apps/OHFVIS_oraclehost/appl/admin/OHFVIS_oraclehost.xml
    Patch edition context: /ord80/ohfvis/ora/app/fs2/inst/apps/OHFVIS_oraclehost/appl/admin/OHFVIS_oraclehost.xml
    Patch file system free space: 114.30 GB

Validating system setup.
    Node registry is valid.
    [WARNING]   MTCC has not been run. Apply Patch 17537119 and run checkMTpatch.sh.

Checking for existing adop sessions.
    [UNEXPECTED]Unrecoverable error occurred. Exiting current adop session.


[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.


adop exiting with status = 2 (Fail)


(oraclehost(oravis):/ord80/ohfvis/ora/app/fs_ne/EBSapps/patch)$  adopscanlog -latest=yes

Scanning /ord80/ohfvis/ora/app/fs_ne/EBSapps/log/adop/2/ directory ...

No Errors.



(oraclehost(oravis):/home/oravis)$ adop -status

Enter the APPS password:
Connected.
==============================================================
ADOP (C.Delta.9)
Session Id: 2
Command: status
Output: /ord80/ohfvis/ora/app/fs_ne/EBSapps/log/adop/2/20170728_174222/adzdshowstatus.out
===============================================================
Node Name Node Type Phase Status Started Finished Elapsed
--------------- ---------- --------------- --------------- -------------------- -------------------- ------------
oraclehost master APPLY COMPLETED 2017/07/11 17:19:40 2017/07/17 23:53:37 150:33:57
                  FINALIZE NOT STARTED
                  CLEANUP NOT STARTED 2017/07/18 12:21:32 2017/07/18 13:23:35 1:02:03