Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 10g linux suse 9

Re: Oracle 10g linux suse 9

From: HansF <news.hans_at_telus.net>
Date: Thu, 25 Nov 2004 06:38:02 GMT
Message-ID: <e5fpd.182663$df2.22521@edtnps89>


Severus Snape wrote:

> Yang wrote:

>> You should restart your database and http server manually because the
>> installer does not modify your /etc/inittab for automatic database
>> startup.
>> 

>
> I wonder: why? If you install oracle under windows it starts as boot by
> default, why shouldn't it start by default under other os?
>
> Is there any script you should use to start everything properly?

CHapter 2 of the 10g DB Admin manual has an interesting section entitled

"Automating Startup and Shutdown"

which makes reference to dbstart and dbshut. These scripts are intended to be tied to your typical startup/shutdown procedures. (Be aware that older versions did not take into account things like 'SPFILE' so they may need tweaking.)

As for automatically setting that up ...

You may note that different *nix's, including different Linuxes, have different startup and shutdown processes. WHile many use /etc/rc.d, it's not quite universal. And, since it's up to the SA to understand and determine WHEN the startup should occur relative to other services on the machine (eg: S56ora or S80ora?), automating the inclusion might not be a good thing.

Also - being a control freek, I get very annoyed at ANYTHING scribbling in my /etc directories without my permission.

Finally, since many *nix's are set up to be to be rarely booted, many SAs insist on watching and monitoring the boot process very carefully. After all, since for many SAs the only reason to boot a *nix box tends to be a serious malfunction rather than a routine memory reinit (http://www.techworld.com/opsys/news/index.cfm?NewsID=2275), watching the process is both a novelty and a bit of a nerve wracking issue. So it's not really a surprise that minimum effort would be put into a piece of code that should, ideally, only be used once a year - or less.

... You asked <g>
/Hans

disclaimer: The above is based on my experience and based on my observations of installations and people with whom I have exchanged information. Any generalizations in my discussion, and terms such as many or most, should be taken as within context of my experience and may not be true in other contexts. IOW - YMMV. Received on Thu Nov 25 2004 - 00:38:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US