| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Q: how to properly start up and shut down Oracle?
On Sun, 15 Dec 1996 20:36:35 -0500, Charles Chen <htchen_at_ix.netcom.com> wrote:
>Hi. I just finished installing Oracle 7.3.2.1.0 on Solaris 2.5.1 on a
>Sparc10. It is currently up and running since I can go into SQL*Plus
>and query the default EMP table. However, I would like to know how to
>properly shut down Oracle both manually and by some automatic method.
>In addition, I was wondering how to automatically start up Oracle when
>the Sparc10 is rebooted. Thanks for any help you can provide.
>
>
>Sincerely,
>Henry
to get the sparc to run things for you on boot up, you put stuff in the /etc/rcN.d/ files (so much easier then the good ole rc.local :)...
Anyway, i use:
/etc/rc0.d/K100oracle /etc/rc3.d/S100oracle
and they both contain:
# Start/stop processes required for oracle
case "$1" in
'start')
su - oracle -c orastart
;;
'stop')
su - oracle -c orashut
;;
I use orastart and orashut (my own scripts) so i can add things to the oracle startup/shutdown easily (without getting root access to do so).... Anyway, my orastart looks like:
rm -f /var/tmp/.oracle/*
svrmgrl << EOF
connect internal
startup
exit
EOF
lsnrctl start
webstart
cd /usr/oracle/ows2/bin
make_owa_error
ctxstart &
------------- eof ----------------------------------
and my orastop looks like:
svrmgrl << EOF
connect internal
shutdown immediate
exit
EOF
lsnrctl stop
webstop
------------------ eof -------------------------------
Hope this helps.... basically the above show you how to start and stop the server and SQL*net. The other scripts in there relate to my webserver. I just wrote scripts to start em and stop em...
Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com
 |
 |