Database Blog

DB Node Crashes after upgrading to 19c

Scenario: DB node Crashes after upgrading from 12.0 to 19c. Error: 2021-02-04T12:00:15.450521+00:00 Errors in file /u01/database/19.0.0/diag/rdbms/doyen/doyenB/trace/doyenB_lgwr_56472.trc: ORA-00600: internal error code, arguments: [3732], [33], [2], [], [], [], [], [], [],…

Read More

Tally Integration

Tally Data Integration & Data Migration Tally Integration : Comprehensive and medium-scale organizations use different applications to maintain their business and one of the important areas involved in these applications…

Read More

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