| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: _system_trig_enabled=false question
Fortunately none of those existed in 8.0.4 so we don't have them yet :).
-----Original Message-----
Sent: Tuesday, January 08, 2002 4:59 PM
To: Multiple recipients of list ORACLE-L
Setting _system_trig_enabled to false disables login triggers, startup triggers and other non-DML event triggers. For more see DBA guide and Concepts manual.
-----Original Message-----
Sent: Tuesday, January 08, 2002 4:21 PM
To: Multiple recipients of list ORACLE-L
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).
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).
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 - 16:33:37 CST
 |
 |