Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> _system_trig_enabled=false question
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