Operating System - HP-UX
1748267 Members
3613 Online
108760 Solutions
New Discussion юеВ

oracle database schedule shutdown

 
SOLVED
Go to solution
Krishnan Kutty
Occasional Contributor

oracle database schedule shutdown

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
Krishnan Kutty
2 REPLIES 2
Niel Greeff_1
Advisor
Solution

Re: oracle database schedule shutdown

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
Well, we all try
Printaporn_1
Esteemed Contributor

Re: oracle database schedule shutdown

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.
enjoy any little thing in my life