Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: using system event triggers
Agree we need to know the actual business problem being solved
But as a suggestion for the question asked, & I haven't tried this and probably don't recommend it:
Could you use execute immediate to use alter system to kill off the sys sessions - this would probably kill the DB But then again maybe Oracle won't let you kill them
Or use a Java procedure to fire off an OS command to close the database
HTH,
Bruce Reardon
NOTICE: This e-mail and any attachments are private and confidential and may contain legally privileged information. If you are not an authorised recipient, the copying or distribution of this e-mail and any attachments is prohibited and you must not read, print or act in reliance on this e-mail or attachments. This notice should not be removed.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Pete Finnigan
Sent: Saturday, 28 February 2004 4:26 AM
To: oracle-l_at_freelists.org
Subject: Re: using system event triggers
In article <DE8A21F8F1D0254EA4A9214D52AB2FEDAD5948_at_exchsen0a1ma>,
Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us> writes
> Josh,
>
> This is a very bad idea. Even if you *could* do it, how in the
> world would you be able to fix it? If you cant start the database,
> then it's basically hosed.
Hi Tom,
That would be easy to fix, just set the init.ora parameter _system_trig_enabled=false and start the instance using this init.ora.
But yes I agree with your sentiments, what is he trying to achieve.
cheers
Pete
-- Pete Finnigan email:pete_at_petefinnigan.com Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Sun Feb 29 2004 - 15:28:39 CST
![]() |
![]() |