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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
