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 DBA Journey to Cloud, DevOps and Big Data..

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

MGMTDB: Grid Infrastructure Management Repository

  • Post author:Amit Bansal
  • Post published:23 July, 2013
  • Post category:12c
  • Post comments:3 Comments

MGMTDB is new database instance which is used for storing Cluster Health Monitor (CHM) data. In 11g this was being stored in berkley database but starting Oracle database 12c it is…

Continue ReadingMGMTDB: Grid Infrastructure Management Repository
Read more about the article 12c: Exporting Database Views as Tables

12c: Exporting Database Views as Tables

  • Post author:Amit Bansal
  • Post published:22 July, 2013
  • Post category:12c
  • Post comments:1 Comment

Starting Oracle Database 12c, you can export view to be imported as a table. There is no need to individually export each table, Data Pump will dump a table with…

Continue Reading12c: Exporting Database Views as Tables
Read more about the article 12c: Sqlplus Displays Last Login Time For Non – Sys Users

12c: Sqlplus Displays Last Login Time For Non – Sys Users

  • Post author:Amit Bansal
  • Post published:22 July, 2013
  • Post category:12c
  • Post comments:1 Comment

12c database has introduced a pretty nifty Security feature which allows you to check last login time for non-sys user. e.g If I connect to scott user as below, it…

Continue Reading12c: Sqlplus Displays Last Login Time For Non – Sys Users
Read more about the article 12c:Limiting PGA with pga_aggregate_limit

12c:Limiting PGA with pga_aggregate_limit

  • Post author:Amit Bansal
  • Post published:7 July, 2013
  • Post category:12c
  • Post comments:1 Comment

This is a interesting feature for Oracle DBA's. Till now there has been no way of limiting total PGA being used by oracle instance. _pga_max_size (hidden parameter) could be used to…

Continue Reading12c:Limiting PGA with pga_aggregate_limit
  • Go to the previous page
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • …
  • 34
  • Go to the next page
Copyright - OceanWP Theme by OceanWP