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

    If you are planning to move your VOTING DISK to another ASM disk, then follow the below steps. Below activities Need to be done from ROOT user. Check the existing voting disk details. root@TEST:/crsapp/app/oracle/product/grid12c/bin# ./crsctl query css votedisk ## STATE File Universal Id File Name Disk group — —– —————– ——— ——— 1. […]

                         Here in this article, We will provide detailed steps for converting a non-asm instance to an asm-instance.  Prerequisites: 1. Oracle cluster  need to be installed on that server( for ASM)  2. Create required asm disk groups. EXAMPLE: Currrently the datafiles are in /u02 […]

DATABASE NAME =XRXDB instance_name=XRXDB1( on node 1 ) and XRXDB2 ( node 2 ) echo $ORACLE_SID XRXDB1 [1] Create pfile from spfile in non-default location.     SQL> create pfile=’/u02/oraclenetwork/XRXDB/initXRXDB.ora’ from spfile; File created. SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production  [server313:XRXDB1]$ pwd /u01/app/oracle/product/11.2.0.3/db_1/dbs [server313:XRXDB1]$ cd [server313:XRXDB1]$ cd […]

       In this article , I have described each and every step required for setting up a 2 node rac 12c database using virtual box for testing purpose. Softwares Required: 1. Virtual box : 2. Linux  3. Oracle 12c home: 4. Oracle 12c Grid: Virtual Machine setup: Here we have to setup 2 […]