Automatic Oracle Startup and Shutdown

Hi All,

I want to make Oracle 8i to Startup and Shutdown whenever Solaris 8
(for Intel) is broughtup and broughtdown. While I did go through
the Solaris MAN, I'm still not sure of what changes to make.

I know that the rc* files need to be changed but I dont know
which files. Here are the file structures :

C:\>pwd
/sbin
C:\>ls -l rc*
-rwxr--r-- 3 root sys 2792 Jan 5 2000 rc0
-rwxr--r-- 1 root sys 3177 Jan 5 2000 rc1
-rwxr--r-- 1 root sys 2885 Jan 5 2000 rc2
-rwxr--r-- 1 root sys 2341 Jan 5 2000 rc3
-rwxr--r-- 3 root sys 2792 Jan 5 2000 rc5
-rwxr--r-- 3 root sys 2792 Jan 5 2000 rc6
-rwxr--r-- 1 root sys 9973 Jan 5 2000 rcS
C:\>


C:\>pwd
/etc
C:\>ls -ld rc*
lrwxrwxrwx 1 root root 11 Jul 13 19:56 rc0 -> ../sbin/rc0
drwxr-xr-x 2 root sys 1024 Jul 13 20:25 rc0.d
lrwxrwxrwx 1 root root 11 Jul 13 19:56 rc1 -> ../sbin/rc1
drwxr-xr-x 2 root sys 1024 Jul 13 20:25 rc1.d
lrwxrwxrwx 1 root root 11 Jul 13 19:56 rc2 -> ../sbin/rc2
drwxr-xr-x 2 root sys 1024 Jul 13 20:38 rc2.d
lrwxrwxrwx 1 root root 11 Jul 13 19:56 rc3 -> ../sbin/rc3
drwxr-xr-x 2 root sys 512 Jul 13 20:14 rc3.d
lrwxrwxrwx 1 root root 11 Jul 13 19:56 rc5 -> ../sbin/rc5
lrwxrwxrwx 1 root root 11 Jul 13 19:56 rc6 -> ../sbin/rc6
drwxr-xr-x 3 root sys 512 Jul 13 19:56 rcm
lrwxrwxrwx 1 root root 11 Jul 13 19:56 rcS -> ../sbin/rcS
drwxr-xr-x 2 root sys 1024 Jul 13 20:20 rcS.d
C:\>

MAN says that 2 is the multiuser stage. Should the oracle
startup script be appened at the end of /sbin/rc2.

C:\>pwd
/export/home/oracle/oracle817/bin
C:\>ls -l dbs*
-rwxr-xr-x 1 oracle oinstall 2490 Aug 12 2000 dbshut
-rwsr-s--- 1 root oinstall 1480880 Jul 22 04:24 dbsnmp
-rwxr-xr-x 1 oracle oinstall 1420932 Dec 27 2000 dbsnmpO
-rwxr-xr-x 1 oracle oinstall 4081 Aug 12 2000 dbstart
C:\>

Can someone help, please. Also where can I find the different
boot steps involved in Solaris.

Thanks,
gopi

Hi

Do not add a script to the rc files goto the followind directory and create a link using ln command to dbstart to start the database automatically

/sbin/rc2.d

In the above directory create a link with the filename as follows

S100dbstart

The S is used to execute during system startup and the no 100 is it the file exeuction is in sequence for ex 1,2,3...100

and for the database shutdown during th system shutdown create a link to dbshut in the following directory

/sbin/rc0.d

K100dbshut

The K files are executed during system shutdown and the sequence is followed the same as the above.

The above scripts automatically read /etc/oratab file

Regards

Hi Santosh,

Here is what I did after reading ur reply.

I made a link S100dbstart of $ORACLE_HOME/bin/dbstart
in /etc/rc2.d folder.

I made a link K100dbshut of $ORACLE_HOME/bin/dbshut
in /etc/rc0.d folder.

I also made a link /etc/oratab of /var/opt/oracle/EDM/oratab.

When I rebooted, this is the error I get.

Usually, after loggin in as "oracle", and specifying as "connect
internal" from SVRMGRL, it goes thru fine.

When I rebooted, this is the error that I got. Looks like the
startup sequence is trying to start Oracle as someone else.

SVRMGR> connect internal
Password:
ORA-01031: insufficient privileges
SVRMGR>

Do u know how to get the error messages that get generated
while the system boots. In NT we normally check the event viewer. If there is a way to view the log files, then I can email
u the log file itself


