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

Author: Amit Bansal

This author has written 158 articles
Home » Archives for Amit Bansal » Page 3

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
  • …
  • 27
  • Go to the next page

Disclaimer!!

This blog reflect our own views and do not necessarily represent the views of our current or previous employers.

The contents of this blog are from our experience, you may use at your own risk, however you are strongly advised to cross reference with Product documentation and test before deploying to production environments.

Recent Comments

  • Azure BLOB Storage As Remote Backend for Terraform State File - AskDba.org Weblog on Azure Infrastructure Automation With Terraform: Configuration
  • tolu on 11g: Multiple failed login attempt can block New Application connections
  • venkatesh on Retrieving Database SID,Port information from Grid Control repository
  • Patrick on Solving ORA-1031 while connecting as “/ as sysdba” :
  • Natarajan Gounder on Creating ASM devices on AIX

Trending

  • Resolving Shutdown Immediate Hang Situations
  • Identifying PostgreSQL Bloat and fixing it without downtime
  • MGMTDB: Grid Infrastructure Management Repository
  • User Sessions stuck on resmgr:cpu quantum wait event
  • Using SSL to securely connect to Amazon Redshift Cluster
  • TNS file functionality for PostgreSQL
  • Simplified Approach to Resolve ORA-4031

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 188 other subscribers

Copyright - OceanWP Theme by OceanWP