Oracle 8.05 startup under HPUX10.20

[Tommy Brown]

Has anyone scripted/automated the startup procedures for their Oracle Databases?
We ahve three instances running on our server and would like to simplify the startup.
Thanks,
Tommy

[Victor BERRIDGE]

create /sbin/init.d/rc.oracle script:
#!/usr/bin/ksh
export ORAC_EXPLOIT=/opt/oracle/admin/exploit
export PATH=$PATH:/usr/bin:$ORAC_EXPLOIT/proc


case "$1" in
start_msg)
echo "Start Oracle"
;;
stop_msg)
echo "Stop Oracle"
;;
start)
$ORA_EXPLOIT/proc/db_start
su - oracle -c $ORA_EXPLOIT/proc/net_start
;;
stop)
su - oracle -c $ORA_EXPLOIT/proc/net_stop
$ORA_EXPLOIT/proc/db_shut
;;
*)
echo "usage: $0 {start|stop}"
#rval=1
;;
esac

Then link it at the runlevel you desire with SXXX and KXXX in the correct runlevel (eg rc3.d:
lrwxrwxrwx 1 root other 22 Dec 2 1999 K200oracle -> /sbin/init.d/rc.o
racle...
Then to stop/start oracle:
cd /sbin/init.d
./rc.oracle stop
./rc.oracle start

Hope this will help a bit

[Tommy Brown]

Thanks, for your input, What we are after is what you called (I think) ORAC_EXPLOIT.
We don't feel comfortable because of the "srvrmgr" interaction. We probably will not start up automatically after a reboot, but would like to have a "script" to call that will bring up the Oracle instance.
Tommy

[Victor BERRIDGE]

ORA_EXPLOIT is only a variable...
Ther is no need for stop/starting oracle to go through srvrmgr, I can never remember this cmd...
the original oracle script to start and stop oracle are in ~oracle/product//bin and are called dbstart, dbstop these are the original to do what we do...
You may have noticed, my kill oracle is in runlevel 3 this is the default of the machine so if the machine reboots for any reason oracle will NOT be up, you will have to change the level to 4...

Good luck
Best regards
Victor

[Tommy Brown]

Victor, When I look at dbstart, it appears to be for V7 of Oracle, not 8.05. In Oracle classes, the told us to start as svrmgr, that was why we were wondering if any one had any other procedures.
Thanks,
Tommy

[Victor BERRIDGE]

I have some oracle 8.0.4 (8.0.5 is on one machine but I cant remember which...) but on hpux11, do you want me to look at the scripts?
Victor

[Victor BERRIDGE]

Hi Tommy,
Victor again
here is a interesting machine (D230 HPUX11):
look at bdf result:
:..exploit/proc>bdf
Filesystem kbytes used avail %used Mounted on
/dev/vg00/lvol3 102400 31727 66275 32% /
/dev/vg00/lvol1 99669 33244 56458 37% /stand
/dev/r5vg03/lvol1 3588096 3123859 436458 88% /work
/dev/vg00/lvol8 512000 438498 69264 86% /var
/dev/r5vg02/lvol5 512000 105614 381588 22% /var/opt/oracle
/dev/r5vg02/lvol6 409600 267036 133710 67% /var/opt/app/budget
/dev/vg00/lvol7 614400 458719 146009 76% /usr
/dev/r5vg01/lvol8 409600 122663 269062 31% /tmp2
/dev/vg00/lvol6 102400 38314 60171 39% /tmp
/dev/vg00/lvol9 102400 59143 40604 59% /sm
/dev/vg00/lvol5 716800 484167 218169 69% /opt
/dev/r5vg02/lvol1 462848 45200 391633 10% /opt/tuxedo
/dev/r5vg01/lvol1 409600 48275 339018 12% /opt/oracle
/dev/r5vg03/lvol2 1335296 1161086 163377 88% /opt/oracle/product/8.1.5
/dev/r5vg01/lvol10 1126400 693710 405723 63% /opt/oracle/product/8.0.5
/dev/r5vg01/lvol2 1126400 710791 389691 65% /opt/oracle/product/8.0.4
/dev/r5vg02/lvol12 327680 288948 36374 89% /opt/oracle/product/7.3.3
/dev/r5vg01/lvol6 307200 164509 133778 55% /opt/natstar
/dev/r5vg02/lvol11 155648 123165 31087 80% /opt/ars
/dev/r5vg01/lvol5 409600 1205 382878 0% /opt/app/budget
/dev/vg00/lvol4 102400 46889 52253 47% /home
/dev/r5vg02/lvol2 102400 97585 4688 95% /home/patrol
/dev/r5vg02/lvol8 3584000 3089912 465761 87% /data/mnt6
/dev/r5vg01/lvol7 3584000 3202149 357988 90% /data/mnt5
/dev/r5vg02/lvol4 3584000 2307959 1201202 66% /data/mnt4
/dev/r5vg01/lvol4 3584000 3433629 141996 96% /data/mnt3
/dev/r5vg02/lvol3 3584000 3160132 397436 89% /data/mnt2
/dev/r5vg01/lvol3 3584000 3276800 288123 92% /data/mnt1

The init script is the same as the one I sent you but the db_shut is custom since we have many instances and of different version, does that interest you?
I could send you a copy of the lot so you can meditate but dont know how to join files using the reply on the web. Send me your Email (victor.berridge@etat.ge.ch) and I will send you back the files

Best regards
Victor

[Victor BERRIDGE]

Victor again,
I looked, if fact ~proc/db_start calls oracle's instance_start the same for stop, and I asked confirmation to the dba with who I share the office...

[Victor BERRIDGE]

Hi Tom
you will have noticed the instance_start is also a customized file but the solution is in it! , you cant always trust what DBAs say...

Good Luck
Victor

[CHRIS ANORUO]

Hi Victor,

You have to link these files $ORACLEHOMEDIR/bin/dbshut and $ORACLEHOMEDIR/bin/dbstart to the attached startup/shutdown script. The script is placed in /sbin/init.d and the call up script is in /etc/rc.config.d/oraclestart.
In /etc/rc.config.d/oraclestart, I have ORACLE_START=1 to start the script in /sbin/init.d. Please go through the attached script to learn the links.