How to disable startup triggers

[ronnie]

Hi,

Is there a way to disable database startup triggers without dropping them.

I mean is there a init.ora parameter which can be set to do this.

Thanks

[pando]

no such parameter

[ronnie]

The how do you do it.

For example if your startup trigger is causing your database to hang at startup. what do you do in this case.

Thanks

[sanjay92]

I guess you can disable the triggers. Disable will not drop the drop trigger definition and since the trigger is disabled , so it will not be executed.


Sanjay

[SANJAY_G]

For example if your startup trigger is causing your database to hang at startup. what do you do in this case.

Interesting...
If you are still able to connect as sys or internal or privileged user you can disable or drop the trgger.
But if the db hangs due to startup trigger and doesn't allow you to connect at all... Any solution??

Sanjay

[ronnie]

Originally posted by SANJAY_G

For example if your startup trigger is causing your database to hang at startup. what do you do in this case.

Interesting...
If you are still able to connect as sys or internal or privileged user you can disable or drop the trgger.
But if the db hangs due to startup trigger and doesn't allow you to connect at all... Any solution??

Sanjay

Ok, let me explain,

I have a startup trigger which executes a java stored procedure . The java stored procedure in turn executes an OS command on a windows 2000 system to start the context server.

This operation hangs. I want to get rid of this trigger so that my database opens without any problem.

Is there any way I can do this.

Thanks

[kgb]

I see 2 ways:
1) replace your external program on simple one to be able to open database;
2) try this http://www.dbasupport.com/forums/sho...threadid=19741
but I am not sure (2) will help you.