Linux:
md5sum utility already installed on your machine , if not available please install it.
go to thestaging folder
eg: $cd /prodtmp/Stage12
$md5sum --check md5sum_Linux32.txt > md5sum_result.txt
When the md5sum command failed error: "Failed open or read" try to make it a unix file using:
$dos2unix <checksum file> <cheksum file>
Oracle R12 media check sum txt file can be downloaded from metalink link
SQL> Alter system kill session 'sid,serial#' immediate;
OS level:
Windows: orakill ORACLE_SID spid
The UNIX /Linux :
To kill the session on UNIX or Linux operating systems, first identify the session, then substitute the relevant SPID into the following command.
find out running oracle process
$ps -ef | grep ora
select c.owner, c.object_name, c.object_type,b.sid, b.serial#, b.status, b.osuser, b.machine from v$locked_object a , v$session b, dba_objects c where b.sid = a.session_id and a.object_id = c.object_id