How to Check SCAN Host Name
SCAN Hostname To know the hostname of a SCAN in the cluster, we have some ways to get it. nslookup Given a known SCAN IP,… Read More »How to Check SCAN Host Name
SCAN IP
How to Check SCAN IP Address
SCAN IP Address In a complex environment, you may have some ways to fast check the actual SCAN IP used in the RAC server. nslookup… Read More »How to Check SCAN IP Address
How to Resolve Toad Error: Unable to find RAC connection information for INST_ID
Unable to find RAC connection information for INST_ID A developer tried to run a procedure with debug mode in Toad for Oracle, a database tool… Read More »How to Resolve Toad Error: Unable to find RAC connection information for INST_ID
How to Resolve ORA-01109: database not open
ORA-01109 ORA-01109 is pretty normal when the database you want to connect or operate with is at MOUNT or NOMOUNT state. In this post, we… Read More »How to Resolve ORA-01109: database not open
How to Resolve ORA-12505: TNS:listener does not currently know of SID given in connect
ORA-12505 ORA-12505 means that the SID you provided in the connect identifier does not match any SID registered with the listener. Basically, SID means $ORACLE_SID,… Read More »How to Resolve ORA-12505: TNS:listener does not currently know of SID given in connect
How Oracle RAC VIP Failover to Another Node
Since 11g, we rely more and more on SCAN Virtual IP to load balance and failover connections among nodes in a cluster, so the original… Read More »How Oracle RAC VIP Failover to Another Node
Srvctl Relocate SCAN_LISTENER to Another Node
Rebalance SCAN Resource Theoretically, the cluster distributes all SCAN VIP across all nodes evenly according to some algorithm, but sometimes you would like to relocate… Read More »Srvctl Relocate SCAN_LISTENER to Another Node
How to Resolve CRS-2974 Error Message
CRS-2974: unable to act on resource When we tried to stop SCAN for some reason, we got CRS-2974 like this: [grid@primary01 ~]$ srvctl stop scan… Read More »How to Resolve CRS-2974 Error Message
How Oracle Restart SCAN
You cannot stop SCAN (Single Client Access Name) before stopping SCAN_LISTENER, so if you want to restart SCAN, you have to consider how to handle… Read More »How Oracle Restart SCAN
How to Resolve PRVG-1101 : SCAN name failed to resolve
PRVG-1101 or PRVG-01101 In grid infrastructure installation, OUI expects that SCAN VIP is returned in a round-robin fashion through nslookup the DNS. Without DNS, it… Read More »How to Resolve PRVG-1101 : SCAN name failed to resolve