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