DBA Arena

Issue:

While running adop phase=prepare, it fails on one node while trying to clone Run Context file to refresh Patch context file.

Error:

It fails with the following error in the ADOP Session.
ADOP prepare phase fails with [UNEXPECTED] occurred during CONFIG_CLONE Patch File System from Run File System

The log file has the following error:

ERROR: Could not clone the Run context file due to the following exception:
AC-00005: No write permissions for creating the Context file - /tmp/temp.xml
Raised by oracle.apps.ad.context.AppsContext
ERROR: Failed to clone Run Context file to refresh Patch context file

applpreprod@ebsapp01:~$ adop phase=prepare

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

Validating credentials.

Initializing.
Run Edition context : /u01/PREPROD/fs1/inst/apps/PREPROD_ebsapp01/appl/admin/PREPROD_ebsapp01.xml
Patch edition context: /u01/PREPROD/fs2/inst/apps/PREPROD_ebsapp01/appl/admin/PREPROD_ebsapp01.xml
Patch file system free space: 83.74 GB

Validating system setup.
Read more...

Issue:

After applying Exadata or Super Cluster Bundle Patch on the RDBMS HOME of an EBS R12.2 database, the APPS.AD_ZD_ADOP Package becomes invalid and all ADOP sessions fail.

Error:

applprod@ebsapp01:~$ adop -status

Enter the APPS password:

==============================================================
ADOP (C.Delta.7)
Session Id: 55
Command: status
Output: /u01/PROD/fs_ne/EBSapps/log/status_20161115_112514/adzdshowstatus.out
===================================wo============================

File System Synchronization Type: Full
declare
*
ERROR at line 1:
ORA-04063: package body "APPS.AD_ZD_ADOP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.AD_ZD_ADOP"
ORA-06512: at line 6

[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 = 1 (Fail)

=====================

Read more...