Re: Package with utl_file write is still running after it has been Killed

There is this os process with the same oid at the end there, as the the oracle process that is rogue:

root 14165 1 0 11:52 ? 00:00:00 lsof -p 24459

I am unable to kill this process either. I assume that is is still trying to write to the mounted filesystem that is no longer there.

It doesn't matter what order I attempt to kill the OS processes they just won't go away.

I never had this issue in Oracle 11, but I have heard others who have had this issue in 12.

Thanks,
JD Markham
Database Administrator

On 11/15/2016 2:34 PM, Sweetser, Joe wrote:
> Hi,
>
> A few things. Try lsof command to see open files on the mountpoint/filesystem. That would show if the process is still trying to write to what I assume was an NFS-mounted filesystem. Also, I assume you are getting the pid to kill with the ps command. I seem to remember having to kill the parent and actual PID separately at times. I would also do a "ps -ef | grep <insert PID of oracle process>" to see if the oracle process has spawned a child. I realize that a kill -9 is supposed to handle all that but sometimes Oracle has a life of its' own. :)
>
> Good luck,
> -joe
>
> Joe Sweetser
> Sr. DBA/Nerd
> ICAT
> Underwriters at Lloyd's, Syndicate 4242
>> Security. Service. Recovery.
> T: 303-327-1863
> jsweetser_at_icat.com | www.icat.com
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Jae Markham
> Sent: Tuesday, November 15, 2016 3:25 PM
> To: oracle-l_at_freelists.org
> Subject: Package with utl_file write is still running after it has been Killed
>
> Oracle 12.1
> RHEL 6
>
> I have a package that was run that has a utl_file write as part of the package. The server where the file is written to crashed this morning, there for the file cannot be written to that server. The parts for the server will not arrive until later today.
>
> I have killed the oracle process, but it is still running. I tried to kill the OS process, but it will not allow it.
>
> Is my only solution to bounce the server? Even then, will the process try and continue once the server restarts?
>
> Thanks,
> JD Markham
> Database Administrator
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> Confidentiality Note: This message contains information that may be confidential and/or privileged. If you are not the intended recipient, you should not use, copy, disclose, distribute or take any action based on this message. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Although ICAT, Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. Thank you.

--
http://www.freelists.org/webpage/oracle-l