Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Automatic Oracle Shutdown when UPS dies

SOLVED
Go to solution
Chris Cruz_1
Occasional Advisor

Automatic Oracle Shutdown when UPS dies

Is there an HP h/w or s/w product that will allow actions to be performed if a UPS is about to die? Actions such as shutdown Oracle and/or a Unix server.

Any information/documentation that can be shared related to this would be very much appreciated.
6 REPLIES
Wodisch
Honored Contributor
Solution

Re: Automatic Oracle Shutdown when UPS dies

Hi,

usually an UPS does have at least a serial cable top connect to the UN*X box. That cable will drop signal "DTR" upon loss of power, so all you need is a line in your "/etc/inittab" to wait for that to happen. As dropping "DTR" creates the signal "HUP" on all processes connected to that line, a shell-script using
trap "/sbin/init.d/oracle stop" 1
and then sleeping/waiting forever should work fine...

FWIW,
Wodisch
Pete Randall
Outstanding Contributor

Re: Automatic Oracle Shutdown when UPS dies

Assuming you can receive signal from the UPS as Wodisch noted, just configure the ups_mond (via /etc/ups_conf) to start a normal shutdown before the battery runs out.

Pete

Pete
Lars-Olof Fermvall
Frequent Advisor

Re: Automatic Oracle Shutdown when UPS dies

Hi!

Unless you specifically want a HP solution, many UPS manufacturers supply supervision and shutdown programs with their products for many platforms (including). If you are using HP hardware, disregard this suggestion, since the previous answers would be more relevant.

Lars-Olof
Nemo enim saltat sobrius, nice forte insanit
Indira Aramandla
Honored Contributor

Re: Automatic Oracle Shutdown when UPS dies

If you have POWERSAFE 5 CONFIGURATION PROGRAM R5.3.1
you can configure the "psafe" parmeters. The install program will ask to configure battery reserve time, battery recharge time in hours, and the users to receive mail from psafe and the shutdown script to execute.

And then to automatically start up Powersafe 5 software when your computer system is up, you need to edit a system file which is executed at startup.

We had expererienced this problem where the air-conditioning had a problem and the UPS daemon died and this shutdown the UNIX servers and the oracle databases 10 minutes before after the initial warning message. And the when the UPS was started the systems were automatically started up by the startup scripts configures in powersafe configuration.

Never give up, Keep Trying
KVS Raju
Advisor

Re: Automatic Oracle Shutdown when UPS dies

Hi,

For HP systems "HP PowerTrust" software is available to handle this type of scenarios. For more details you can contact HP.

Regards
Kvs Raju
Time and Tide wait for none
Rory R Hammond
Trusted Contributor

Re: Automatic Oracle Shutdown when UPS dies

We have used HP powertrust software and it works. We have also used APC's powerchute software and it also works.
Both are started with /etc/inittab entries.


Man pages to look at:
man inittab
man ups_mond
man ups_conf




There are a 100 ways to do things and 97 of them are right