restart one node

[Roshan]

Oracle 19c
RAC GRID 19c 2 nodes
RHEL 8

Hello Erman,

whenever I restart one of the nodes, I get the below message

CRS-33677: Stop of resource group 'ora.asmgroup' on server 'orax8ppd2' succeeded.
CRS-2672: Attempting to start 'ora.qosmserver' on 'orax8ppd1'
CRS-2672: Attempting to start 'ora.scan2.vip' on 'orax8ppd1'
CRS-2672: Attempting to start 'ora.scan3.vip' on 'orax8ppd1'
CRS-2672: Attempting to start 'ora.cvu' on 'orax8ppd1'
CRS-2672: Attempting to start 'ora.orax8ppd2.vip' on 'orax8ppd1'
CRS-2676: Start of 'ora.orax8ppd2.vip' on 'orax8ppd1' succeeded
CRS-2676: Start of 'ora.scan2.vip' on 'orax8ppd1' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'orax8ppd1'
CRS-2676: Start of 'ora.scan3.vip' on 'orax8ppd1' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN3.lsnr' on 'orax8ppd1'
CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'orax8ppd1' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN3.lsnr' on 'orax8ppd1' succeeded
CRS-2676: Start of 'ora.cvu' on 'orax8ppd1' succeeded


Why does grid attempt to start listener on other active node? Also, kindly advise how can I autostart grid and DB whenever I restart a node.

Thanks,
Roshan

[ErmanArslansOracleBlog]

What is the name of the node that you restart the cluster services?
How do you restart? What is the command that you use?

[Roshan]

Node which is being stopped

ORAX8PPD2

command used to stop
/grid/app/19.0.0.0/grid/bin/crsctl stop crs

reboot server ORAX8PPD1
/grid/app/19.0.0.0/grid/bin/crsctl start crs

[ErmanArslansOracleBlog]

"crstctl stop cluster" may be what you need.

It can be used to stop the Oracle Clusterware stack on all servers in the cluster or "specific servers."
"crsctl stop cluster [-all | -n server_name [...]] [-f]"


This is from Oracle Documentation: -- please read*
"If you intend to stop Oracle Clusterware on all or a list of nodes, then use the crsctl stop cluster command, because it prevents certain resources from being relocated to other servers in the cluster before the Oracle Clusterware stack is stopped on a particular server. If you must stop the Oracle High Availability Services on one or more nodes, then wait until the crsctl stop cluster command completes and then run the crsctl stop crs command on any particular nodes, as necessary."

For your othet question related with the autostart -> you can do it with srvctl and Management policy.

See ->https://docs.oracle.com/en/database/oracle/oracle-database/19/racad/server-control-utility-reference.html -- search for Management policy

You can use crsctl for others;

for ex to check if ASM is in autostart mode;

rsctl stat res ora.asm -f
NAME=ora.asm
TYPE=ora.asm.type
STATE=ONLINE
TARGET=ONLINE
...
..................
AUTO_START=never
.....
.........
ENABLED=1

[Roshan]

Thanks a lot :)