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)

Transparent Application Failover (TAF) Service in Oracle RAC 11gR2

ADDING TAF SERVICE FOR SCAN _____________________________ ####### As "Oracle" (owner of database) user test - name of database test1- instance on node1 test2- instance on node2 testscan- name for the new taf service srvctl add service -d test -s testscan -r "test1,test2" -P BASIC srvctl start service -d test -s testscan srvctl config service -d … Continue reading Transparent Application Failover (TAF) Service in Oracle RAC 11gR2

Change SCAN ip’s Oracle RAC11gR2

SCAN (Single Client Access Name) is a new concept introduced in since 11gR2. It eliminated to have VIP )Virutal ip) of nodes in the tnsnames.ora file. Prior to release 11gR2 the TNSNAMES.ora file required to have all nodes entered in it for load balancing and failover. This created unnecessarily changes everytime a node was added or … Continue reading Change SCAN ip’s Oracle RAC11gR2

Oracle 11g RAC Administration Commands

11g RAC Administration and Maintenance Tasks and Utilities: Task List: Checking CRS Status Viewing Name Of the Cluster Viewing Nodes Configuration Checking Votedisk Information Checking OCR Disk information Timeout Settings in Cluster ADD/Remove OCR files ADD/Remove Votedisk Backing Up OCR Backing Up Votedisk Restoring OCR Devices Restoring Voting Disk Devices Changing Public IPs as well … Continue reading Oracle 11g RAC Administration Commands