Automatic Oracle Startup and Shutdown

Hi All,

Thanks to all those who helped. The problem was in the .login file
of oracle login. I use csh by default. Since .login had calls to OPENWINDOWs, the "su - oracle -c ..... " was actually trying to start
OPENWINDOW session.

Strangely, when I login from the console, TERM is set to dtterm. SO
that being the case, I dont know how the OPENWINDOW session works.

Here is the script.

THanks,
gopi

# @(#)local.login 1.5 98/10/03 SMI
stty -istrip
# setenv TERM `tset -Q -`

#
# if possible, start the windows system. Give user a chance to bail out
#
if ( "`tty`" == "/dev/console" ) then

if ( "$TERM" == "sun" || "$TERM" == "sun-color" || "$TERM" == "AT386" ) then

if ( ${?OPENWINHOME} == 0 ) then
setenv OPENWINHOME /usr/openwin
endif

echo ""
echo -n "Starting OpenWindows in 5 seconds (type Control-C to interrupt)"
sleep 5
echo ""
$OPENWINHOME/bin/openwin
clear # get rid of annoying cursor rectangle
logout # logout after leaving windows system

endif

endif

I have followed the post from Gopi (grajee) on "Automatic Oracle Startup and Shutdown" with keen interest, and have also followed the good advice therein from Santosh.

I got past an Oracle 'known error'" (known to Oracle maybe, but users?) whereby dbstart reported it had warm started a db, but in fact it did not, when using v8.1.6... it is detailed in Oracle's MetaLink Doc # 98418.1 in case anyone else is stumped too!

I can now run my script 'oracle' which is in /etc/rc.d/init.d, and I've created the links S98oracle in rc2.d and K98oracle in rc0.d... and I've peppered just about every other rc folder where I see httpd (Apache) being started or stopped with links . Ok, well I am a newbie to Linux, Java and Oracle.

But now I'm stuck: 'Dragon' suggested as follows: "grajee, did you setup your env in your dbstart file? Like you said, you could mannually start the db with the script, but not the autostart, I think the difference here is the env. Try and see if it works."

Unfortunately, I haven't the foggiest what the 'env' is, or how to set it up... couldn't find 'env' in dbstart. My script works when I run it from telnet, but not during a reboot.

Dragon, if you're reading this... or Santosh... or Gopi if you've resolved this... I'd sure as hell be grateful for a pointer on this last bit! (and I'll buy you a beer or ten if you're ever 'down under' in Oz)!