Category Archives: GI and RAC

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 GI and RAC, Configuration, 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

ORA-16826: apply service state is inconsistent with the DelayMins property

We received the OEM alert by complaining DataGuard status with error as “ORA-16826: apply service state is inconsistent with the DelayMins property”. Oracle official explanation is as below : $oerr ora 16826 16826, 0000, “apply service state is inconsistent with … Continue reading

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

ORA-01105: mount is incompatible with mounts by other instances ORA-19808: recovery destination parameter mismatch

When tries to start up one instance of the RAC , got below errors. ….. …. ORA-01105: mount is incompatible with mounts by other instances ORA-19808: recovery destination parameter mismatch … Check flash recovery parameters on other node: SQL> show … Continue reading

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

Create a RAC Standby Database From Overnight RMAN Tape Backups

Here is a practical example of building a RAC standby database by using overnight  NetBackup RMAN backups. Primary RAC servers: racnode1,racnode2 Standby RAC servers: stdbynode1,stdbynode2 Primary Database Name: RACTEST Primary Instance Names: RACTEST1/2 Standby Instance Names: STBTEST1/2 RAC Database version: … Continue reading

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

ERROR: Unable to get logical block size for spfile ‘+DATA1/RACTEST/spfileRACTEST.ora’

Created 12.1.0.2 CDB/PDB database through DBCA, there are a lot of below errors in alert.log. Mon Oct 24 23:33:11 2016 ERROR: Unable to get logical block size for spfile ‘+DATA1/RACTEST/spfileRACTEST.ora’. Mon Oct 24 23:33:11 2016 ERROR: Unable to get logical … Continue reading

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

How to Drop a RAC Database

A. Startup database in mount status. SQL> startup mount; ORACLE instance started. Total System Global Area 1.7180E+10 bytes Fixed Size 7663544 bytes Variable Size 3120562248 bytes Database Buffers 1.4026E+10 bytes Redo Buffers 25890816 bytes Database mounted. B. Try to drop … Continue reading

Posted in GI and RAC | Tagged , , , , , , | 1 Comment

Change ASM User SYS ASMSNMP Password in 12c

To see where the password file is located : $ asmcmd ASMCMD> pwget –asm +OCR_VOTE/orapwASM ASMCMD> cd +OCR_VOTE ASMCMD> ls -l orapwASM Type Redund Striped Time Sys Name PASSWORD UNPROT COARSE AUG 08 17:00:00 N orapwASM => +OCR_VOTE/ASM/PASSWORD/pwdasm.256.919359249 ASMCMD> cd … Continue reading

Posted in 12c new features, Configuration, GI and RAC, User Privileges and Roles | Tagged , , , | Leave a comment