topic oracle database schedule shutdown in Operating System - HP-UX

oracle database schedule shutdown

Krishnan Kutty — Fri, 17 May 2002 02:21:41 GMT

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

Re: oracle database schedule shutdown

Niel Greeff_1 — Fri, 17 May 2002 02:47:01 GMT

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

Re: oracle database schedule shutdown

Printaporn_1 — Fri, 17 May 2002 02:52:16 GMT

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.