RAC - Stop listener / Parallel processes
Oracle 10.2.0.4 database
Five node RAC on Linux
I have shutdown the instance at 6:30 this morning. A user process have been running before I shutdown the listener. When I run the following query, it shows that there are 16 active processes on this node for him. I further investigated and found that these 16 sessions are Parallel processes and the original session was started from a different node.
Stopping listener: srvctl stop listener -n dsdb04
Stopping Instance: srvctl stop instance -d dsprod -i dsprod8
1. So, is it safe to say that even if we shutdown the listener, the new parallel processes could initiate on the server where we stop/shutdown the listener?
I have shutdown the instance at 6:30 this morning. A user process have been running before I shutdown the listener. When I run the following query, it shows that there are 16 active processes on this node for him. I further investigated and found that these 16 sessions are Parallel processes and the original session was started from a different node.
Stopping listener: srvctl stop listener -n dsdb04
Stopping Instance: srvctl stop instance -d dsprod -i dsprod8
1. So, is it safe to say that even if we shutdown the listener, the new parallel processes could initiate on the server where we stop/shutdown the listener?
0