ORACLE: How to change the Oracle 21c ASM instance from MEMORY_TARGET to SGA_TARGET (Use HugePages)
First of all, why do we want do change the memory settings for the ASM instance at all? There are many reasons why you might want to do it. The…
ORACLE: ASM – Backup And Restore DiskGroup Metadata With Oracle 21c
Starting with Oracle 11g, Oracle extended the ASMCMD command to include ASM disk group metadata backup and restore functionality. For a list of all commands added with 11g, take a…
ORACLE: PRKF-1125 : multiple values specified for the single value option “diskstring”: /dev/sd*,/dev/nvme0*
Have you ever tried to modify the ASM diskstring with the srvctl utility. I mean, not changing the diskstring, but adding a new one to it. Due to the documentation,…
ORACLE: How To Create Udev Rules for Oracle 21c ASM on Oracle Enterprise Linux 8.7
In case you want to fire up an Oracle 21c ASM instance on your Oracle Enterprise Linux 8.7, you have a few possibilities. E.g. you could use the asmlib driver…
How To Implement Unified Auditing For An Oracle 19c ASM Instance
Do you know what is going on in your Oracle database? Probably yes, because you have implemented auditing and check the audit trail regularly. But do you know what is…
A Few Things You Might Want To Add To Your Backup Strategy If You Have Oracle Restart 19c And ASM
For most people out there in the Oracle wild, a standard RMAN might be sufficient. However, in case you have Oracle Restart and ASM in place, I would consider to…
How to Move the Oracle 19c ASM Password File In And Out of ASM
Per default, the Oracle ASM Password file is located in ASM itself. To be more precise, it is in the following location +DATA/orapwasm which is a symbolic link to orapwasm…
How To Clone A CentOS/RHEL 8.2 Virtual Box VM With A Pre-Installed 19c Oracle Restart Grid Infrastructure
I am planning to clone my Virtual Box VM which is already installed and configured with Oracle Restart 19c and patched with the October 2020 RU (19.9.0.0.0). However, instead of…
How To Create Udev Rules for Oracle 19c ASM on CentOS/RHEL 8.2
In case you want to fire up an Oracle 19c ASM instance on your CentOS/RHEL 8.2, you have a few possibilities. E.g. you could use the asmlib driver or you…