Sunday 29 May 2016

START and STOP Local Listener and SCAN Listener in RAC Database.

How to Start and Stop Local Listener and SCAN Listener

First check which services are running from which nodes and users.

oragrid$ps -eaf|grep tns


\*-----How to set environment -----*/

bash-4.3$ which srvctl
/u02/grid/product/11.2.0/bin/srvctl
bash-4.3$ which lsnrctl


bash-4.3$ export PATH=$ORACLE_HOME/bin:$PATH


oragrid$/u02/grid/product/11.2.0/bin/lsnrctl

\*--How to STOP Local Listener----*/    :-Run this command from one by one from all nodes

oragrid$srvctl stop LISTENER -n adupgdb1
oragrid$srvctl stop LISTENER -n oracledb1
oragrid$srvctl stop LISTENER -n oracledb2

\*--How to STOP SCAN Listener----*/  :-Run from any one node

oragrid$srvctl stop scan_listener

\*----- How to START Local Listener------*/

oragrid$srvctl start LISTENER -n adupgdb1
oragrid$srvctl start LISTENER -n oracledb1
oragrid$srvctl start LISTENER -n oracledb2


\*-----How to start SCAN Listener------*/
oragrid$srvctl start scan_listener

********************************************************
\*******How to bounced Single SCAN Listener one by one on nodes*******/

Run from the grid user.

bash-4.3$ srvctl status scan_listener -i 3
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node adupgdb1

bash-4.3$ srvctl stop scan_listener -i 3

bash-4.3$ srvctl status scan_listener -i 3
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is not running

bash-4.3$ srvctl start scan_listener -i 3

bash-4.3$ srvctl status scan_listener -i 3
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node adupgdb1
*************************************************************

No comments:

Post a Comment

OS Watcher Installation in RAC

 Step:1 Download and untar the oswbb812.tar under the grid user in RAC on the both nodes. Follow the OS Watcher User's Guide (Doc ID 153...