Category Archives: ASM

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 , , , , , , , | Leave a comment

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

PRVG-10091 : failed to retrieve the ASM password file location for an ASM instance

Problem Verifying system upgrade readiness for Grid Infrastructure 12.1.0.2 to 12.2.0.1 with below command, then get “PRVG-10091” warning: $ /u01/app/12.2.0.1/grid/runcluvfy.sh stage -pre crsinst -upgrade -rolling -src_crshome /u01/app/12.1.0.2/grid -dest_crshome /u01/app/12.2.0.1/grid -dest_version 12.2.0.1.0 -fixupnoexec -verbose … .. . Verifying Verify that the ASM … Continue reading

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

How to Disable SELinux or Set SELinux to Permissive Mode

It is suggested to disable SELinux or set SELinux to permissive mode for Oracle GI/RAC. Otherwise you might get similar below errors: Disk “ASM_DISK1” does not exist or is not instantiated Writing disk header: done Instantiating disk: oracleasm-instantiate-disk: Unable to … Continue reading

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

ORA-15260: permission denied on ASM disk group

Problem Try to set ASM diskgroup attribute, then get below errors: $ sqlplus / as sysdba … .. . SQL> alter diskgroup OCR_VOTE SET ATTRIBUTE ‘compatible.asm’ =’11.2.0.2′; alter diskgroup OCR_VOTE SET ATTRIBUTE ‘compatible.asm’ =’11.2.0.2′ * ERROR at line 1: ORA-15032: … Continue reading

Posted in ASM, GI and RAC, ORA- ERRORS, User Privileges and Roles | Tagged , , | Leave a comment

Move OCR, Voting Disk File, ASM SPILE to a New Diskgroup ( 11.2.0.4 )

Below exercise is to move everything from old OCR/VOTING diskgroup OCR_VOTE  to new diskgroup OCR_VOTE2. 1)Create New CRS Diskgroup: SQL> create diskgroup OCR_VOTE2 external redundancy disk ‘ORCL:OCR_VOTE2’; Diskgroup created. SQL> alter diskgroup OCR_VOTE2 set attribute ‘compatible.asm’=’11.2.0.0’; Diskgroup altered. 2) Mount … Continue reading

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

How to Move Datafiles From One Diskgroup DATA1 to Another Diskgroup DATA2 For a Standby Database

TASK This task is to move all the datafiles of diskgroup DATA1 to another diskgroup DATA2 for a standby database. SOULUTION 1)Check the diskgroup space availability SQL> set pagesize 120 SQL> set linesize 180 SQL> select NAME,TOTAL_MB/1024,FREE_MB/1024,USABLE_FILE_MB/1024 from v$asm_diskgroup; NAME … Continue reading

Posted in ASM, DataGuard, RMAN Restore and Recovery | Tagged , , , , , , , | Leave a comment