Skip to content
AskDba.org Weblog
  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g10g Articles
    • 11gLists 11gR1/R2 articles
    • 12c
  • Performance
  • About Us
Menu Close
  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g
    • 11g
    • 12c
  • Performance
  • About Us

oracle

Home » oracle

PROCESSED Messages not clearing from Oracle Queue

  • Post author:Amit Bansal
  • Post published:1 February, 2016
  • Post category:10g/11g
  • Post comments:0 Comments

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…

Continue ReadingPROCESSED Messages not clearing from Oracle Queue

ORA-01873 error running SAP pre-upgrade scripts

  • Post author:Amit Bansal
  • Post published:30 March, 2015
  • Post category:10g/11g
  • Post comments:0 Comments

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…

Continue ReadingORA-01873 error running SAP pre-upgrade scripts

LGWR terminating instance due to error 338

  • Post author:Amit Bansal
  • Post published:24 December, 2014
  • Post category:10g/11g/12c
  • Post comments:3 Comments

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…

Continue ReadingLGWR terminating instance due to error 338

ORA-12514 due to DNS issue

  • Post author:Amit Bansal
  • Post published:5 July, 2012
  • Post category:10g/11g
  • Post comments:0 Comments

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…

Continue ReadingORA-12514 due to DNS issue

GoldenGate Setup for Real-Time Data Synchronization

  • Post author:Saurabh Sood
  • Post published:8 June, 2012
  • Post category:Goldengate
  • Post comments:0 Comments

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…

Continue ReadingGoldenGate Setup for Real-Time Data Synchronization

Copying Oracle Scheduler jobs with Arguments

  • Post author:Amit Bansal
  • Post published:8 February, 2012
  • Post category:10g/11g
  • Post comments:1 Comment

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…

Continue ReadingCopying Oracle Scheduler jobs with Arguments
  • 1
  • 2
  • 3
  • 4
  • …
  • 17
  • Go to the next page
Copyright - OceanWP Theme by OceanWP