Category Archives: GI and RAC

CRS-2412: The Cluster Time Synchronization Service detects that the local time is significantly different from the mean cluster time

In crs alert.log, below message is shown every 30 minutes in 12.2.0.1 GI. [OCTSSD(9932)]CRS-2412: The Cluster Time Synchronization Service detects that the local time is significantly different from the mean cluster time ctss is running in observer mode, because NTP … Continue reading

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

How to Apply April 2018 RU Patches

Here is the GI environment to be patched: GI HOME: 12.2.0.1 DB HOMES: 12.2.0.1 12.1.0.2 11.2.0.4 Patches downloaded : GI HOME: 12.2.0.1 : Combo OJVM Update 12.2.0.1.180417 and GI Update 12.2.0.1.180417 Patch 27726454, or – 27468969/ 27674384 DATABASE APR 2018 … Continue reading

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

RAC Database Hanging with “gc buffer busy acquire” and “gc buffer busy request” Wait Events

There is a RAC database hanging for a short period of time with high “gc buffer busy acquire” and “gc buffer busy request” wait events by sql id =”4vs91dcv7u1p6″: insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, … Continue reading

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

How to Relink Oracle 12CR2 Grid Infrastrure ( GI ) Binary

1)Change ownership of some root owned files like extjobO and jssuO, etc, because the relink script will be run as “grid’ user to change the file permissions. Otherwise, the relink will fail from the below commands in scripts: … .. . chmod … Continue reading

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

How to Remove Oracle RAC Software

1)Check to make sure there is no database still using this ORACLE_HOME: $ srvctl status database -thishome 2) De-install the binary of Oracle RAC HOME cleanly by: $ /u01/app/oracle/product/12.1.0/dbhome_1/deinstall/deinstall — logs: Checking for required files and bootstrapping … Please wait … Continue reading

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

SRVCTL Useful Commands

1)To check status of databases that are configured in this Oracle Home. $ srvctl status database -thishome 2) To check status of databases that are of the same Oracle product version. $ srvctl status database -thisversion

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

How to Update Opatch Utility of GI Home

Due to GI_HOME restricted access, you might get below errors when you extract opatch utility to GI_HOME: checkdir error:  cannot create /u01/app/12.2.0.1/grid/OPatch                  Permission denied                  unable to process OPatch/config/opatch.properties. Below is one of the appropriate way for extracting opatch … Continue reading

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

CRS-4535: Cannot communicate with Cluster Ready Services

Two nodes 12.2.0.1 GI clusterware is not healthy as below, while everything else is all good. $ crsctl stat res -t CRS-4535: Cannot communicate with Cluster Ready Services CRS-4000: Command Status failed, or completed with errors. $ crsctl check cluster … Continue reading

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

CLSRSC-540: The root script failed to get a unique name of the OCR backup file on the ASM diskgroup

Rootupgrade.sh failed to upgrade GI from 12.1.0.2 to 12.2.0.1. # /u01/app/12.2.0.1/grid/rootupgrade.sh .. . Relinking oracle with rac_on option Using configuration parameter file: /u01/app/12.2.0.1/grid/crs/install/crsconfig_params The log of current session can be found at: /u01/app/grid/crsdata/racnode1/crsconfig/rootcrs_racnode1_2018-02-05_12-10-50AM.log 2018/02/05 12:11:10 CLSRSC-595: Executing upgrade step 1 … Continue reading

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

“ORA-16644: apply instance not available” While DGMGRL Switchover

For some reason, DG broker does not recognise the applying instance of a standby database. DGMGRL> switchover to STDBYDB; Performing switchover NOW, please wait… Operation requires a connection to instance “STDBYDB2” on database “STDBYDB” Connecting to instance “STDBYDB2″… Connected as … Continue reading

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