How to disable startup triggers
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: How to disable startup triggers

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    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.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    no such parameter

  3. #3
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    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.

  4. #4
    Join Date
    Aug 2001
    Posts
    75
    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

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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

  6. #6
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    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.

  7. #7
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    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
  •  


Click Here to Expand Forum to Full Width