Shell Programming and Scripting

I have seen this done before - and maybe there is a better way too.

I want to be abe to use a for loop (or other better method) to loop through the database instance names that are part of the script - not an external file where a read might be ok.

Here is what I have and I know won't work - but to give you'all an idea of what I am trying to do.

#!/bin/ksh

...
...

OPER="list of database instances here"

for i in $OPER
do

case "$1" in
'start')
;
;

'stop')
;
;
esac
done

For starters it would be

Code:

case "$i"

not $1

It's a mistake everyone makes.

This is called at system boot time (which gets the start/stop argument) :

What I want to do is case the $1 start/stop as indidcated but for each database do either "start" or "stop".

Ok. FWIW - I don't understand why an instance would be running at boot time and need to be stopped...

I also do not see why this fails a priori. Do you get error messages?
Are you sure that all the needed environment variables are set so you can start each instance - assuming Oracle:PATH, ORACLE_HOME for example. You code should work from a logic point of view, therefore it has to be failing for another set of reasons:

bad environment (most likely):
including PATH or LD_LIBRARY_PATH or SHLIB_PATH to runtimes
permissions (not likely)
other errors in coding the calls to start/stop the instance.

It looks like he's setting up an init.d script, where you can call it with the "start" arg at startup, "stop" at shutdown, "status" anywhere inbetween, etc...

The script will be called with "start"/"stop" as arguments. Typically at start start up or shutdown - although it could be run anytime with the correct arguments.


db_script start
db_script stop


When it does I want to loop through all the databases - not just one. And I prefer that db start list be in the script (not read in from a file - although I could be convienced otherwise).

If there is a better way great.