Re[2]: (solved?) cannot disable or drop the ON DATABASE trigger !
One finger per big mistake is a pretty good policy. Not only does it
slow down their rate but it pretty well limits them to ten.
RC> and did you explain to this junior that if he ever does it again, he
RC> will be minus a few fingers?
RC> Even if "things are okay now" and you could do a shutdown/startup and
RC> took a backup, I'd export the database and recreate it. The backup you
RC> took is of the system AFTER the deletion from trigger$. He's
RC> invalidated your support contract by doing that.
RC> --- rahul <[EMAIL PROTECTED]> wrote:
>> ok... now i'm praying... cos after i had sent this mail to the list
>> askling
>> for suggestions.. my junior DBA deleted the trigger from trigger$
>> !
>> things are "ok now" he says... and this _is_ a production schema.. !
>>
>> we are _not_ encountring any errors now, but i did shutdown/startup
>> and
>> took a new base backup and i will continue to pray for some
>> time to
>> come... ;-((
>>
>> -rahul
>>
>> PS: this startup migrate is news to me.. i should have looked some
>> more in
>> the manuals... big thanks..
>>
>>
>> On Sat, 05 Jul 2003 10:24:24 -0800, Jared Still <[EMAIL PROTECTED]>
>> wrote :
>>
>> >
>> > D'oh!
>> >
>> > Shoulda thought of that. It's standard
>> > procedures on upgrades.
>> >
>> > Thanks Mladen.
>> >
>> >
>> > On Friday 04 July 2003 11:29, Mladen Gogala wrote:
>> > > Parameter to disable database triggers is:
>> > >
>> > > _system_trig_enabled = FALSE
>> > >
>> > > This is 9i parameter. Alternatively, if you start the database up
>> in the
>> > > "migrate" mode, system triggers will be disable ("startup
>> migrate" is
>> what
>> > > you need)
>> > >
>> > > On 2003.07.04 10:54, "Jamadagni, Rajendra" wrote:
>> > > > This will teach you that you should be _very_ careful when
>> dealing
>> with
>> > > > sys schema.
>> > > >
>> > > > what's that parameter to disable sys triggers ??
>> > > >
>> > > > 1. Call OWS
>> > > > 2. If this is production DB, keep your resume ready.
>> > > >
>> > > > Raj
>> > > >
>> > > > -Original Message-
>> > > > Sent: Thursday, July 03, 2003 1:39 PM
>> > > > To: Multiple recipients of list ORACLE-L
>> > > >
>> > > >
>> > > >
>> > > > At first glance it appears that you have created a self
>> referencing
>> > > > trigger.
>> > > >
>> > > > You can't drop it, because dropping it fires the trigger.
>> > > >
>> > > > Check metalink, open a TAR, etc.
>> > > >
>> > > > Jared
>> > > >
>> > > >
>> > > >
>> > > >
>> > > >
>> > > > "rahul sharma" <[EMAIL PROTECTED]>
>> > > > Sent by: [EMAIL PROTECTED]
>> > > > 07/03/2003 03:40 AM
>> > > > Please respond to ORACLE-L
>> > > >
>> > > >
>> > > > To: Multiple recipients of list ORACLE-L
>> > > > <[EMAIL PROTECTED]> cc:
>> > > > Subject:cannot disable or drop the ON DATABASE
>> trigger
>> > > >
>> > > >
>> > > >
>> > > > Help list... i have created the following in 8.1.5 instance
>> > > >
>> > > > CREATE OR REPLACE TRIGGER DDL_TRIGGER BEFORE
>> > > > CREATE OR ALTER OR DROP ON DATABASE
>> > > >
>> > > > BEGIN
>> > > > null;
>> > > > END;
>> > > > /
>> > > >
>> > > > and now i cannot drop or disable this trigger
>> > > >
>> > > > ERROR at line 1:
>> > > > ORA-04045: errors during recompilation/revalidation of
>> SYS.DDL_TRIGGER
>> > > >
>> > > >
>> > > > i'm loggin into svrmgrl and connecting as internal to try drop
>> or
>> > > > disable..
>> > > > is this a bug ??
>> > > >
>> > > > TIA
>> > > >
>> > > > Rahul..
>> > > >
>> > > >
>> > > >
>> > > > --
>> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> > > > --
>> > > > Author: rahul sharma
>> > > > INET: [EMAIL PROTECTED]
>> > > >
>> > > > Fat City Network Services-- 858-538-5051
>> http://www.fatcity.com
>> > > > San Diego, California-- Mailing list and web hosting
>> services
>> > > >
>> -
>> > > > 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).
>> > > >
>> > > >
>> > > >
>> > > > --
>> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> > > > --
>> > > > Author:
>> > > > INET: [EMAIL PROTECTED]
>> > > >
>> > > > Fat City Network Services-- 858-538-5051
>> http://www.fatcity.com
>> > > > San Diego, California-- Mailing list and web hosting
>> services
>> > > >
>> -
>> > > > 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 maili
Re: (solved?) cannot disable or drop the ON DATABASE trigger !
and did you explain to this junior that if he ever does it again, he
will be minus a few fingers?
Even if "things are okay now" and you could do a shutdown/startup and
took a backup, I'd export the database and recreate it. The backup you
took is of the system AFTER the deletion from trigger$. He's
invalidated your support contract by doing that.
--- rahul <[EMAIL PROTECTED]> wrote:
> ok... now i'm praying... cos after i had sent this mail to the list
> askling
> for suggestions.. my junior DBA deleted the trigger from trigger$
> !
> things are "ok now" he says... and this _is_ a production schema.. !
>
> we are _not_ encountring any errors now, but i did shutdown/startup
> and
> took a new base backup and i will continue to pray for some
> time to
> come... ;-((
>
> -rahul
>
> PS: this startup migrate is news to me.. i should have looked some
> more in
> the manuals... big thanks..
>
>
> On Sat, 05 Jul 2003 10:24:24 -0800, Jared Still <[EMAIL PROTECTED]>
> wrote :
>
> >
> > D'oh!
> >
> > Shoulda thought of that. It's standard
> > procedures on upgrades.
> >
> > Thanks Mladen.
> >
> >
> > On Friday 04 July 2003 11:29, Mladen Gogala wrote:
> > > Parameter to disable database triggers is:
> > >
> > > _system_trig_enabled = FALSE
> > >
> > > This is 9i parameter. Alternatively, if you start the database up
> in the
> > > "migrate" mode, system triggers will be disable ("startup
> migrate" is
> what
> > > you need)
> > >
> > > On 2003.07.04 10:54, "Jamadagni, Rajendra" wrote:
> > > > This will teach you that you should be _very_ careful when
> dealing
> with
> > > > sys schema.
> > > >
> > > > what's that parameter to disable sys triggers ??
> > > >
> > > > 1. Call OWS
> > > > 2. If this is production DB, keep your resume ready.
> > > >
> > > > Raj
> > > >
> > > > -Original Message-
> > > > Sent: Thursday, July 03, 2003 1:39 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > >
> > > > At first glance it appears that you have created a self
> referencing
> > > > trigger.
> > > >
> > > > You can't drop it, because dropping it fires the trigger.
> > > >
> > > > Check metalink, open a TAR, etc.
> > > >
> > > > Jared
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > "rahul sharma" <[EMAIL PROTECTED]>
> > > > Sent by: [EMAIL PROTECTED]
> > > > 07/03/2003 03:40 AM
> > > > Please respond to ORACLE-L
> > > >
> > > >
> > > > To: Multiple recipients of list ORACLE-L
> > > > <[EMAIL PROTECTED]> cc:
> > > > Subject:cannot disable or drop the ON DATABASE
> trigger
> > > >
> > > >
> > > >
> > > > Help list... i have created the following in 8.1.5 instance
> > > >
> > > > CREATE OR REPLACE TRIGGER DDL_TRIGGER BEFORE
> > > > CREATE OR ALTER OR DROP ON DATABASE
> > > >
> > > > BEGIN
> > > > null;
> > > > END;
> > > > /
> > > >
> > > > and now i cannot drop or disable this trigger
> > > >
> > > > ERROR at line 1:
> > > > ORA-04045: errors during recompilation/revalidation of
> SYS.DDL_TRIGGER
> > > >
> > > >
> > > > i'm loggin into svrmgrl and connecting as internal to try drop
> or
> > > > disable..
> > > > is this a bug ??
> > > >
> > > > TIA
> > > >
> > > > Rahul..
> > > >
> > > >
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > --
> > > > Author: rahul sharma
> > > > INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> > > > San Diego, California-- Mailing list and web hosting
> services
> > > >
> -
> > > > 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).
> > > >
> > > >
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > --
> > > > Author:
> > > > INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> > > > San Diego, California-- Mailing list and web hosting
> services
> > > >
> -
> > > > 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).
> > > >
> > > >
> > > >
>
This
> > > > e-mail message is confidential, intended only for the named
> recipient
> (s)
> > >
(solved?) cannot disable or drop the ON DATABASE trigger !
ok... now i'm praying... cos after i had sent this mail to the list askling
for suggestions.. my junior DBA deleted the trigger from trigger$ !
things are "ok now" he says... and this _is_ a production schema.. !
we are _not_ encountring any errors now, but i did shutdown/startup and
took a new base backup and i will continue to pray for some time to
come... ;-((
-rahul
PS: this startup migrate is news to me.. i should have looked some more in
the manuals... big thanks..
On Sat, 05 Jul 2003 10:24:24 -0800, Jared Still <[EMAIL PROTECTED]> wrote :
>
> D'oh!
>
> Shoulda thought of that. It's standard
> procedures on upgrades.
>
> Thanks Mladen.
>
>
> On Friday 04 July 2003 11:29, Mladen Gogala wrote:
> > Parameter to disable database triggers is:
> >
> > _system_trig_enabled = FALSE
> >
> > This is 9i parameter. Alternatively, if you start the database up in the
> > "migrate" mode, system triggers will be disable ("startup migrate" is
what
> > you need)
> >
> > On 2003.07.04 10:54, "Jamadagni, Rajendra" wrote:
> > > This will teach you that you should be _very_ careful when dealing
with
> > > sys schema.
> > >
> > > what's that parameter to disable sys triggers ??
> > >
> > > 1. Call OWS
> > > 2. If this is production DB, keep your resume ready.
> > >
> > > Raj
> > >
> > > -Original Message-
> > > Sent: Thursday, July 03, 2003 1:39 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >
> > > At first glance it appears that you have created a self referencing
> > > trigger.
> > >
> > > You can't drop it, because dropping it fires the trigger.
> > >
> > > Check metalink, open a TAR, etc.
> > >
> > > Jared
> > >
> > >
> > >
> > >
> > >
> > > "rahul sharma" <[EMAIL PROTECTED]>
> > > Sent by: [EMAIL PROTECTED]
> > > 07/03/2003 03:40 AM
> > > Please respond to ORACLE-L
> > >
> > >
> > > To: Multiple recipients of list ORACLE-L
> > > <[EMAIL PROTECTED]> cc:
> > > Subject:cannot disable or drop the ON DATABASE trigger
> > >
> > >
> > >
> > > Help list... i have created the following in 8.1.5 instance
> > >
> > > CREATE OR REPLACE TRIGGER DDL_TRIGGER BEFORE
> > > CREATE OR ALTER OR DROP ON DATABASE
> > >
> > > BEGIN
> > > null;
> > > END;
> > > /
> > >
> > > and now i cannot drop or disable this trigger
> > >
> > > ERROR at line 1:
> > > ORA-04045: errors during recompilation/revalidation of SYS.DDL_TRIGGER
> > >
> > >
> > > i'm loggin into svrmgrl and connecting as internal to try drop or
> > > disable..
> > > is this a bug ??
> > >
> > > TIA
> > >
> > > Rahul..
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: rahul sharma
> > > INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting services
> > > -
> > > 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).
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author:
> > > INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting services
> > > -
> > > 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).
> > >
> > >
> > >
This
> > > e-mail message is confidential, intended only for the named recipient
(s)
> > > above and may contain information that is privileged, attorney work
> > > product or exempt from disclosure under applicable law. If you have
> > > received this message in error, or are not the named recipient(s),
please
> > > immediately notify corporate MIS at (860) 766-2000 and delete this e-
mail
> > > message from your computer, Thank you.
> > > *2
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jared Still
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
(solved?) cannot disable or drop the ON DATABASE trigger !
ok... now i'm praying... cos after i had sent this mail to the list askling
for suggestions.. my junior DBA deleted the trigger from trigger$ !
things are "ok now" he says... and this _is_ a production schema.. !
we are _not_ encountring any errors now, but i did shutdown/startup and
took a new base backup and i will continue to pray for some time to
come... ;-((
-rahul
PS: this startup migrate is news to me.. i should have looked some more in
the manuals... big thanks..
On Sat, 05 Jul 2003 10:24:24 -0800, Jared Still <[EMAIL PROTECTED]> wrote :
>
> D'oh!
>
> Shoulda thought of that. It's standard
> procedures on upgrades.
>
> Thanks Mladen.
>
>
> On Friday 04 July 2003 11:29, Mladen Gogala wrote:
> > Parameter to disable database triggers is:
> >
> > _system_trig_enabled = FALSE
> >
> > This is 9i parameter. Alternatively, if you start the database up in the
> > "migrate" mode, system triggers will be disable ("startup migrate" is
what
> > you need)
> >
> > On 2003.07.04 10:54, "Jamadagni, Rajendra" wrote:
> > > This will teach you that you should be _very_ careful when dealing
with
> > > sys schema.
> > >
> > > what's that parameter to disable sys triggers ??
> > >
> > > 1. Call OWS
> > > 2. If this is production DB, keep your resume ready.
> > >
> > > Raj
> > >
> > > -Original Message-
> > > Sent: Thursday, July 03, 2003 1:39 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >
> > > At first glance it appears that you have created a self referencing
> > > trigger.
> > >
> > > You can't drop it, because dropping it fires the trigger.
> > >
> > > Check metalink, open a TAR, etc.
> > >
> > > Jared
> > >
> > >
> > >
> > >
> > >
> > > "rahul sharma" <[EMAIL PROTECTED]>
> > > Sent by: [EMAIL PROTECTED]
> > > 07/03/2003 03:40 AM
> > > Please respond to ORACLE-L
> > >
> > >
> > > To: Multiple recipients of list ORACLE-L
> > > <[EMAIL PROTECTED]> cc:
> > > Subject:cannot disable or drop the ON DATABASE trigger
> > >
> > >
> > >
> > > Help list... i have created the following in 8.1.5 instance
> > >
> > > CREATE OR REPLACE TRIGGER DDL_TRIGGER BEFORE
> > > CREATE OR ALTER OR DROP ON DATABASE
> > >
> > > BEGIN
> > > null;
> > > END;
> > > /
> > >
> > > and now i cannot drop or disable this trigger
> > >
> > > ERROR at line 1:
> > > ORA-04045: errors during recompilation/revalidation of SYS.DDL_TRIGGER
> > >
> > >
> > > i'm loggin into svrmgrl and connecting as internal to try drop or
> > > disable..
> > > is this a bug ??
> > >
> > > TIA
> > >
> > > Rahul..
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: rahul sharma
> > > INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting services
> > > -
> > > 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).
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author:
> > > INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting services
> > > -
> > > 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).
> > >
> > >
> > >
This
> > > e-mail message is confidential, intended only for the named recipient
(s)
> > > above and may contain information that is privileged, attorney work
> > > product or exempt from disclosure under applicable law. If you have
> > > received this message in error, or are not the named recipient(s),
please
> > > immediately notify corporate MIS at (860) 766-2000 and delete this e-
mail
> > > message from your computer, Thank you.
> > > *2
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jared Still
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