[Edited by grajee on 07-28-2001 at 06:33 PM]

Hi Santosh,

THis is what I did after loggin in as root. Otherwise,
if I log in as oracle, I dont have the permission to
create files in the system folders.

[1] I created a file called /etc/init.d/oracle with the contents
#!/sbin/sh
ORACLE_HOME=/export/home/oracle/oracle817
ORACLE_BASE=/export/home/oracle
ORACLE_SID=EDM

echo $ORACLE_HOME
echo "Entered init.d oracle script "
case $1 in
start)
su - oracle -c /export/home/oracle/oracle817/bin/dbstart
su - oracle -c "/export/home/oracle/oracle817/bin/lsnrctl start"

exit 0
;;

stop)
su - oracle -c "$ORACLE_HOME/bin/lsnrctl stop"
su - oracle -c $ORACLE_HOME/bin/dbshut
;;
esac

echo "End of the oracle script - gopi"

[2] ln -s /etc/init.d/oracle /etc/rc2.d/S98oracle. Here is a listing
of the folder.
C:\>ls -l S9*
-rwxr--r-- 5 root sys 1131 Feb 23 09:19 S90wbem
-rwxr--r-- 5 root sys 391 Jan 5 2000 S92volmgt
-rwxr--r-- 2 root sys 364 Jan 5 2000 S93cacheos.finish
-rwxr--r-- 5 root sys 1181 Jan 5 2000 S94ncalogd
-rwxr--r-- 5 root sys 522 Dec 22 2000 S95ncad
lrwxrwxrwx 1 root root 16 Jul 13 20:25 S96ab2mgr -> ../init.d/ab2mgr
lrwxrwxrwx 1 root other 18 Jul 30 00:53 S98oracle -> /etc/init.d/oracle
-rwxr--r-- 5 root sys 447 Jan 5 2000 S99audit
-rwxr--r-- 5 root sys 2804 Dec 2 1999 S99dtlogin
C:\>

[3] ln -s /var/opt/oracle/oratab /etc/oratab

[4] I rebooted and expected oracle to start. But oracle fails to
start.

I dont know in which folder the solaris OS writes the messages.
I do see this line "Entered init.d oracle script " on the screen
but I dont think it is sucessfully executing the dbstart since
I dont see "End of the oracle script - gopi".

Any help ? I have ran out of ideas !!

Thanks,
gopi

Solaris puts system messages in /var/adm/messages. What is logged there is controlled by /etc/syslog.conf

The output from your script will not get logged anywhere unless you direct it. For example, define a logfile as LOG=/tmp/start.log
and then for each command redirect standard out to the log as in
/usr/local/bin/doit.script > $LOG
Standard error (error messages) can also be redirected by adding a 2>&1 to the end as in
/usr/local/bin/doit.script > $LOG 2>&1

Hope this helps a little

Hi Gopi,

First thing is just exexute the scripts when the system is on and see weather it is able to start and shutdown the databases. Make sure that the scripts are doing the tasks they are supposed to do.

Regards

I executed the script manually by running the following

su - oracle -c /export/home/oracle/oracle817/bin/dbstart

and it works fine.

Hi Gopi,

Try this

Copy your dbstart,dbshut scripts into /sbin/init.d

and then create a link the same way you did earlier but now to these files. Let me know how it goes

Regards

Hi All,

Why is the dbstart script which is included in the oracle file
starting a OpenWindows session. I guess this is the reason why oracle fails to startup.

Thanks,
gopi

C:\>pwd
/etc/init.d

C:\>ls -l oracle
-rw-r--r-- 1 root other 76 Aug 1 12:54 oracle

C:\>cat oracle
su - oracle -c /export/home/oracle/oracle817/bin/dbstart > /var/adm/oramess
C:\>


C:\>ls -l S99*
-rwxr--r-- 5 root sys 447 Jan 5 2000 S99audit
-rwxr--r-- 5 root sys 2804 Dec 2 1999 S99dtlogin
lrwxrwxrwx 1 root other 18 Aug 1 13:13 S99oracle -> /etc/init.d/oracle
C:\>

C:\>pwd
/var/adm
C:\>ls -l oramess
-rw-r--r-- 1 root root 120 Aug 1 13:00 oramess
C:\>cat oramess
Sun Microsystems Inc. SunOS 5.8 Generic February 2000

Starting OpenWindows in 5 seconds (type Control-C to interrupt)

C:\>

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.

Dragon

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)!