Database - RAC/Scalability (MOSC)

MOSC Banner

Stop rac node with no lost service

edited Feb 11, 2018 9:33AM in Database - RAC/Scalability (MOSC) 6 commentsAnswered

Hi cracks,

When I would like to do some kind of maintenance in one of the nodes, I always stop the crs as root user in the node:

# crsctl stop crs

but the live connections on this node instance are killed losing service of active connections.

I know that the new connections are redirected to the surviving nodes, but which is the best option if I would like to wait the current sessions end?

Stop the local listener on the node and wait?

srvctl stop listener [-l <lsnr_name>] [-n <node_name>] [-f]sql> select count(*) from gv$sessions where inst_id=...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center