Category Archives: GI and RAC

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

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

The Master Node of RAC Cluster

1) Check from ocssd.log: $ cat $GRID_HOME/log/racnode1/cssd/ocssd.l* |grep ‘master node’ |tail -1 2017-07-18 10:09:21.431: [ CSSD][1102125408]clssgmCMReconfig: reconfiguration successful, incarnation 217002855 with 2 nodes, local node number 2, master node number 2 2) Check from crsd.log $ cat $GRID_HOME/log/racnode1/crsd/crsd.l* |grep ‘OCR … Continue reading

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

ORA-02065: illegal option for ALTER SYSTEM

In an old 10g database, when tried to change SGA_TARGET parameter in spfile, “ORA-02065: illegal option for ALTER SYSTEM” occurred. $ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 – Production on Tue Jun 13 15:56:37 2017 Copyright (c) 1982, 2010, … Continue reading

Posted in Configuration, GI and RAC, ORA- ERRORS | Tagged , | Leave a comment

Tablespace SYSMGMTDATA Is Full in GIMR Database (-MGMTDB)

1) Check the datafile of tablespace SYSMGMTDATA in PDB: SQL> select PDB_NAME from dba_pdbs; PDB_NAME ——————————————————————- RACTEST PDB$SEED SQL> alter session set container=RACTEST; Session altered. SQL> select TABLESPACE_NAME,FILE_NAME,AUTOEXTENSIBLE,BYTES/1024/1024,MAXBLOCKS/1024/1024 from dba_data_files where TABLESPACE_NAME=’SYSMGMTDATA’; TABLESPACE_NAME FILE_NAME AUT BYTES/1024/1024 MAXBLOCKS/1024/1024 —————- ———————————————————————- — … Continue reading

Posted in 12c new features, CDB/PDB, GI and RAC | Tagged , , , , , , , | Leave a comment

Duplicate Database Without Connecting To Target Database From RAC ASM to RAC ASM

Here is an example of refreshing RAC  TEST database from source RAC PROD database without connecting to source RAC PROD database by using its backups on tapes. Environment: 1)Duplicate RAC Database: RACTEST (ractest1, ractest2) — to be duplicated and refreshed from … Continue reading

Posted in GI and RAC, RMAN Restore and Recovery | Tagged , , , , , , , | Leave a comment

CRS-4535: Cannot communicate with Cluster Ready Services

This error is caused by crsd not running, while both cssd and evmd processes are running. Also all the database instances are running. Environment is 12.1.0.2 GI and 11.2.0.4 databases. $ crsctl check crs CRS-4638: Oracle High Availability Services is … Continue reading

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