Hi,
Sometimes You can get ” ORA-15477: cannot communicate with the volume driver (dbd error: ocistmtexecute) ” error.
Details of error are as follows.
ORA-15477: cannot communicate with the volume driver
SQL> ALTER DISKGROUP DATA set attribute 'compatible.advm'='11.2.0.0';
ALTER DISKGROUP DATA set attribute 'compatible.advm'='11.2.0.0'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15242: could not set attribute compatible.advm
ORA-15238: 11.2.0.0 is not a valid value for attribute compatible.advm
ORA-15477: cannot communicate with the volume driver
Since the directory structure is missing for /dev/asm/* you may get errors like below
SQL> ALTER DISKGROUP DATA set attribute 'compatible.advm'='11.2.0.0';
ALTER DISKGROUP DATA set attribute 'compatible.advm'='11.2.0.0'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15242: could not set attribute compatible.advm
ORA-15238: 11.2.0.0 is not a valid value for attribute compatible.advm
ORA-15477: cannot communicate with the volume driver
Please reinstall the acfs drivers by following the How To Install/Reinstall Or Deinstall ACFS Modules/Installation Manually? (Doc ID 1371067.1)
Post install verify if the directory structure exsts and then try again
ls -latr /dev/asm/ total 0 brwxrwx--- 1 root asmadmin 252, 0 Mar 19 14:22 .asm_ctl_spec brwxrwx--- 1 root asmadmin 252, 2 Mar 19 14:22 .asm_ctl_vmb brwxrwx--- 1 root asmadmin 252, 1 Mar 19 14:22 .asm_ctl_vdbg brwxrwx--- 1 root asmadmin 252, 10 Mar 19 14:22 .asm_ctl_vbg0 brwxrwx--- 1 root asmadmin 252, 11 Mar 19 14:22 .asm_ctl_vbg1 brwxrwx--- 1 root asmadmin 252, 12 Mar 19 14:22 .asm_ctl_vbg2 brwxrwx--- 1 root asmadmin 252, 13 Mar 19 14:22 .asm_ctl_vbg3 brwxrwx--- 1 root asmadmin 252, 14 Mar 19 14:22 .asm_ctl_vbg4 brwxrwx--- 1 root asmadmin 252, 15 Mar 19 14:22 .asm_ctl_vbg5 brwxrwx--- 1 root asmadmin 252, 16 Mar 19 14:22 .asm_ctl_vbg6 brwxrwx--- 1 root asmadmin 252, 17 Mar 19 14:22 .asm_ctl_vbg7 brwxrwx--- 1 root asmadmin 252, 18 Mar 19 14:22 .asm_ctl_vbg8 drwxrwx--- 2 root asmadmin 280 Mar 19 14:22 . drwxr-xr-x 13 root root 4200 Mar 19 14:22 ..
SQL> ALTER DISKGROUP DATA set attribute 'compatible.advm'='11.2.0.0';
OR
Add “umask 022” in GI_Home/root.sh at the time of installation.
Do you want to learn more details about Data Redaction in Oracle Database , read the following post.
What is the Oracle ASM Cluster Filesystem (ACFS) and How to Create ACFS
Do you want to learn more details about RMAN, then read the following articles.