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…
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…
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…
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…
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…
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…
- 1
- 2
- 3
- 4
- …
- 17
- Go to the next page