Scenario: There was a missing archive log error and we need to change the archive log location for integrated capture process in Goldengate. Error : ERROR OGG-00868 Error code 1291,…
Read MoreScenario: 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 MoreTally 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 MoreConfiguring 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 MoreIt 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 MoreDescription: 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 MoreWhen 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 MoreAPPLIES 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 MoreAPPLIES 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 MoreAPPLIES 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