5
Dec

On Oracle Applications 12.2 version, Online Enablement patch fails on APPS.AD_ZD_PREP package

Symptoms:

On Oracle Applications 12.2 version, online enablement patch 13543062 fails with:


begin
*
ERROR at line 1:
ORA-04063: package body "APPS.AD_ZD_PREP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.AD_ZD_PREP"
ORA-06512: at line 4

 
Try to compile the package:

SQL> alter package apps.AD_ZD_PREP compile body;

Warning: Package Body altered with compilation errors.
 
SQL> show error
Errors for PACKAGE BODY APPS.AD_ZD_PREP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
308/6 PL/SQL: Statement ignored
308/6 PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be
declared

670/4 PL/SQL: Statement ignored
670/4 PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be
declared

753/6 PL/SQL: Statement ignored
753/6 PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be
declared

LINE/COL ERROR
-------- -----------------------------------------------------------------

1152/4 PL/SQL: Statement ignored
1152/17 PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be
declared

Read more...

8
Nov

Error occurred while Executing txkADOPValidation script when running fs_clone

While running fs_clone, it fails with the following error:


[applprod@erpapp01 ~]$ adop phase=fs_clone

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

Validating credentials.

Initializing.
Run Edition context : /u01/oracle/ERPPROD/fs1/inst/apps/ERPPROD_erpapp01/appl/admin/ERPPROD_erpapp01.xml
Patch edition context: /u01/oracle/ERPPROD/fs2/inst/apps/ERPPROD_erpapp01/appl/admin/ERPPROD_erpapp01.xml
Patch file system free space: 355.97 GB

Validating system setup.
Node registry is valid.
[WARNING] ETCC: The following required database fixes have not been applied to node dx
12608451
21286665
Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.

Checking for existing adop sessions.
No pending session exists.
Starting new adop session.

===========================================================================
ADOP (C.Delta.8)
Session ID: 3
Node: erpapp01
Phase: fs_clone
Log: /u02/oracle/ERPPROD/fs_ne/EBSapps/log/adop/3/20170807_123036/adop.log
===========================================================================
Read more...

2
Oct

REP-0004: Warning: Unable to open user preference file

Symptoms:

Concurrent request logfiles have the below error:

REP-0004: Warning: Unable to open user preference file

 

Cause:

The prefs.ora is either missing or non-accessible.

 

Solution:

1. No prefs.ora file in HOME directory:

Oracle Reports will look into the user's HOME directory for the prefs.ora preferences file.  If a prefs.ora file does not exist in your HOME directory, you can copy the prefs.ora file that came with the Oracle Tools.

Read more...

12
Jan

ADOP Prepare phase fails while cloning Run Context file to refresh Patch context file

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...

13
Nov

Re-link fails on target "jox_refresh_knlopt ioracle" while applying OJVM PATCH SET UPDATE on Exadata

Issue:

While applying the OJVM patch on Exadata, the patch application fails on relinking.

Error:

OPatch failed: ApplySession failed in system modification phase... 'ApplySession::apply failed: Re-link fails on target "jox_refresh_knlopt ioracle".

OJVM Patch Installation:

Go to the patch directory.

[oracle@exadb01~]$ cd /u01/exadata_patch_apr2016/22738416/Database/11.2.0.4.0/11.2.0.4.160419OJVMPSU/22674697

OPatch Conflict Check

Determine whether any currently installed interim patches conflict with this patch.

[oracle@exadb01 22674697]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /u01/app/oracle/product/11.2.0.4/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0.4/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0.4/dbhome_1/cfgtoollogs/opatch/opatch2016-11-04_13-34-29PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

Read more...

Back to Top