Automatic Oracle Startup and Shutdown

[grajee]

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

[santoshym]

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

[grajee]

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]

[grajee]

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

[FendleRG]

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

[santoshym]

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

[grajee]

I executed the script manually by running the following

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

and it works fine.

[santoshym]

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

[grajee]

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:\>

[dragon99]

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