Adding a disk to an ASM diskgroup is really simple, just an alter command. But when if you are doing this in a production database, then before adding we have to make sure that the disk is healthy. We...

REQUIREMENT: Write a shell script, which will trigger a mail alert, if the utilization of the asm diskgroup reached 90 percent. SOLUTION: 1. Below is the shell script. Make sure to update ORACLE_HOME,...

Grid installation on the standalone database server is also known as oracle Restart. This is required if you wish you use ASM file system with oracle restart feature. Oracle Restart Means, During any ...

Below are the new features of Oracle 12c version. 1. Connecting to ASM instance of remote node: Now we can connect to asmcmd prompt(asm instance) of remote node from local node. SYNTAX – asmcmd ...

      PROBLEM: One of the junior DBA mistakenly created a datafile in local filesystem instead of ASM disk group in RAC database 11g. But he is quick to realize his mistake. Below steps need to be ...

Copying file between mount points between different servers is straight forward and can be done using scp or ftp command. But transfering file between asm diskgroups of different servers  will be...

 PROBLEM: While mounting a diskgroup in restrict mode, got below error:   SQL> alter diskgroup NEWTST mount restricted; alter diskgroup NEWTST mount restricted * ERROR at line 1: ORA-15032: n...

       While dismounting a diskgroup, got the below error:   SQL> alter diskgroup NEWTST dismount; alter diskgroup NEWTST dismount * ERROR at line 1: ORA-15032: not all alterations perform...

         Below are the steps for renaming an ASM diskgroup with database files present inside for a running database.   EXAMPLE: In this article we will rename the diskgroup +DATATST to +NEW...

                    While setting attribute on a ASM diskgroup, we got below error. oracle@crmcpredb1:~$ echo $ORACLE_SID +ASM1 oracle@crmcpredb1:~$ sqlplus / as sysdba SQL*Plus: Release 12....