Oracle patching with minimum downtime.



Here is some important SAP notes on this topics.
Note 1696869 – Strategy for Patching of Oracle Homes with Minimal Downtime
Note 1524205 – Installation Oracle home” and Run-time Oracle home .

Apparently it seems interesting, but how far? Need to understand and then findout someone who did it successfully. How much do it really possible to accomplish in a huge database with 24X7 availability.

Till to understand, how much really downtime is reduced and which are the point of no returns?


Smaller or bigger?


A few minutes back, downloaded WordPress Android to try it out on my mobile. When android application are being reviewed one thing we must understand that these are very usefull and tiny application. And they are almost doing the same. The disk and the memory footprint used by these programs are one to tens of hundreds of their big brothers being used in PCs or notebooks. And they are just not too slow (although the oldest computing devices were too fast compare to computing speed of maximum human being …..So I still do not understand what is too slow as far as it is not games)…….

Real eager to see those smalls are conquring the PC and Laptops….

Some astonished reading…

Although I thought, I would write only my experiences working with SAP, Oracle etc, I recently saw this eye catching article and the related debates…But definitely this worth reading……

Sayonara Sony: How Industrial, MBA-Style Leadership Killed a Once Great Company

the no of call-outs coming out actually poking a thought how much does the MBA thought and Communism defers?

What do You think?

This is really interesting. Lots of clue on the subject helping conflict management on hosting application service…..
I and reader like me will really appreciate you if you show the script by which device names are relaced by the partition/logical volume name (more generic understanding).
Apart from this here is another puzzle..
Until recently I was wondering with a simple question but it seems the answer is pretty complex. The Question is something like…..
An application administrator before implementing the system goes to storage administrator (Lets assume it is real big storage …very big…) to allocate a chunk of TB (space /Lun/ Devices or) for his application to run. Now the application administrator feels doubt that the chunk allocated to him does not satisfy the IOPS hunger of the application. So he returns back to storage administrator and ask …Tell me what maximum IOPS possible in the storage chunks you allocated to me……The Storage administrator remain speech less…..How can he calculate the IOPS maximum possible to the storage chunks which is spread over multiple disk drives, some partially and some fully……..

Can you throw some light on it?


Dirty Cache

Does this story sound familiar?

The end users of a database application start complaining about poor system response and long running batch jobs. The DBA team starts investigating the problem. DBA’s look at their database tools such as Enterprise Manager, Automatic Workload Repository (AWR) reports, etc. They find that storage I/O response times are too high (such as an average of 50 milliseconds or more) and involve the storage team to resolve it.

The storage guys, in turn, look at their tooling – in case of EMC this could be Navisphere Analyzer, Symmetrix Performance Analyzer (SPA) or similar tools. They find completely normal response times – less than 10 milliseconds average.

The users still complain but the storage and database administrators point to each other to resolve the problem. There is no real progress in solving the problem though.

Two Way Communications

View original post 496 more words

Surprise learning – Oracle SCN no…..


, ,

Just a few minutes back I got this link shared by one my my most admired senior,,,,Yes, this is a problem…But will this start ringing the drams (as we indians do during immerson of Idols of gods and godesses)……
And force use the RMAN or equivalent things?

read this…This goes like  below

A design decision made by Oracle architects long ago may have painted some of Oracle’s largest customers into a corner. Patches have arrived, but how much will they correct?