OCI/Pro*C Method for ALTER SYSTEM
Date: 1995/05/26
Message-ID: <3q37oo$g59$1_at_mhafc.production.compuserve.com>#1/1
All,
I'm posed with a problem. I have a particular middleware product
that likes to leave dead processes around with connections to
ORACLE. I've written a Pro*C program that checks the IP address
and sends a ping (ICMP ECHOREQUEST) to the machines and if they are
indeed turned off (PCs), then it kills the associated process on
the server. What I'd like to do, and I've attempted this with
Pro*C to no avail, is to have this program issue an ALTER SYSTEM
KILL SESSION 'sid, serial#' first, and then kill the process.
Pro*C doesn't allow me to do this (as ALTER SYSTEM isn't supported
in Embedded SQL). My options is to attempt this in OCI (the ALTER
SYSTEM method).
Here's my 2 questions...
a. Can this be done with a kill signal to the oracle process...
I don't want to send a KILL -9 to the process. b. OR can this be done using OCI and just calling ORACLE directly
and issuing the ALTER SYSTEM method which I'd like to use.
Thanks for any replies
Darrin
darrin_at_ids.net
darrin_at_mit.edu
-- Darrin Robinson HAMnet 146.700+ N1LLV COMSOFT Information Systems Internet darrin_at_mit.edu 44 Broadway darrin_at_comsoft-is.com Newport, RI 02840 AT&Tnet 401-848-7718Received on Fri May 26 1995 - 00:00:00 CEST
