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
Network
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 PRCN-2066 : Failed to retrieve cluster listener for
PRCN-2066 or PRCN-02066 Tried to check the status of a listener by srvctl status listener, but it failed with PRCN-02066. [grid@primary01 ~]$ srvctl status listener… Read More »How to Resolve PRCN-2066 : Failed to retrieve cluster listener for
How to Resolve PRKO-2054 : Invalid command line syntax
PRKO-2054 or PRKO-02054 Tried to list configuration of all virtual IP (VIP) in the cluster, but it failed with PRKO-02054. [grid@primary01 ~]$ srvctl config vip… Read More »How to Resolve PRKO-2054 : Invalid command line syntax
How Srvctl Relocate VIP
srvctl relocate vip We have talked about how virtual IP (VIP) failover to another node. In this post, let's see how we manually relocate a… Read More »How Srvctl Relocate VIP
How Srvctl Status VIP
Srvctl Config VIP Before checking the status of VIP by srvctl, we need to know VIP name in this cluster. [grid@primary01 ~]$ srvctl config vip… Read More »How Srvctl Status VIP
How to Resolve ORA-12528: TNS:listener: all appropriate instances are blocking new connections
ORA-12528 Tried to connect a NOMOUNT database, but it failed with ORA-12528. C:\Users\ed>sqlplus sys/password@orcl as sysdba ... ERROR: ORA-12528: TNS:listener: all appropriate instances are blocking… Read More »How to Resolve ORA-12528: TNS:listener: all appropriate instances are blocking new connections
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