Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> _system_trig_enabled=false question

_system_trig_enabled=false question

From: Miller, Jay <JayMiller_at_TDWaterhouse.com>
Date: Tue, 08 Jan 2002 13:38:36 -0800
Message-ID: <F001.003EA541.20020108132110@fatcity.com>

Due to time constraints during my recent 8.0.4 -> 8.1.7 upgrade (we had a disk failure while I was doing my cold backup which delayed my start time from midnight to 3:30am) I was unable to finish installing the JVM (not a priority since no one is using it yet).
What I need to do now is run rmjvm.sql, restart the instance with
_system_trig_enabled=false, reinstall everything, and restart the database
with _system_trig_enabled=true.

Nothing in the documentation says that users shouldn't connect while
_system_trig_enabled=false.

I opened a TAR with Oracle and the person told me that I'd "probably" be fine so long as I wasn't running auditing or certain security programs.

I'm uncomfortable with that "probably".

Can anyone here confirm or deny problems with allowing user access and DML while _system_trig_enabled is set to false? What exactly is this parameter doing?

Thanks!

Jay Miller

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: JayMiller_at_TDWaterhouse.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Jan 08 2002 - 15:38:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US