oracle database schedule shutdown

[Krishnan Kutty]

I've oracle installed on hpux 11.11. I need to shutdown the database and then the server at a scheduled time. Can anybody help me with the script.

Thanks & Regards
krishnankutty

[Niel Greeff_1 · Accepted solution]

First the script - put into a file (say /home/nielg/shut)

ORACLE_SID=your_SID_here
export $ORACLE_SID
svrmgrl <connect internal
shutdown immediate
END_MGR
shutdown -y 0


(remember to make the script executable)

Next to enable it all:

as root:

edit /etc/shutdown.allow
add the name of the oracle user in there


also add the name of the oracle user to /var/adm/cron/at.allow


now decide on the time you want it to run (say 10 PM tonight)

as the oracle user:

at -f /home/nielg/shut 2200



Hope that helps
N

[Printaporn_1]

Hi,

Use Neil script but recomment to use
su - oracle -c <script name>
place this in root's cron job for schedule down only database.

if you want to down both OS and database , add database shutdown script in rc.