ora errors, Oracle

ORA-15032 , ORA-15017 , ORA- 15040 , ASM Disk-group not found!!

Hello friends, this is something fun which I came across, while trying to troubleshoot an ASM issue.
Usually we know that the diskgroups are an important entity of the ASM infrastructure and working of the database depends a lot upon them.
This particular issue was seen on the standalone ASM database. The ASM diskgroup was nowhere to be found while querying the v$asm_diskgroup and v$asm_disks dynamic tables.

Continue reading “ORA-15032 , ORA-15017 , ORA- 15040 , ASM Disk-group not found!!”
Oracle

Adding disks to ASM diskgroup

Often we DBA’s face the issue of running out of space, hence adding new disks to the diskgroup is one of the major part of DBA’s daily routine.
Here is a handy guide for freshers on how to add a disk to ASM diskgroup

Continue reading “Adding disks to ASM diskgroup”
Oracle

ASM installation on Windows

This article also assumes you are using Oracle version 11g Release 2 -specifically, 11.2.0.4. That is the latest version of Oracle available for general free download at the time of writing, and if it’s not the version you are using, I suggest that you upgrade immediately. I should add that I am using and describing the 32-bit version of Oracle 11g, and have no idea whether the 64-bit version works similarly or not at all!

In this article, as well as simulating a 6GB ASM array (which will require 6GB of free disk space), I’m going to show you how to convert a pre-existing database that is stored on a traditional file system into one that uses ASM exclusively. That is an important capability of Oracle’s RMAN tool, and the instructions therefore apply equally to Linux and Unix users as to Windows ones. I will also show you how to get Enterprise Manager to administer and monitor your ASM array -and that again is something that applies equally to all ASM users, not just Windows ones.

Continue reading “ASM installation on Windows”