More details:
I ran initjvm.sql, but none of the other initialization scripts.
When applying the patch I ran all the patch scripts (including load_jis.sql,
jisja.sql, initjsp.sql). Unfortunately the patch documention doesn't
specify that some of them require the other init scripts to be run
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
Again PROBABLY it's OK since no DDL was run.
-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
Miller ,
Be very carefull
There is a note on Metastink
Note:159801.1 Full JVM removal on 8.1.7.
which you should read before doing anything with jvm.
Moreover I had very experience with 8.1.7 JVM. Once it
fails during installation I was not able to remove it
completely and as usual oracle
I've read through the note already. Fortunately I hadn't run any of the
other init scripts due to the time constraints. I double checked with the
specific objects they mentioned if you had run init_jis.sql and none of them
existed.
I'll check out the site you mention.
-Original
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.
:
Sent by: Subject: Re: _system_trig_enabled=false
question
[EMAIL PROTECTED]
om
Jay,
My understanding is it turns off system triggers - ie logon, logoff,
database startup, object drop, creation etc
Whether I would allow user access would depend on if your application uses
these sort of triggers.
eg do you have triggers to audit object dropping / creation?
Do you have DB