Symptom
To find out <pid> for error ORA-00031 explained in SAP note 20071 - Permanent lock after connection termination:
ALTER SYSTEM KILL SESSION '<sid>,<serial#>';
If this command returns after some time with the message
ORA-00031: session marked for kill
, this means that the session cannot yet be terminated. In this case, you can try to hard terminate the corresponding shadow process (UNIX: "kill -9 <pid>", WINDOWS: "orakill <sid> <thread>").
Read more...
Product
Keywords
ORA-00031, killed, v$process, v$session, "ALTER SYSTEM KILL SESSION" , KBA , BC-DB-ORA , Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.