How Srvctl Status Listener
In this post, we would like to check not only the statuses of listeners, but also services registered with those listeners. srvctl status listener lsnrctl… Read More »How Srvctl Status Listener
SCAN_LISTENER
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
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 Srvctl Add Listener to Second Network
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 Srvctl Add Listener to Second Network
How to Relocate SCAN Listener
Sometimes, we may find the scan vip and listeners are all located at one node. [grid@primary01 ~]$ ps -ef | grep lsnr grid … Read More »How to Relocate SCAN Listener
How to Add a Standalone Listener on Second IP to Grid
Suppose you have added a second IP on OS. You want a second listener to listen port 1521 of the new IP address for the… Read More »How to Add a Standalone Listener on Second IP to Grid
How to Add a SCAN VIP
Preparation 1. Looking up SCAN name on DNS before adding a SCAN VIP [root@primary01 ~]# nslookup primary-cluster-scan Server: 10.0.0.199 Address: … Read More »How to Add a SCAN VIP