-
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
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
-
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
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
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
OCP 8i
-
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
-
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
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
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.
Best wishes!
Dmitri
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|