Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Oracle

Posted Jul 6, 2006

Installing 10gR2 Clusterware on Redhat 4.2 Advanced Server - Page 2

By Tarry Singh

When the installation is almost done, you will be prompted to run orainstRoot.sh and root.sh scripts. You will have to open a new console (do not do it in the same console as your installer!) beginning from the primary node where you are carrying the installation and logged in as "root" run the script.

Now go the the /u01/app/oracle/oraInventory directory and run orainstRoot.sh. You have to do this on ALL NODES!

As you can see, it changes the permissions of the oraInventory and assigns DBA the group name of the same directory.

There are many discussions about miscounts, specifically to the VMware environment (like VMware Server OR Workstation), where the overhead might just not be supportive enough to allow for a full and robust functioning of our RAC. This is also necessary when running DBCA in order to install our database. Not doing so might result in an ora-03113 error.

What actually is the problem then? In VMware you might encounter slower disk responsiveness (depending on how fast and what configuration you have for your disks, I had success on an old server with RAID0 and problems with a RAID 5/SAN disk) . However, this does not have to be the case for VMware RAC testbed, it can also occur in a poorly selected hardware configuration. The CSS miscount has a default value of 60 and happens to be a bit too small for the CSS to miss the heartbeat and eventually ending up evicting the node and thus throwing the ora-03113 error. Beginning with the Oracle 10gR1 series, the algorithm has changed to allow a lengthier timeout. I have had success with 300, but you can go as high as 600. So now, the question arises of how to do it. If you haven’t done it, do it now by doing:

Query your nodes:

$ORA_CRS_HOME/bin/crsctl get css misscount
   60

Query again:

$ORA_CRS_HOME/bin/crsctl get css misscount
   360

Now we go about installing the root.sh script:

You do see that the clscfg complains that the miscount must be below 360 and that is when I went looking for the trade off, trying to set it just below 300. Moreover, after doing so you will need to run this root.sh on ALL NODES!

Despite the error of that ONS (Notification Services daemon), I was able to successfully conclude the installation. The last node runs the VIPCA (VIP Configuration Agent).

As you can see, the configuration starts:

And completes successfully.

Doing a quick check on the cluster nodes:

And also checking if all the daemons will start automatically:

Conclusion:

In this article, we took our first steps towards installing the Oracle Clusterware and as you saw yourself, the installation went fine. That was due to the painstaking and yet rewarding preparatory efforts that we put in the beginning of our series. In our next article, we will go ahead and install Oracle software and the Companion CD. Then we will take on our DBCA (Database Creation Assistant). In our Oracle RAC administration series, we will go ahead and administer the clusterware components. Although I had started this series to do a Windows and Linux RAC installation, I am tempted to look at HP-UX, AIX and Solaris too, hopefully my VMware server will get out of beta and I can get on with these configurations as well.

» See All Articles by Columnist Tarry Singh



Oracle Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM