Is OK to kill an ORACLE process?

[twang]

one more thing add to above, if you use "kill" to remove oracle core process, ou may need to remove the shared memory belongs to oracle as well. Otherwise you may see the error "ORA-7306 Unable to Restart an Instance After a Crash
To see the current usage of shared memory & semaphores:
"ipcs -b"
Or you may need to remove using "ipcrm"

[John Flanagan]

Do not kill the oracle process if you can shut it down properly.

If you want to backup the database you will have to restart it and then shut it down again properly.

John.

[Yogeeraj_1]

hi,

this is modified script as per Patti's suggestion above:

select b.sid SID,b.serial# "Serial#", c.spid "srvPID", b.osuser, b.username, b.status, b.client_info from v$session b, v$process c where b.paddr = c.addr and c.sPID = &OSPID


hope this helps too!

regards
Yogeeraj

[Randy Hagedorn]

WOW, what a response from everyone!

I ended up using Oracle OEM to kill the SID in question, and marked it as KILLLED. Then I killed the PID from the HP-UX side and it all went away. Now, the script provided above doesn't show the SID being a problem any more.

The processor board that was running at 100% usage dropped off to about 15% usage.

Thanks again,
Randy