Parallel processes on RAC nodes
Oracle RAC: 5 nodesDatabase Version: 10.2.0.4
OS: Linux
database name: datawh
When I have to shutdown a node for maintenance purpose, I take the following steps:
1. Stop listener - srvctl stop listener -n datawh03
2. Wait until all processes become INACTIVE.
3. Stop the Instance when all processes become INACTIVE - srvctl stop instance -d datawh -i datadb03
4.Stop the ASM - srvctl stop asm -n datawh03
5. turn it over to System Admin to patch the OS, etc.
One thing I have noticed in RAC, that if I stop the listener on one node and run parallel processes on other nodes, Parrell query server still spin new processes on the node(NODE1) that I stopped the listener.How could I make sure that no new connections including parallel processes created when listener is down on a particular node/instance?
OS: Linux
database name: datawh
When I have to shutdown a node for maintenance purpose, I take the following steps:
1. Stop listener - srvctl stop listener -n datawh03
2. Wait until all processes become INACTIVE.
3. Stop the Instance when all processes become INACTIVE - srvctl stop instance -d datawh -i datadb03
4.Stop the ASM - srvctl stop asm -n datawh03
5. turn it over to System Admin to patch the OS, etc.
One thing I have noticed in RAC, that if I stop the listener on one node and run parallel processes on other nodes, Parrell query server still spin new processes on the node(NODE1) that I stopped the listener.How could I make sure that no new connections including parallel processes created when listener is down on a particular node/instance?
0