topic Re: running commands at selected time in Operating System - HP-UX

running commands at selected time

Ahmed M. AlShafiy — Tue, 03 Jan 2006 03:52:42 GMT

how can i run a command that is owned by another user than the root at a selected time.

i have a commands under the application admin to stop the oracle application and another commands under the database user to stop and restart the oracle database.

and after that i want to select a time to run a backup.

Re: running commands at selected time

Muthukumar_5 — Tue, 03 Jan 2006 03:54:54 GMT

You can choose schedular(s) like crontab or at to start commands at required time. Or else you can make scripting to check time and sleep for the rest of the time.

--
Muthu

Re: running commands at selected time

Muthukumar_5 — Tue, 03 Jan 2006 03:56:21 GMT

write down script for start and stopping oracle application and as well as backup. Put the crontab with crontab -e using that user.

You have to use sudo to run the application from that user without using password.

--
Muthu

Re: running commands at selected time

Ahmed M. AlShafiy — Tue, 03 Jan 2006 03:57:12 GMT

sorry but i'm a new with HP-UX can you help me with the steps to do it?

:(

Re: running commands at selected time

Joseph Loo — Tue, 03 Jan 2006 03:57:42 GMT

hi,

u may use "cron" or "at" to schedule the job.

for root to run the script as another user:

# su - -c <script>

regards.

Re: running commands at selected time

Devender Khatana — Tue, 03 Jan 2006 03:58:10 GMT

Hi,

The process of executing a command at a particular time can be done by both at and cron. But best to do for this sort of scenario will be to create a script which checks for the status of completion of first command and only after successful completion of the first command executes the later part.

HTH,
Devender

Re: running commands at selected time

Muthukumar_5 — Tue, 03 Jan 2006 03:58:13 GMT

Refer this:

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=726079

http://www2.itrc.hp.com/service/james/search.do?todo=search&admit=-1335382922+1136278644729+28353475&searchtext=oracle+scheduling&from=forums&origin=0&submit.x=0&wpa=forums1.itrc.hp.com%3A80&submit.y=0&searchcategory=ALL&hpl=1&searchcriteria=allwords&rn=25&source=7000&presort=rank&chkServStor=on&esc=us.support.itrc.hp.com

scheduling oracle script(s).

--
Muthu

Re: running commands at selected time

Arunvijai_4 — Tue, 03 Jan 2006 03:58:35 GMT

Hi,

You can write your own script and put it in crontab or at to run at selected time.

# man crontab
# man at

for more details.

-Arun

Re: running commands at selected time

Cem Tugrul — Tue, 03 Jan 2006 04:00:25 GMT

Selam Ahmed,
"at" or "crontab" are for running jobs
automatically.Normally "at" is using for to run only 1 ,cron is for to run a processes,script more than 1 as permanently

Good Luck,

Re: running commands at selected time

Muthukumar_5 — Tue, 03 Jan 2006 04:00:45 GMT

Are you able to stop / start / take backup from command line. Try to take those command and,

login with that user which you want to run the commands,

crontab -e

and use the format of,

minute hour monthday month weekday command

Change this format to suit your requirement. My previous reply is having more examples.

--
Muthu

Re: running commands at selected time

Cem Tugrul — Tue, 03 Jan 2006 04:03:16 GMT

http://www4.itrc.hp.com/service/james/search.do?searchtext=cron%2Bat&hpl=1&todo=search&searchcriteria=allwords&from=forums&searchcategory=ALL&rn=25&presort=rank&source=7000&esc=europe.support.itrc.hp.com&wpa=forums1.itrc.hp.com%3A80&origin=0&chkServStor=on

Re: running commands at selected time

Arunvijai_4 — Tue, 03 Jan 2006 04:05:22 GMT

Some threads for your reference,

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=821853
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=31119

-Arun

Re: running commands at selected time

Yogeeraj_1 — Tue, 03 Jan 2006 04:17:22 GMT

hi,

First of all you must create a script for each of the following operations:
a. Stop the Oracle Application
b. Shutdown the Oracle database
c. Startup of the Oracle Database
d. Perform a database backup
e. Startup of the Oracle Application

(nb. a & e can be one script as well as b &c.

You can then use "cron" or "at" to schedule the execution at the required times.

kind regards
yogeeraj

Re: running commands at selected time

Ahmed M. AlShafiy — Wed, 04 Jan 2006 02:54:15 GMT

we have the scripts for shutting down the application and the database:
1- ./stopappl for shutdown the application.
2- ./stoporadb for shutdown the database.

so if i want to run this to scripts at 18:00pm evrey day exept weekends.

what is the full command to do it?

remark: ./stopappl under applmgr user and the ./stoporadb under oracle user.

Re: running commands at selected time

Arturo Galbiati — Wed, 04 Jan 2006 04:02:14 GMT

Hi,
you should put in place something like this:

###########################################################
# -
###########################################################
###########################################################
# BACKUP ON ....... ..:.. AM ... - ..: PM server time
###########################################################

# ---------------------------------------------------------
# Daily
# ---------------------------------------------------------
# minute hour monthday month weekday (0=Sunday) command
# 0-59 0-23 1-31 1-12 0-6
03 00 * * * crontab -l > file_cron
00 18 * * 1-5 stopappl >/tmp/stopapl.log 2>&1
10 18 * * 1-5 remsh $(hostname) -l oracle -n stoporadb >/tmp/stoporadb.log 2>&1

#eof

the stopradb is executed from the same user but connecting via remsh to oracle user.
Take care to load the profile and the right Oracle envirinemt in your script because crontab doesn't load the porofile for you.

HTH,
Art

Re: running commands at selected time

Ahmed M. AlShafiy — Wed, 04 Jan 2006 07:50:32 GMT

i have worte this command under root user for testing:

# cd /oracle

#at -f ./stopappl -m aalshafiy@host -t 0601041500.00

then i get a message to the root user:

bad time specification

Re: running commands at selected time

James R. Ferguson — Wed, 04 Jan 2006 08:02:36 GMT

Hi:

The error message from 'at' is misleading. The problem is that the '-m' switch cannot have an argument with it. Instead of:

# at -f ./stopappl -m aalshafiy@host -t 0601041500.00

...you should have written:

# at -f ./stopappl -m -t 0601041500.00

Regards!

...JRF...

Re: running commands at selected time

Ahmed M. AlShafiy — Wed, 04 Jan 2006 08:20:57 GMT

the ./startappl it's a script and it's owned by oracle user not root and when i wrote under root user:

# cd /oracale

# at -f ./startappl -m -t 0601041610.00

i get this tow messages sent to root:

1- Cron: cron|at job completed: 1136416200.a 21091 a Wed Jan 4 16:10:02 MST 2006

2- Not a terminal
stty: : Not a typewriter
stty: : Not a typewriter

[3g
H H H H H H H H H
You are running addbctl.sh version 115.3

Starting the database NAS ...

SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jan 4 16:10:00 2006

(c) Copyright 2000 Oracle Corporation. All rights reserved.

ERROR:
ORA-01031: insufficient privileges

ORA-01031: insufficient privileges

addbctl.sh: exiting with status 0

You are running addlnctl.sh version 115.2

Starting listener process NAS ...

addlnctl.sh: exiting with status 0
logout

*************************************************
Cron: The previous message is the standard output
and standard error of one of your at commands.

how i can run the job?

Re: running commands at selected time

Sivakumar TS — Wed, 04 Jan 2006 09:20:26 GMT

Dear Ahmed,

Some oracle scripts needs to be run only after logging in as oracle user, the .profile and the privilleges are customised for that.

Try

#su - -c < command_to_be_executed>

as the COMMAND in the "at" command.

With Regards,

Siva.

Re: running commands at selected time

Ahmed M. AlShafiy — Wed, 04 Jan 2006 09:28:31 GMT

when i try to use at command under oracle user it give me this message:

you are not authorized to use at. Sorry.

how i can give authoriz to oracle user to use at and corntab to other users than root.