Oracle 12c Transparent Data Encryption (TDE) on RAC Database with Physical Standby Database : Multiple Databases in Single Oracle Home

Oracle 12c TDE on RAC Database with Physical Standby RAC. The Oracle Database Home has Multiple Instances, due to which we have to use parameter $ORACLE_UNQNAME for ENCRYPTION_WALLET_LOCATION in sqlnet.ora file In Oracle 12c ALTER SYSTEM and orapki has been deprecated and the correct method is to use ADMINISTER KEY MANAGEMENT commands. Many of the statements … Continue reading Oracle 12c Transparent Data Encryption (TDE) on RAC Database with Physical Standby Database : Multiple Databases in Single Oracle Home

Oracle 12c Dataguard RAC Primary to RAC Standby with Dataguard Broker (on Exadata)

Setup for the Environment ------------------- Exadata X4-2 Quater Rack n Primary and Standby Site Grid Version : 12.1.0.2 DB Home Version : 12.1.0.2 Primary, 2 Node RAC, db_unique_name = primeprd Instance 2 : primeprd1 Instance 2 : primeprd2 TNS entry: PRIMEPRD, but below entry in tnsnames.ora files on both node with DB Home user, most … Continue reading Oracle 12c Dataguard RAC Primary to RAC Standby with Dataguard Broker (on Exadata)

Add Members for Online Relog File Group on RAC ASM

Let's say you have already created logfiles from Group 1 to Group 8 on a 2 node RAC cluster on Diskgroup :+RECOC1. Now it is always highly recommended to mutiplex the relog files. This is how we will add new members to existing groups. First let us see the commands to create the logfile groups … Continue reading Add Members for Online Relog File Group on RAC ASM

Oracle CRS fails with CRS-5017 ORA-01017, what to do when even in init mode you cannot bring up CRS

After a memory upgrade in our RAC servers, the Cluster wasn't coming up after a reboot. We first tried to start the CRS in init mode but even that failed. Upon checking the CRS alert log we discovered that the ASM was failing to start due to below error. Error: CRS-5017: The resource action "ora.asm … Continue reading Oracle CRS fails with CRS-5017 ORA-01017, what to do when even in init mode you cannot bring up CRS

Move SPFILE to ASM RAC

-- Move SPFILE to ASM RAC --Already we have a PFILE called initmove.ora which was created previously from spfileSQL> show parameter spfileNAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string /u02/app/oracle/product/11.2.0 /dbhome_1/dbs/spfiletest1.oraAs you can see the spfile is in FilesystemSQL> create spfile='+DATAC1/test/spfiletest.ora' from pfile='/u03/rman/initmove.ora';File created.SQL> exitCreate a pfile called inittest.ora and add only below line only in it … Continue reading Move SPFILE to ASM RAC

To RAC or to not RAC

Mogens Norgaard ( He is Danish, and my Danish is rubbish. So i hope i got his name right :D) famous paper on why you probably dont need something as complex as Oracle RAC for having a highly available system. http://www.my-idconcept.de/downloads/You_Probably_Dont_Need_RAC.pdf

OPatch for 11gR2(11.2.0.3) RAC Database+Grid on Sparc 64-Bit Solaris10

1. Install Latest OPatch clients from support.oracle.com - As Grid User -- unzip p6880880_112000_SOLARIS64.zip -d $ORACLE_HOME ##Replace All - As Oracle User -- unzip p6880880_112000_SOLARIS64.zip -d $ORACLE_HOME ##Replace All   2. Set PATH variable for OPatch for both Grid and Oracle user profiles --oracle-- vi .profile PATH=/oracle/app/oracle/product/11.2.0/dbhome_1/bin:/oracle/app/oracle/product/11.2.0/dbhome_1/OPatch:$PATH   --grid-- vi .profile PATH=/grid/app/11.2.0/grid/bin:/grid/app/11.2.0/grid/OPatch/:$PATH   3. Validate … Continue reading OPatch for 11gR2(11.2.0.3) RAC Database+Grid on Sparc 64-Bit Solaris10

RAC to Single Instance Standby Database Setup (Oracle 11gR2 Physical Standby)

Primary is a 2 node-rac cluster with instances swx1 and swx2 running on ASM. A service called swxscan is created for client sides. We will use this service name for the tnsnames.ora. The standby instance will be called swxstandby and it will be running single instance on ASM as well. This is a standard dataguard … Continue reading RAC to Single Instance Standby Database Setup (Oracle 11gR2 Physical Standby)

2 Node RAC to Single Instance Dataguard Switchover (Oracle 11gR2 Physical Standby )

Many a times to save cost in building a DR solution for a certain application; you have to create a single instance database for your RAC primary. So you have gone ahead and build the 2-node to single instance setup and now comes the time to test it. Well it is not much different than … Continue reading 2 Node RAC to Single Instance Dataguard Switchover (Oracle 11gR2 Physical Standby )