LSNRCTL & ORACLE STARTUP SCRIPT

Firstly, thank you very much to guide me towards preparing my ‘lsnrctl’ and
‘oracle startup’ scripts.
I can execute it manually from unix o/s. But, I don’t know how to keep it
for server to activate them when HPUX-11i – Unix based server is rebooted!!

I am new to unix environment. Could somebody please guide me with steps to
put these scripts in such a way that whenever unix server is shutdown &
started again, these scripts execute on its own?

I am sure that everyone handles startup and shutdown of both instances
differently. Depending on your UNIX system, it will probably sit in an rc
directory - that's run level control. on startup, you need to make sure
that it's in a run level that has everything oracle needs to have in order
to start. one place i worked had oracle startup in rc.2 and it was
s99oracle, making it one of the last things to come up in that level.
shutdown happened in rc3 same convention applied -- script for kill was
k99oracle.

this is sample startup script which would be either copied or linked to
the s script. oracle does provide dbstart and dbshut which could be used
for this, but i find them horrendously out of date and lacking in finesse.
i will send the shutdown in another post/email. what's nice about this
one is that it starts the instances in parallel which is nice if you have
lots of instances on a host. bear in mind, i typically use a startup.sql
script which i keep in the pfile directory. the startup.sql has the
actually connect to the instance and startup cmds, but i also pin some
packages to memory at this point, so i use a script instead of just a
straight forward startup cmd. another thing, lazy as i am, i put things
that i do often (which includes looking for oratab) into functions and
call them from a central location. that's what the reference to .FPATH is
all about. the FIND_ORATAB is a function in that directory -- since we
ran the same script on multiple platforms, it just made life easier.

also, make sure (if you use this) to change the directory locations to the
ones you actually use. hope this is what you were looking for. if not,
let me know in more detail.

#! /bin/ksh
###################################
#
# usage: dbstart
#
# This script is used to start ORACLE from /etc/rc(.local).
# It should ONLY be executed as part of the system boot procedure.
#
#####################################

same things apply to the shutdown script as discussed in previous
email/post:

#! /bin/ksh
###################################
#
# usage: dbshut
#
# This script is used to shutdown ORACLE from /etc/rc(.local).
# It should ONLY be executed as part of the system boot procedure.
#
#####################################