Below are the steps for dropping database in Oracle RAC.   1. Make cluster database to FALSE SQL> alter system set cluster_database=FALSE scope=spfile sid=’*’; System altered. 2. Stop the db service Srvctl stop database –d DBACLASS 3. start the database in mount exclusive mode: SQL> startup mount exclusive restrict ORACLE instance started. Total System […]

       While dropping a diskgroup, error may come like ORA-15073: diskgroup mounted by another instance.   Problem: SQL> drop diskgroup NSMREDOA including contents; drop diskgroup NSMREDOA including contents * ERROR at line 1: ORA-15039: diskgroup not dropped ORA-15073: diskgroup NSMREDOA is mounted by another ASM instance   Solution: For rac with multiple node, you […]

                    Oracle always recommends to keep the controlfile in multiple diskgroups.  For standalone database multiplexing controlfile is straight forward, But for RAC ,we need to follow below steps.   1. Check the controlfile location:   SQL> show parameter control_file NAME TYPE VALUE ———————————— ———– —————————— control_file_record_keep_time […]

While running the opatchauto   command in oracle grid you may face the jdk version error as below. root # /crsapp/app/oracle/product/grid12c/OPatch/opatchauto apply /softdump/12C_GRIDSOFT/PATCH/22191349 -analyze -ocmrf /softdump/12C_GRIDSOFT/PATCH/grid.rsp OPatch Automation Tool Copyright (c)2014, Oracle Corporation. All rights reserved. OPatchauto Version : 12.1.0.1.10 OUI Version : 12.1.0.2.0 Running from : /crsapp/app/oracle/product/grid12c opatchauto log file: /crsapp/app/oracle/product/grid12c/cfgtoollogs/opatchauto/22191349/opatch_gi_2016-04-06_09-27-57_analyze.log NOTE: opatchauto is […]

                    While setting attribute on a ASM diskgroup, we got below error. oracle@crmcpredb1:~$ echo $ORACLE_SID +ASM1 oracle@crmcpredb1:~$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Fri Sep 16 11:19:25 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition […]

              Patching steps are different for different Operating systems. Below are the steps for applying PSU patch on 12C RAC in Solaris. The patch can be downloaded from OTN . After downloading the patch, copy it to your both the nodes and unzip there. Here i have unzipped to the […]

 Below are the steps for applying the jvm patch on RAC. 1. check for conflict cd /softdump/patch/JVM/22139226 opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 12.1.0.1.10 Copyright (c) 2016, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /oracle/app/oracle/product/12.1.0.2 Central Inventory : /crsapp/app/oraInventory from : /oracle/app/oracle/product/12.1.0.2/oraInst.loc OPatch version : 12.1.0.1.10 OUI version […]

            Follow below steps for enabling archive log mode in oracle RAC. 1. stop the database service. srvctl stop database -d DBACLASS 2. start the database in mount state. srvctl start database -d DBACLASS -o mount 3. enable archive log mode. SQL> alter database archivelog; Database altered. 4. Restart the […]

 While installing oracle rdbms home on Oracle Grid, you may get error as below.   ERROR: Clock Synchronization – This test checks the Oracle Cluster Time Synchronization Services across the cluster nodes. Error: – PRVG-1015 : Time server “.GPS.” has time offsets that are not within permissible limit “1000.0” on nodes “wmcpredb2,wmcpredb1”. – Cause: Offsets […]

If you want to find the cluster name from an existing RAC setup, then use below command. 1. cd $GRID_HOME/bin   ./olsnodes -c 2.cd $GRID_HOME/bin cemutlo -n