Oracle 11g upgrade and SYS.AUD$ obstacles

During one of the Oracle 10gR2 databases manual upgrade to Oracle 11gR2 couple of days ago, to our own surprise, the upgrade procedure took nearly 5.34 hrs to finish. Although we had done earlier 100's of database manual upgrades comfortably within 2 hrs time window for individual database, the delay indeed surprised us this time. Unfortunately, there is no log that could help us understanding what is really going on. We started investigation the (more...)

Bug 18223021 : DISK FILE OPERATIONS I/O ON HP-UX.

We have been dealing with a strange ASM  behavior over the past few months across all ASM instances in our multiple Oracle 11gR2 (11.2.0.2) Cluster envs on HPUX 11.31 OS. Even a simple and typical ASM task like, adding new disk to ASM disk group, disk group mount/unmount and querying for CANDIDATE asm disks was taking min of 20 minutes, and sometimes infinity time. This behavior caused a lot of performance (more...)

CRS-1615:No I/O has completed after 50% of the maximum interval

A few days back on one of the production cluster nodes the clusterware became unhealthy and caused instances termination on the node. If it was a node eviction, everything would have come back automatically after the node reboot, however, in this scenario, just cluster components were in unhealthy state, hence, no instance started on the node.

Upon referring the ocssd.log file, the following error found:

cssd(21532)]CRS-1615:No I/O has completed after 50% of the maximum (more...)

AUTO Vs Manual PSU patch – when and why?

The purpose of this blog entry is to share a successful story of reducing (almost 50%) over all patching time we achieved in the recent times. Thought this would help you as well.

In my own perspective, I think we are one of the organizations in the Middle East who has a large and complex Oracle Cluster setups in-place. Having six (06) cluster environments, which includes production, non-production and DR, it is always certainly going (more...)

Upgrade to Oracle 12c [1Z0-060 ] exam is available now

A very quick note about the announcement of Upgrade to Oracle 12c - 1Z0-060 exam availability, it is no longer beta now. The exam has two sections, with 51 and 34 question respectively in each section with 64% and 65% passing margin. You must succeed in both sections in order (more...)

Exadata – a new learning cuvrve

Perhaps I might be touch late on adopting/exploring/reacting/coping up with the exadata, but, it was always my dream and passion to work with the technologies since the announcement. As we knew Exadata is not something we can download and configure that easily on PC like those of traditional database or (more...)

I am speaking @AIOUG – SANGAM13 conference

This post is specifically aimed to the folks back in India, mostly in Hyderabad or surrounding places.

Perhaps most of you probably knew that the All India Oracle Users Group (AIOUG) annual conference SANGAM13 will be taking place in Hyderabad this year. I have been trying my luck over the (more...)

Oracle Open World 2013 – attending & presenting

Most of us knew Oracle Open World 2013 event is fast approaching and kicks off in just a few days time. I haven't talked much about the OOW13 event of late, therefore, I am sharing my plans over here.

  • attending Oracle ACE Directors briefing scheduled on 19-20 Sept 2013 at (more...)

Deprecated database init. parameters in 12c

Here is a very short blog about all the deprecated database initialization parameters in 12c.  It is sometime becomes essential to be familiar with those database features and init. parameters that are either de-supported or deprecated in a new release of Oracle database before proceeding with the upgrade. This (more...)

Useful MOS notes on 12c

Here is the list of useful MOS notes on 12c:


  1. Oracle Database 12c Release 1 (12.1) Upgrade New Features [ID 1515747.1]
  2. NOTE:1520299.1 - Master Note For Oracle Database 12c Release 1 (12.1) Database/Client Installation/Upgrade/Migration Standalone Environment (Non-RAC)
  3. NOTE:1493645.1 - Oracle Database 12c Release 1 (more...)

Oracle Database 12c Technology Day worldwide

Oracle quotes that 12c comes with more than 500 new features. Join the Oracle technology day event to learn firsthand how the new multitenant architecture make it easy to deploy and manage database clouds.

You will learn the following:


    • Simplify database consolidation
    • Automatically compress and tier data
    • Improve application continuity
    • (more...)

    Upgrade, Migrate and Consolidate to Oracle Database 12c slide deck by Mike Dietrich

    Mike and his team did it once again. This time its 12c Upgrade/Migrate.

    Here is the excerpt from his blog:

    with (sorry, we've did it again!) over 500 slides covering:
    • The brand new Parallel Upgrade including new Pre/Post-Upgrade-Fix-Ups
    • The new Full Transportable Export/Import Feature
    • Obviously Oracle Multitenant, (more...)

    Oracle Database 12c – download on https://edelivery.oracle.com/

    Although Oracle yet to announce the release of Oracle Database 12c publicly, if you have got MOS login credentials, download Oracle Database 12c for Linux on E-Delivery site.

    https://edelivery.oracle.com

    However, the documentation is not open yet.

    Enjoy and good luck with all your testing!!!!!!!!!

    ORA-01115: IO error reading block from file (block # ) – a list of common causes

    There are situations when a single issue could arise for different reasons. Will list out some of the common causes of an 'ORA-01115: IO error reading block from file  (block # )' error over here.

    Typically, when Oracle failed to read a data block from an open data (more...)

    Rejoining a node to a 2 node cluster on Windows Platform – Yet another learning experience

    There was a situation encountered a couple of days ago where a node (second node) had to rejoin to a 2 node cluster environment on Windows 2008 platform. The Windows OS admin team rebuilt the 2 node after OS crash without DBAs being informed and requested the DBA team to (more...)

    Introducing Java EE 7 – Live Webcast


    Wednesday, June 12, 2013 / Thursday, June 13, 2013 

    Two opportunities to come together with the Java community, chat with experts, and explore Java EE 7: 
    9 a.m. PT / 12 p.m. ET / 5 p.m. London or 
    9 p.m. PT / 12 a.m. ET (more...)

    Expert Oralce RAC 12c – upcoming book

    Here is the TOC for upcoming Expert Oracle RAC 12c book, which is slated to release sometime in August 2013 (of course subject to Oracle 12c announcement), published by Apress.


    Table of contents

    1. Overview of Oracle RAC
    2. Clusterware Management and Troubleshooting
    3. RAC Operational Practices
    4. RAC New Features
    5. Storage and ASM (more...)

    A tricky standby database situation

    A very tricky and interesting situation came-up this morning while configuring one of the standby databases of over 1.5TB sized . Whilst the database is being cloned to the DR site as part of the DUPLICATE..ACTIVE DATABASE command, which actually took more than 1.5 day, a couple of (more...)

    New Page – Data Guard

    A quick update about the new page. I have created a new page (tab) 'Data Guard' on my blog to share/discuss all data guard related issues that we confronted during our extensive DR setup and testing. The objective is to record all the errors/issues of data guard setup and how (more...)

    Its data guard time for the team yet again

    Just a very quick update about my upcoming tasks and what I will be doing for the next 3 weeks time. It is indeed going to be a super busy rest of the month for the entire team as over 41 RAC databases data guard configuration need to be done. (more...)