Re: Q: how to properly start up and shutdown Oracle?

From: Allen Kirby <akirby_at_att.com>
Date: 1996/12/30
Message-ID: <32C87A7D.79F7@att.com>#1/1

Henry,

	I believe the Oracle install script creates the files necessary
	to auto start the db on transition to multiuser.  I haven't
	set this up in a while but check under /etc (better yet -
	read the manual - it may be in the OS specific installation
	guide) for a file called 'dbstart' or 'orastart' - or just
	grep -i oracle /etc/*.  You simply edit that file and put
	a 'Y' or 'N' for each SID on your system as to whether you
	want it to autostart or not.  As far as shutdown, you need
	to put a script in the /etc/rc*.d directories.  This is also
	how you would do the startup script, but I believe Oracle
	installer already does this, so all you need to do is edit
	the /etc file.  For example, if you want the db to be up
	when in run-level 3, the startup and shutdown script should
	be in the /etc/rc3.d directory.  Look at the other files
	in that directory and you'll get the idea.  It should also
	be explained in answerbook if you have it.  If the scripts
	mentioned by Barry below aren't on your system, just create
	them yourself with the appropriate commands and call them 
	from you rc scripts.

Good Luck

Allen
Barry Schader wrote:
>
> Charles Chen 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
>
> Henry,
>
> I don't know much about Oracle on UNIX, but in the VMS environment, the
> Oracle installer creates some scripts in the ORA_DB directory for the
> database:
> shutdown_<dbname>.com
> startup_exclusive_<dbname>.com
> startup_parallel_<dbname>.com
>
> We modified these for our own purposes, and call the startup procedure in
> our system startup, after a delay to ensure that all of the supporting
> VMS stuff has had time to get started.
>
> Barry Schader
> barry.schader_at_medtronic.com
 

-- 
---
Allen Kirby			AT&T ITS Production Services
akirby_at_att.com			Alpharetta, GA.

Received on Mon Dec 30 1996 - 00:00:00 CST