ORA-15477: cannot communicate with the volume driver (dbd error: ocistmtexecute)

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.

https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/

 

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *