PROCESSED Messages not clearing from Oracle Queue
I was contacted by Dev team to look into Development database where Oracle queue size kept on increasing. As per them messages were not getting cleared.They were running count on…
Read Full RecipeTag: oracle
ORA-01873 error running SAP pre-upgrade scripts
While trying to run pre_upgrade_status.sql script for DB upgrade (10.2.0.4 to 11.2.0.4), we got following error @pre_upgrade_status.sql ERROR at line 1: ORA-01873: the leading precision of the interval is too…
Read Full Recipe
LGWR terminating instance due to error 338
Recently we came across a issue where our DB crashed with ORA-00338 error . Errors in file /oracle/diag/rdbms/orcl11g/orc11g/trace/orc11g_lgwr_24118.trc: ORA-00338: log 2 of thread 1 is more recent than control file…
Read Full Recipe
ORA-12514 due to DNS issue
A User reported ORA-12514 error from JDBC application connecting to RAC database ORA-12514: TNS:listener does not currently know of service requested in connect descriptor To troubleshoot it, a)I checked following…
Read Full Recipe
GoldenGate Setup for Real-Time Data Synchronization
In this post we discussed about GoldenGate(GG) concepts and setting GG without DataPump Process. Now I will talk about DataPump process and show how to setup GG replication which also…
Read Full Recipe
Copying Oracle Scheduler jobs with Arguments
Oracle provides dbms_scheduler.copy_job function to copy oracle scheduler jobs which works great. But problem is that it cannot copy jobs which have arguments. Need to copy jobs can arise due…
Read Full Recipe