ORACLE RAC

How to move voting disk to another ASM disk

    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. […]

How to convert a non ASM instance to ASM instance

                         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 […]

How to change RAC database name

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 […]

oracle RAC 12c setup using virtual box

       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 […]