topic Re: Help writng script in Operating System - HP-UX

Help writng script

Eric Shupe — Wed, 18 Sep 2002 11:44:12 GMT

I am trying to write a script to shutdown a database so it can be incorporated into my backup. When I type the following commands at the command line as root it works no problem:

# su - oracle
$ csh
$ dserv_shutdown
$ exit
$ exit

when I put these commands into a script it seems to only execute the first line. Am I doing soemthing wrong or do I need to go about doing this a different way??

Thanks for any advice.

Re: Help writng script

Neil Haslum_1 — Wed, 18 Sep 2002 11:50:38 GMT

try putting those commands after su - oracle and running
su - oracle -c <script>

Re: Help writng script

Neil Haslum_1 — Wed, 18 Sep 2002 11:51:39 GMT

in english this time:
try putting those commands after su - oracle in a script and running
su - oracle -c <script>

Re: Help writng script

Allan Pincus — Wed, 18 Sep 2002 12:04:17 GMT

Your first command is switching users, so it probably needs a password authentication, and is not getting it. You need to log into oracle first, or authenticate the user through the script.

-Allan

Re: Help writng script

Fred Martin_1 — Wed, 18 Sep 2002 12:26:54 GMT

Switching shells is the problem, I think. The 'csh' line for example, opens a new environment space that knows nothing about the previous one, including the script that may be running. Do you need to be in csh (or, do you need to be user oracle) to shut down the database?

If your backup script runs as root, would it do to just have the dserv_shutdown line in the script directly?

Re: Help writng script

Eric Shupe — Wed, 18 Sep 2002 12:38:09 GMT

In order to shutdown the database it must be user oracle and it must be in the C shell. root cannot stop it. there are a bunch of variables set within user oracle.

Re: Help writng script

Keith Johnson — Wed, 18 Sep 2002 12:46:48 GMT

We have a "master script" to run our Oracle DB backkups. Our cron entry looks like:

00 02 * * 0-6 /script/name > /output/log 2>&1

Within the script we call several other scripts, including the one that actually shuts the DB down and performs the backup. It is called like:

/bin/su - oracle7 - c "/script/name1"

Works pretty well for us.

HTH

KJ

Re: Help writng script

Keith Johnson — Wed, 18 Sep 2002 12:49:29 GMT

Forgot to mention that we run this from the root cron.

KJ

Re: Help writng script

Andreas Voss — Wed, 18 Sep 2002 13:54:15 GMT

Hi,

this should work:

su - oracle -c "/bin/csh -c dserv_shutdown"

Regards

Re: Help writng script

Shahul — Wed, 18 Sep 2002 14:25:04 GMT

Hi

Once U do su, then U are in different environment. Actually, the commands after #su - oracle are not taking in to effect. U can see the outputs in the old environment.

Solution is either U do like this

#su - oracle -c "csh dserv_shutdown"

Or

Create a script with the commands except su command and then

#su - oracle -c "cat /tmp/script"

This both will work.

Best of luck
Shahul

Re: Help writng script

Wodisch — Wed, 18 Sep 2002 17:41:57 GMT

Hi,

how about:

su - oracle <csh -c dserv_shutdown
EOF

That should do the trick...

Regards,
Wodisch

Re: Help writng script

Geoff Wild — Wed, 18 Sep 2002 19:35:27 GMT

A good way to do this is like:

First create a script in oracle's path - say oracle_stop.

Then, from your backup server:

`/bin/su - oracle -c "oracle_stop"`