shutdown oracle with Powerchute Network Shutdown
Dear all,
I want to configure the PowerChute Network Shutdown 2.2.4 to shutdown our oracle server (Windows 2008 R2) if power outage occurs. I add the command in "Run this command file (full name):" under configure shutdown.
@START "E:\shutdown\shutdown.bat"
the script e:\shutdown\shutdown.bat contains
e:
cd \shutdown
set oracle_sid=xxx
sqlplus "/ as sysdba" @e:\shutdown\shutdown.sql
The shutdown.sql contains
show parameter db_unique_name
shutdown immediate
EXIT
I shutdown the UPS for testing, the script is failed to run.
I tested the shutdown.bat with Administrator account, it can work.
What I'm missing?
I want to configure the PowerChute Network Shutdown 2.2.4 to shutdown our oracle server (Windows 2008 R2) if power outage occurs. I add the command in "Run this command file (full name):" under configure shutdown.
@START "E:\shutdown\shutdown.bat"
the script e:\shutdown\shutdown.bat contains
e:
cd \shutdown
set oracle_sid=xxx
sqlplus "/ as sysdba" @e:\shutdown\shutdown.sql
The shutdown.sql contains
show parameter db_unique_name
shutdown immediate
EXIT
I shutdown the UPS for testing, the script is failed to run.
I tested the shutdown.bat with Administrator account, it can work.
What I'm missing?
0