Shulou(Shulou.com)06/01 Report--

RAC two nodes, one of which suddenly appears log file sync waiting, and is a fixed number of replies. The reply does not end all the time, so delete it manually:

Select 'alter system kill session''| | sid | |','| | serial# | |''immediate;' from gv$session where event =' log file sync'

However, there is a partial reply prompt: ora-00030:User session ID does not exists; confirms that the session is on the first node:

And using emcc also reports this error:

So kill the reply from the operating system level:

Select spid, osuser, s.program

From v$session s, v$process p

Where s.paddr = p.addr

And s.sid = 2350

Log in beyond the system:

Kill-9 spid

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.