How RAC Failover VIP to Another Node
Since 11g, we rely more and more on SCAN Virtual IP to load balance and failover connections among nodes of a cluster, so the original… Read More »How RAC Failover VIP to Another Node
SCAN IP
How to Relocate SCAN and SCAN_LISTENER
Theoretically, the cluster distributes all SCAN VIP across all nodes evenly according to some algorithm, but sometimes you would like to relocate their host node.… Read More »How to Relocate SCAN and SCAN_LISTENER
How to Resolve PRCR-1065 and CRS-2974
PRCR-1065 CRS-2974 When we tried to stop SCAN for some reason, we got errors like this: [grid@primary01 ~]$ srvctl stop scan PRCR-1065 : Failed to… Read More »How to Resolve PRCR-1065 and CRS-2974
How to Restart SCAN
You cannot stop SCAN before stopping SCAN_LISTENER, so if you want to restart SCAN, you have to consider how to handle SCAN_LISTENER. Soft Restart We… Read More »How to Restart SCAN
Can we Setup SCAN VIP without DNS
In grid infrastructure installation, OUI expects that SCAN VIP is returned in a round-robin fashion through nslookup the DNS. Without DNS, it can only depend… Read More »Can we Setup SCAN VIP without DNS
Can we Setup Only One SCAN VIP
Oracle recommends that you allocate 3 or above SCAN VIP to load balance incoming connections. The more SCAN VIP, the more clients and connections they… Read More »Can we Setup Only One SCAN VIP
How to Build 18c RAC - 1 of 4 - Preparing Two Database Servers
For 19c, you may refer to: How to Build 19c RAC - 1 of 4 - Preparing Two Database Servers. Network Design for RAC Let's… Read More »How to Build 18c RAC - 1 of 4 - Preparing Two Database Servers
How to Add a Cluster Listener on Second Network to Grid
I assume that you have added the second network to the grid infrastructure. Let's continue our work. Make sure the second network is available in… Read More »How to Add a Cluster Listener on Second Network to Grid
How to Add a Subnet to Grid
Servers that have multiple network interfaces may offload the traffic by adding another subnet to grid infra. In this post, I demonstrate how I add… Read More »How to Add a Subnet to Grid
How to Relocating SCAN VIP and Listeners
Sometimes, we may find the scan vip and listeners are all located at one node.[grid@primary01 ~]$ ps -ef | grep lsnrgrid 6077 … Read More »How to Relocating SCAN VIP and Listeners