Posts Tagged ‘RAC’
Cluvfy Reports CRS not Installed on Nodes
Before I start my post, I would like to wish all our readers a “Happy New Year”. While reviewing a 10gR2 RAC configuration I faced following errors on invoking cluvfy utility $ ./cluvfy stage -post crsinst -n prod01,prod02 -verbose Performing post-checks for [Read More]
Link:11gR2 RAC installation steps on OEL4
If you are looking for steps for 11gR2 RAC installation, you can refer to this article by Rajeev Ramdas at Dbastreet.com. Article lists down steps for installing 11gR2 RAC on 64 bit Oracle Enterprise Linux 4 (OEL4) using ASM for storage. As Raw devices are no longer [Read More]
OCFS2 Configuration Issue
While setting up ocfs2 for OCR and Voting disk storage with following commad: # ocfs2console After clicking on ==>cluster ==> configure nodes, I got a pop-up saying: <span style="font-size: small;"><span style="font-family: [Read More]
Link: Best practices for AIX RAC Database on OTN
A new whitepaper has been published on OTN which primarily discusses best practices for AIX 5.2,5.3 and 6.1 for RAC database for avoiding node eviction due to Oprocd. It also mentions recommended AIX VMO parameters and recommended patches for Oracle RAC. You can find the [Read More]
SRVCTL fails to start RAC resources:CRS-0215
After upgrading RAC database to 10204 and applying CRS bundle patch-1 for 10204 crs home, srvctl command fails to startup resources on rac nodes. While starting up RAC resources using SRVCTL following error occurs in CRSD.log file: $ srvctl start instance -d rac -i rac2 [Read More]
OUI-67124 – Copy failed from ‘location 1′ to ‘location 2′
Just a short note to discuss a problem faced by me while applying CPU Jan patch to clusterware on AIX 5L. I was getting following errors UtilSession failed: ApplySession failed in system modification phase... 'ApplySession::apply failed: Copy failed from [Read More]
Creating ASM devices on AIX
I thought of sharing few tips on creating ASM devices on AIX which I will be helpful to Oracle DBA’s. Suppose SysAdmin gives you list of Serial numbers for LUN instead of device Name pcmpath query device DEV#: 33 DEVICE NAME: hdisk33 TYPE: 2107900 ALGORITHM: Load [Read More]
CRS Fails to Start – 10.2.0.1 RAC Install on AIX
I was installing 10.2.0.1 on IBM AIX 5L and while running root.sh from first node (as part of Clusterware installation) got following messages Now formatting voting device: /dev/voting_disk01 Now formatting voting device: /dev/voting_disk02 Now formatting voting device: [Read More]
Creating Oracle Extended RAC on Oracle VM
Yesterday, I found one very useful article at OTN “Creating Oracle Extended RAC” on completely virtual environment using Oracle VM. As Virtualization is becoming popular day by day and is very cost effective, one must know how to use this to simulate actual [Read More]
10g RAC Tuning :Useful Link
I came across useful link which contains 10g RAC Tuning tips from Joel Goodman (Oracle). It discusses RAC Instance Recovery concepts and key things to look out for while tuning RAC (Real Application Clusters) Databases. Must watch for anyone who is learning RAC. You can [Read More]
How To Recover From Corrupted OCR Disk
It is very common where a DBA is left with corrupted OCR disk without having any good backup. The same situation was experienced by me few days back. One node of RAC database shows the following: NODE1: <span style="font-family: [Read More]
Issues with CLUSTER_DATABASE parameter
Yesterday, I faced an interesting scenario while upgrading 2 Node RAC Database. I tried setting up CLUSTER_DATABASE=FALSE in spfile from Node 1,but it displayed value as TRUE after restarting database.Same was true for Database startup entries in Alert log. If I did the [Read More]
UNKNOWN State Of RAC Resources
While Checking the status of database resources, ASM was shown as UNKNOWN on one node of a two node RAC. $ crs_stat -t <span style="font-family: arial,helvetica,sans-serif;">Name Type Target State Host [Read More]
Using RDA As RDBMS Pre-Install Check Tool
Many of us would have come across RDA (Remote Diagnostic Agent) while working on a ticket with Oracle support. In case you have not heard about it, I would recommend to go through Metalink Note:314422.1 – Remote Diagnostic Agent (RDA) 4 – Getting Started RDA [Read More]
Upgrading Oracle RAC Database -10g
Continuing my experiments with our 2 Node 10g RAC Test system, I carried out upgrade of Oracle Clusterware and Oracle RAC Database from 10.2.0.1 to 10.2.0.4. I have tried to document the steps for upgrading Oracle Clusterware(Rolling Upgrade) and RAC Database upgrade in [Read More]
