This content has been marked as final. Show 6 replies
Is this 10g a mandatory or can you install 11gR2 - The management is MUCH more simple. You can even use 11gR2 GRID+ASM on a 10g database, so my advice is to install 11gR2 GRID+ASM. ASM is installed as a part of GRID and you no longer "create" an ASM instance like 10g. The installer will do it for you.
Now, if you want to completely start over with ASM and you need to erase the devices:
dd if=/dev/zero of=<ASMdiskPartition> bs=8192 count=100 on ALL of the ASM devices. WARNING, THIS WILL COMPLETELY ERASE THESE DEVICES.
There is a note in MOS that describes how to completely remove clusterware.
I am glad that you replied my question. Currently, my situation is that I have completely removed this nasty incomplete ASM. But I could never make a complete RAC ASM install in these two days. My current problem is that:
All raw disks detected for the diskgroup. Both available nodes are detected by dbca. But this dirty dbca window keeps on running for 3 hours saying that "Asm Disk Group Creation....". But, so far no completion. In fact I am getting same thing in my last 3 or 4 attempts. If it says some errors I will be at least happy and satisfied and move on ahead recovering the error. But this says nothing and keeps on running. What could be the culprit behind it.?
This is a test environment and not 10g mandatory. But still, I want to complete it anyway.
Now I have given up my mind 99% and thinking to create a rac-ASM manually. But I don't know how to do it. I need to google it or let me know if you have any link for doing this.
If it is not mandatory and for test purposes only, I would use 11g as 10g is about to be de-supported. Make sure your permissions on the asm devices are correct and you are not using a partition that includes the first cylinder (1M) of the device(s). ( example use partition 1 starting at cylinder 2.)
I have completely succeeded in 2 node rac ASM configuration and the disks have been mounted at both ends. When I create the database using DBCA, it says
"DBCA could not startup the ASM instance configured on this node. To proceed with database creation using ASM you need the ASM instance to be up and running. Do you want to recreate the ASM instance on this node?"
What may be the reason? When I checked with crs_stat -t and srvctl start service commands I could see the error that it looks for the wrong asm pfile (ie) it looks for init+ASM2.ora file but the actual one is init+ASM1.ora in node 1, and says could not open the parameter file.
Where to edit to have the right pfile? Is it the entry in OCR?
What to do to make it view the right pfile?
Kindly, guide me.
init+ASM2.ora file was there during previous asm install. Now I removed it and the new one is init+ASM1.ora which is in the same oracle home. It looks for the previous pfile when I give the command srvctl start listener -n testarac2. Kindly guide mw how to make it look for the current one.
Edited by: 915421 on Jul 29, 2012 1:34 AM