Re: Start-up script for Unix boxes

Hi Mark,

There is a script mentioned in the installation guide that you can copy but you do have to do it yourself. The reason, I'm guessing, is because they don't necessarily know if you want to start Oracle on bootup or not everytime right? Oracle would also not have access to the directories where you keep your scripts. I do agree that they might as well install a simple one in some oracle directory to copy however though. Also, don't forget your K#<app> script to stop Oracle when you want to go to init 0 or whatever too.

As an aside, I use one very similiar to yours and don't bother with the one in the install guide. Last, but not least, you may want to change your dbshut script as it does a Shutdown (Normal) and Oracle will not shutdown with users connected. I changed mine to do a Shutdown Immediate and that clears connections and shuts it down.

Mark Gourley wrote:
>
> Having been involved with the installation of Oracle 7.3.x on numerous
> Unix boxes I've become aware of a service-critical problem, which, while
>
> fairly easy to fix, makes me wonder why Oracle hasn't done something
> about it...
>
> Upon reboot a Unix (Solaris) box starts those services and applications
> which have 'S<xx><app>' scripts in the '/etc/rc<y>.d' directories, where
>
> <xx> is a number between 20 and 99, <app> is the name of the
> application, and <y> specifies the run-level. So for Oracle you might
> expect to see a file called something like 'S98oracle' in the
> '/etc/rc3.d' directory for example. However, this is not the case, and
> it means that whenever the box is rebooted Oracle is NOT restarted, and
> hence any applications which rely on it will not start either.
>
> So, does anyone know why the Oracle installation does not create this
> file? And, if you have created one which is different from that below
> I'd like to hear from you.
>
> Cheers,
> Mark.
>
> /etc/rc2.d/S98oracle
> ==============
>
> #!/bin/sh
>
> case $1 in
> 'start')
> su - oracle -c 'lsnrctl start'
> su - oracle -c 'dbstart'
> ;;
> 'stop')
> su - oracle -c 'dbshut'
> su - oracle -c 'lsnrctl stop'
> ;;
>
> *)
> echo "usage: oracle start|stop"
> ;;
> esac
>
> exit 0;
Received on Thu Nov 05 1998 - 06:59:20 CST