Category Archives: ASM

Asmcmd Pwcopy With PRCD-1163 PRCR-1071 CRS-0245 ASMCMD-9453 Errors

After standby database rebuilt, and trying to copy database password file from primary to standby ASM disk, the below errors occurred: ASMCMD> pwcopy –dbuniquename RACTEST ‘/tmp/orapwractest’ ‘+DATA/RACTEST/orapwractest’ copying /tmp/orapwractest -> +DATA/RACTEST/orapwractest PRCD-1163 : Failed to modify database RACTEST PRCR-1071 : … Continue reading

Posted in ASM, Configuration, DataGuard | Tagged , , , , , , , | Leave a comment

Query on v$asm_diskgroup Hangs

Due to underneath SAN LUN issue, after manually dismounting problem disk group, the queries on v$asm_* views hang forever. 1)  Check blacking sessions, and find blocking session is SID=426, and the final blocking session us SID=392. SQL> select SID,LAST_CALL_ET,EVENT,BLOCKING_SESSION,FINAL_BLOCKING_SESSION from … Continue reading

Posted in ASM | Tagged , , | Leave a comment

How to Prevent ASM Diskgroup Automatic Mount

1) To disable certain ASM Diskgroup automatic mount on all RAC nodes, run below command as grid user: $ srvctl disable diskgroup -diskgroup testdg 2) To disable certain ASM Diskgroup automatic mount on specific RAC node, run below command as … Continue reading

Posted in ASM | Tagged , , , | Leave a comment

How to Install and Configure ASMLIb on RHEL Linux 7

Make sure oracleasm packages are installed , go to Red Hat website to download the required ones: $ rpm -qa|grep -i oracleasm kmod-oracleasm-version.el7.x86_64 oracleasm-support-version.el7.x86_64 oracleasmlib-version.el7.x86_64 Check orcaleasm.service is activated: # systemctl is-enabled oracleasm.service enabled Check  oracleasm kernel module is installed: … Continue reading

Posted in ASM, Configuration | Tagged , , , , , , , , , , , | Leave a comment

WARNING: FAILED to load library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so

Database instance starts up failure with below errors: ORA-15183: ASMLIB initialization error [driver/agent not installed] Wed Jan 31 17:48:16 2018 WARNING: FAILED to load library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so Check “oracleasm.service” with errors: # systemctl status oracleasm.service oracleasm.service – Load oracleasm Modules Loaded: … Continue reading

Posted in ASM, GI and RAC, ORA- ERRORS, Upgrading and Patching | Tagged , , , , , , , , , | Leave a comment

Huge ASM LMHB trace File Size in 12cR1

The ASM LMHB trace file is huge in 12.1.0.2 GI environment. $cd /u01/app/grid/diag/asm/+asm/+ASM1/trace $ ls -ltr *lmhb* -rw-r—– 1 grid oinstall 11551946219 Jan 8 16:59 +ASM1_lmhb_88049.trc According to (Doc ID 2137683.1), it is a known bug, which is fixed in 12cR2 … Continue reading

Posted in ASM | Tagged , , | Leave a comment

How to Make ASM Instance to Use HugePages

The ASM instance is configured in the same way as normal databases instance for using hugepages in Linux 6. But ASM is not using hugepages, while the normal instance is using hugepages. There are enough free hugepages available  as per … Continue reading

Posted in ASM, GI and RAC | Tagged , , , , , , , , , , , | Leave a comment

How to Copy ASM Password File From Primary to Standby in 12cR1

12.1.0.2 primary database password file is stored in ASM, so it needs to be manually copied onto standby database ASM for dataguard configuration. Otherwise the below errors will occur: *** 2017-09-06 14:34:29.216 OCISessionBegin failed. Error -1 .. Detailed OCI error … Continue reading

Posted in 12c new features, ASM, Configuration, DataGuard, GI and RAC | Tagged , , , , , , , | 3 Comments

ORA-15001: diskgroup does not exist or is not mounted. ORA-15040: diskgroup is incomplete

SYMPTOM              GI: 12.2.0.1.170814 (26609817)         RAC HOME: 12.1.0.2.160419 (22291127) Just started to build a standby database. Tried to put standby database controlfile into ASM diskgroup by using RMAN , got below errors: RMAN> … Continue reading

Posted in 12c new features, ASM, GI and RAC | Tagged , , , | Leave a comment

How to Find Mapping Between ASM Disks and Physical Disks

Here are the simple steps for mapping between ASM disks and physical disks in Linux 7.3 and GI 12cR2. 1) List all ASM disks: $oracleasm listdisks … .. . OCR_VOTE .. . 2) To get the major and minor number … Continue reading

Posted in ASM, GI and RAC | Tagged , , , , | Leave a comment