Oracle · Oracle Grid Infrastructure

Move ASM instance spfile out of an ASM diskgroup (using spget and spmove)

If you want to drop a diskgroup that contains the SP file of an ASM instance you will get an error. Because the diskgroup is being used by the ASM instance which is something like chicken-egg problem. If we can move the spfile somewhere else then we can drop that diskgroup. We can achieve that… Continue reading Move ASM instance spfile out of an ASM diskgroup (using spget and spmove)

Exadata · Oracle · Oracle Grid Infrastructure

“usable_file_mb” explained for Exadata asm structure

We will investigate the disk structure of a half rack exadata machine. There are 7 exadata storage servers and each one of the storage servers contains 12 hard disks. So You have total 84 disks on a half rack exadata machine. For example if you have a diskgroup (DATA) having a size of 453632 MB… Continue reading “usable_file_mb” explained for Exadata asm structure

Oracle · Oracle Grid Infrastructure · RAC

Move ASM instance spfile to an ASM diskgroup

Today my grid infrastructure installation failed and I had to set up ASM on my own not using the installer. The same situation may happen If you lost the diskgroup containing the ASM spfile. For solving the problem The only thing I need was an ASM instance and a diskgroup for my spfile. I created an init file… Continue reading Move ASM instance spfile to an ASM diskgroup

Oracle · Oracle Grid Infrastructure · RAC

Oracle HAS setup after Hostname and IP change

On my laptop, I have my virtual machines for oracle ASM and oracle RAC. I cloned one of the ASM single instance virtual machine and changed its hostname and IP adress to a new one. After I made the change the¬†database and the asm instance did not start. I learned that I had to¬†reconfigure the… Continue reading Oracle HAS setup after Hostname and IP change