Database Blog

Configuring Physical Standby Database Using Data Guard

Configuring Physical Standby Database Using Data Guard Primary Database - Dhee Standby Database - Dheedr STEP 1: Check the Primary DB is in archive log mode or not.If it is…

Read More

How to Change the Default Request Group in E-Business Suite Support Analyzer Bundle Menu

It is possible to change the default request group for a given Analyzer at the individual analyzer level. 1.Start the menu with “perl Menu.pl” 2,Select a Product Family 3.Select an…

Read More

How to install Trace File Analyzer (TFA)

Description: Trace File Analyzer Collector also known as TFA is a diagnostic collection utility which greatly simplifies the diagnostic data collection for both Oracle Database as well as Oracle Clusterware/Grid Infrastructure RAC environments.Trace…

Read More

ORA-29532: Java call terminated by uncaught Java exception: java.lang.OutOfMemoryError – ecx_utils.INITIALIZE

When  trying to submit one of GL report end with  error. The error message shows ORA-29532: Java call terminated by uncaught Java exception. select * from ************_LOV  ORA–29532: Java call terminated by uncaught Java exception: java.lang.NullPointerException 29532. 00000…

Read More

How to resolve ORA-00379: no free buffers available in buffer pool DEFAULT for block size 8K 16K or 32K errors

APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.3 and later GOAL: This note helps in how to use multiple cache size for tablespaces with different block size i.e…

Read More

Autoconfig issue with s_applptmp after database upgrade to 19c

APPLIES TO: Oracle Applications DBA - Version 12.1.3 to 12.2.9 [Release 12.1 to 12.2] SYMPTOMS: Autoconfig failed in application tier node after upgrading database to 19c on setting s_applptmp context…

Read More

ASM Fails to Start with ORA-4031: unable to allocate 16416 bytes of shared memory (“shared pool”,”unknown object”,”sga heap(1,0)”,”dbktb: trace buffer”)

APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.1 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A…

Read More

OPatch Cannot Continue Because it Would not be Able to Load OUI Platform Dependent Library from the Directory “$ORACLE_HOME/oui/lib/linux”

APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.4 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version…

Read More

RMAN DUPLICATE without TARGET fails with RMAN-03002 / RMAN-06171

APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.1 and later SYMPTOMS: Database Names: UAT RMAN DUPLICATE without TARGET fails with RMAN-03002 / RMAN-06171 : $ rman auxiliary /…

Read More

R12 E-Business Suite Applications Manager Clone Process Fails With Error ‘AC-50006: Could not assign any APPL_TOP name to this instance’ When Running Adcfgclone.pl AppsTier On An Environment

APPLIES TO: Oracle Applications Manager - Version 12.1.3 and later SYMPTOMS: E-Business Suite R12 Applications Manager, Rapidclone related issues java.lang.Exception: AC-50006: Could not assign any APPL_TOP name to this instance.…

Read More