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@xxxxxxxx | www.icat.com
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Jae Markham
Sent: Tuesday, November 15, 2016 3:25 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//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.