Tough time ahead (going to have fun with RAC)

It is going to be a tough this week-end for me, and at the same time very challeging too. Well, this week-end, in simple terms, I can say that I am going to have fun with RAC.

We currently have 4 node develpment and 8 node Production RAC environment at our premises. The development currently running on Oracle 10g R2 with patchset 10.2.0.3, which we are planning to upgrade to 10.2.0.4. My god, there are over 20 databases running across these 4 nodes. Uff.. upgrading cluster, asm and all those databases to 10.2.0.4 patchset.. tough time!

Along with upgrade activity, we also plan the following at the same time:

Changing the IPs of public and interconnect on production.

Moving a RAC database from development to production.

Apart from the above, there are couple of small changes to be done.

I know one time such a big change is not recommended and a very tough task too. Thankfully, we are not really  into production yet,  we have ample of downtime to carry out/complete all these tasks.

Wish me best of luck and I will blog about any issues that I faced during this activity.

Happy reading,

Jaffar

ORA 22 invalid session id; access denied

My colleage was badly struck with the 'ORA 22 invalid session id; access denied'  

problem while connecting to any database from an AIX machine (where Oracle client was installed).

All the links including ML note to this errors, never helped to resolve the issue.

In our case, the problem occured because the hostname of this machine was mentioned wrongly in the /etc/hosts file.

Once we corrected the hostname in the hosts file, problem has been resolved.

Regards,

Jaffar

A very happy New Year

Wishing you and your family a very happy and prospers New Year. 

May this New Year bring tons of happiness in your life.

Jaffar

How to boost RMAN performance on AIX5L systems

I have come accross of following two metalinks notes on 'how to improve RMAN performance on AIX5L based systems' and felt worthy blogging about it:

ML 421059.1 : How to boost the performance of RMAN on AIX5L Based Systems

ML 579158.1 : Advise On How To Improve Rman Performance

Excerpt from the ML notes.

IBM suggestions the following AIX related advices:

1. set AIXTHREAD to S on /etc/environment.

2. " ioo -o maxpgahead=256 " to set maxpgahead parameter
Initial settings were : Min/Maxpgahead 2 16

3. " vmo -o minfree=360 -o maxfree=1128 " to set minfree and maxfree...
Initial settings were : Min/Maxfree 240 256

The goal of setting those parameters would be Getting %15-20 performance improvements on RMAN backup performance on AIX 5L Based Systems.

Happy Reading,

Jaffar

A New Family Member in my life

By the grace of almighty we have been blessed with a new baby BOY (a third one) yesterday (7-11-2008) at 8:14pm local Saudi Time. We named him AAHIL.

Regards,

Mrs and Mr. Jaffar