Category Archives: GI and RAC

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

Data Guard Not Applying Logs After RAC Standby Database Restarted

11.2.0.4 RAC standby database is not applying archivelogs after instances are all restarted.  It is configured in Data Guard management. After investigation, there is nothing special, but only “PreferredApplyInstance” is configured for RAC node1 ‘STBTEST1’. Original : PreferredApplyInstance =’STBTEST1′ Modify … Continue reading

Posted in 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 Clone Oracle RAC Home in 12c

Here is an example of how to clone 12.1.0.2 RAC home from one cluster to another cluster. Source RAC home : /u01/app/oracle/product/12.1.0/dbhome_1 Target RAC home: /u01/app/oracle/product/12.1.0/dbhome_3   1) As root user, create a copy of the source RAC home on source … Continue reading

Posted in 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

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

CRS-4995: The command ‘Delete resource’ is invalid in crsctl. Use srvctl for this command.

Situation Trying to delete the database resource “ora.RACTEST.db” by using CRSCTL, because ORACLE_HOME has been uninsulated. But below error occurred. $crsctl delete resource ora.RACTEST.db CRS-4995: The command ‘Delete resource’ is invalid in crsctl. Use srvctl for this command. Solution Add … Continue reading

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

ohasd failed to start

Situation : 1) Two 11.2.0.4 RAC nodes( racnode1/2). Deleted node racnode2 . Upgraded OS from RHEL 4  to RHEL 7 for racnode2, then tried to add node racnode2 back into cluster from racnode1. 2) export IGNORE_PREADDNODE_CHECKS=Y, Ran addnode.sh ->  orainstRoot.sh->root.sh, … Continue reading

Posted in GI and RAC, Upgrading and Patching | Tagged , , , , , , , , , , | Leave a comment

Copy Oracle Home Binary from One RAC Node to Another RAC Node

For some reason on RAC node 2 ( racnode2) , RAC oracle home binary needs to be copied from another node racnode1. 1)As RAC Oracle home owner, go to ORACLE_HOME/oui/bin  on racnode1: oracle@racnode1:/u01/app/oracle/product/11.2.0/dbhome_1/oui/bin$ ./addNode.sh “CLUSTER_NEW_NODES={racnode2}” Performing pre-checks for node addition … Continue reading

Posted in GI and RAC, Install and Upgrade | Tagged , , , , | Leave a comment