Clusterized (Cluster Aware) Commands

Unlike the previous Oracle versions, beginning with Oracle 11gR2,  Oracle Clusterware stack on all nodes in a cluster can be managed from any node using the following Clusterized (Cluster Aware) commands:

$ crsctl check cluster -all - to check the status of the Clusterware on all nodes
$ crsctl stop cluster -all - to stop the Oracle Clusterware stack on all nodes
$ crsctl start cluster -all - to start the Oracle Clusterware stack on all nodes 

Voting Disk Backup Procedure Changed in Oracle 11g Release 2

Surely we are going to have too many posts on Oracle 11gR2 new feature by many people and here is mine first post.

As part of our new forthcoming book on 'Oracle 11g Clusterware' by Packt Publications, I have done Oracle 11g R2 clusterware upgrade from Oracle 11gR1 and it was a good learning experience.

Voting Disk backup Procedure Change
In prior releases, backing up the voting disks using a dd command was a required postinstallation task. With Oracle Clusterware release 11.2 and later, backing up and restoring a voting disk using the dd command is not supported.

Backing up voting disks manually is no longer required, as voting disks are backed up automatically in the OCR as part of any configuration change and voting disk data is automatically restored to any added voting disks.

Oracle 11g Scheduler book by Packt Publishing

Mr. Ronald Rood wrote a book on Oracle Scheduler, titled 'Mastering Oracle Scheduler in 11g Oracle Databases' and the book will be out somtime in May. 

When publishers were seeking for technical reviewrs on this book,  I have shown my interest to be part of the reviewers team.  My inital impression on this book was not satisfactory one, I ask myself, a book on Scheduler?.  Beleive me, after reviewing the book, I realized the real strngths of Oracle Scheduler and how it can be utilized flly in complex scenarios.  Now, I am really happy to be part of the reviewers team for this book and I did learn few new Oracle 11g Scheduler enhancements and planning to implement few some of the features that suits to our requirements.

The book is due this May and for more details and pre-order details, you can use the following link:

http://www.packtpub.com/mastering-oracle-scheduler-in-oracle-11g-databases/book/mid/200409ax2i1w

Oracle to acquire SUN?

I have seen couple of mails today on freelist group stating about the news, 'Oracle going to acquire SUN'. Umm.. quite interesting deal, one has to wait and see what would be the reaction of HPUX, specially after their (Oracle and HPUX) recent exadata innovation and IBM reaction on this deal.

Read more at http://www.oracle.com/sun/index.html.

Happy reading

Jaffar

Node slave process (pz99) on 10g RAC

We have observed a strange slave process, 'pz99' on our RAC databases for every connection to the database and we were wondering what type of processes are they. Thank god our doubt was cleared without much hassles. According to ML Doc :734139.1 'From Oracle 10g onwards you will find on every node slave processes like pz99. This are the processes that query the gv$ views'

Happy reading

Jaffar