Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 8.05 startup under HPUX10.20

SOLVED
Go to solution
Tommy Brown
Respected Contributor

Oracle 8.05 startup under HPUX10.20

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
I may be slow, but I get there !
12 REPLIES
Victor BERRIDGE
Honored Contributor

Re: Oracle 8.05 startup under HPUX10.20

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
Respected Contributor

Re: Oracle 8.05 startup under HPUX10.20

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
I may be slow, but I get there !
Victor BERRIDGE
Honored Contributor

Re: Oracle 8.05 startup under HPUX10.20

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
Respected Contributor

Re: Oracle 8.05 startup under HPUX10.20

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
I may be slow, but I get there !
Victor BERRIDGE
Honored Contributor

Re: Oracle 8.05 startup under HPUX10.20

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
Honored Contributor

Re: Oracle 8.05 startup under HPUX10.20

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
Honored Contributor

Re: Oracle 8.05 startup under HPUX10.20

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
Honored Contributor

Re: Oracle 8.05 startup under HPUX10.20

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
Honored Contributor

Re: Oracle 8.05 startup under HPUX10.20

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.
When We Seek To Discover The Best In Others, We Somehow Bring Out The Best In Ourselves.
CHRIS ANORUO
Honored Contributor
Solution

Re: Oracle 8.05 startup under HPUX10.20

Tommy and Vic,

Have a look at the dbstart script that I have written, it is attached. Now the listener starts last when warm starting (as the server is coming up and goes down first when shutting down the databases. The dbshut script is a reverse script to the dbstart. I have oracle 8.0.5 which we have upgraded to 8.0.5.2.2 for the MTS functions.
When We Seek To Discover The Best In Others, We Somehow Bring Out The Best In Ourselves.
Tommy Brown
Respected Contributor

Re: Oracle 8.05 startup under HPUX10.20

Thank you both for your input. My coworker is working these into our procedure.
Thanks, again,
Tommy
I may be slow, but I get there !
R. Allan Hicks
Trusted Contributor

Re: Oracle 8.05 startup under HPUX10.20

Yes, I start my 7.3.4.4 server under HP-UX 10.20 and my 8.1.6 servers under 11.00. I've used the script from the Oracle installation guide to set up the instance to start at run level 2 and to shutdown via the same mech. I need to set the listeners up to start automatically. Haven't gotten around to that yet.

If you don't have the install manual, let me know and I will provide more details.
"Only he who attempts the absurd is capable of achieving the impossible