Re: Starting Oracle automatically on UNIX

From: Richard Lloyd <rkl_at_csc.liv.ac.uk>
Date: 1996/12/11
Message-ID: <E28z5G.8G@csc.liv.ac.uk>#1/1

In article <589abv$5vp_at_dfw-ixnews6.ix.netcom.com>, rjkrause_at_ix.netcom.com (Bob Krause) writes:
>Then in your boot rc type file you can add the command dbstart with
>the name of the SID and it will start up your database up for you. But
>don't forget to start the listener also. You would add the command
>lsnrctl start to the file. Of course you should provide the correct
>paths to the above named commands and the piping of the commands ouput
>to the correct place.

You forgot to mention that these processes are supposed to be started as the "oracle" user I believe, so you'll need to arrange an "su oracle -c <command>" in your boot sequence. The tricky thing is that need to set up environmental variables as well in that su context, so you're probably better off with a wrapper script around it that's run, which sets up the variables and then exec's the appropriate command.

Don't forget the shutdown sequence too (call dbshut and shut down the listener) !!!!

Richard K. Lloyd,         E-mail: rkl_at_csc.liv.ac.uk
Computer Science Dept.,      WWW: http://www.csc.liv.ac.uk/users/rkl/

Liverpool University,
Merseyside, England,
Great Britain. Received on Wed Dec 11 1996 - 00:00:00 CST