Shut down database without user input.

Posted by anandknr on 02-Dec-2011 04:54

Hi all,

I need to shutdown the db using a script. I have used the command $DLC/bin/proshut <db name> but it will ask for the user input

           1  Disconnect a User
             2  Unconditional Shutdown
             3  Emergency Shutdown (Kill All)
             x  Exit

How can i skip this screen and go for 2 option, Unconditional Shutdown directly to stop the db.

All Replies

Posted by olivier.dunemann on 02-Dec-2011 04:56

Add the -by option at the end of the command:

$DLC/bin/proshut -by

Posted by anandknr on 02-Dec-2011 05:05

Is it for Unconditional Shutdown ?

What should be the paramater if i need to go for Emergency Shutdown (Kill All) ?

Posted by olivier.dunemann on 02-Dec-2011 05:25

-by is indeed for unconditional shutdown, while -F is for emergency shutdown... as stated in OE Knowledge Base P3222

Posted by gus on 06-Dec-2011 08:47

As oliver pointed out, you can use -F for an emergency shutdown. I would not use it indiscriminately though because it is rather harsh and abrupt, giving users little warning.

Posted by Thomas Mercer-Hursh on 06-Dec-2011 11:37

In fact, I would go so far as to say that -F should either require manual intervention or it should be behind something like password or at least "are you really sure you want to do this?" protection so that it is not used casually and routinely.

Posted by gus on 06-Dec-2011 11:59

+1

On 12/6/11 12:37 PM, "progresscommunities"

This thread is closed