Kill a session caused instance to be bounced
614497Feb 23 2010 — edited Dec 17 2012Our db is 2 nodes RAC db. The version is 10.2.0.3. The database servers are window 2003 servers. Recently I tried to kill a session using ‘alter system kill session ..’ to kill a user session but caused the corresponding instance bounced. I have created a TAR with Oracle and uploaded alert logs, trace files and files from $ORACLE_HOME/log/<node-name>/racg/ directory. But Oracle could not found anything to explain why the instance got restarted. He said that I may have killed an Oracle background process. My questions are:
1) Can you use ‘alter system kill session ..’ command to kill an Oracle process? If you can what would happen if you did kill one? Just cause the instance stop and start?
2) I tried to found the session I have killed in gv$active_session_history but they are too old to exist there. I am wondering is there anywhere I found this kind of info.
Thanks a lot for your help,
Shirley