DBA Arena

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;

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

Read more...

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

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

Increasing oacore memory in EBS 12.2.x

Login to the Weblogic Console
http://hostname:port/console

Enter Username and Password.

Read more...

Symptoms

Forms service shows down for the E-Business Suite instance discovered in OEM but it is Up.

Cause

Wrong Forms URL

Solution

1. Go to targets-->All targets

2. In the Search Target Name, enter "Forms" or in the Search LOV select "Forms" then click (Go) button

Read more...