08-22-2002
We can't help without information
Please post this script
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I've been trying to execute a script which call some SQL Queries for midnight report, using crontab I got the next mesage:
Message file sp1<lang>.msb not found
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
Error 6 initializing SQL*Plus
If I use the "at" command it... (4 Replies)
Discussion started by: alex blanco
4 Replies
2. UNIX for Dummies Questions & Answers
hi all
yes, I am a beginner in Unix,-sun solorais--V8...
what is the command to run files....
single and batch jobs....any help would be great...
Cheers
ps...i know running files in Sqlplus on Unix prompt, I can use the @' sign...but how does this work..
Cheers
E (2 Replies)
Discussion started by: etravels
2 Replies
3. Shell Programming and Scripting
Problem:
I have a crontab and when it kicks off, xxx.sh shell script is called. Which has a nohup sqlplus session call. Problem is sql does not get executed and a text file is not getting created. Only a empty log file is getting created. Are there any constraints for crontab to open a sql... (6 Replies)
Discussion started by: radhika
6 Replies
4. Shell Programming and Scripting
Hi,
I wrote a script shell whose function is to make a remove of directories depending on the result of a query on Oracle database.
When I execute my script shell directly from unix, it works fine. But, when I put it in a line of a crontab, it doesn't work no more, because of the sql... (1 Reply)
Discussion started by: tbeghain
1 Replies
5. UNIX for Advanced & Expert Users
Hi experts,
need your helpo.
after editing the crontab while saving the file it says-
"/tmp/crontabRlaauT" 1 line, 77 characters
cron may not be running - call your system administrator
And i checked after certain time. script in cron is not running. I got a mail in user saying... (1 Reply)
Discussion started by: thepurple
1 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
Here is my command which I've scheduled to be run from crontab, but it's giving error message: rah: rahhost executable needed but not in PATH
My cmd is-
36 10 * * * /opt/IBM/dwe/db2/V9.5/bin/rah "df -m" >> /db2home/bculinux/Files/log/db.out 2>&1
Though I've added path... (5 Replies)
Discussion started by: NARESH1302
5 Replies
7. UNIX for Dummies Questions & Answers
Hi guys today i'll bring to you a new problem that i need to execute.
So what i need to do it's create a script that:
conect to some database
logon
run a .sql script
logoff
and close the connection
after that, put this script on the crontab
To set up the crontab it's ok for me, i think... (3 Replies)
Discussion started by: Newer
3 Replies
8. UNIX for Dummies Questions & Answers
Hi All,
I am having the below script to be run from crontab, it it doesnt run.
1 * * * * /home/cobr_ext/test.sh > /home/cobr_ext/temp.txt
when i run i manally it runs without any issues.
Could please help me as to why doesnt it run the script.:( (7 Replies)
Discussion started by: abhi_123
7 Replies
9. Solaris
hi,
i have crontab where i have put my db backup scripts but crontab do not run at specific time. i have checkted the scripts andwhen run the script as ./mydbbkp.sh so it successfully run and do the job but from cron it is not running whihcmeans cron is not running. i have an oracle user under... (3 Replies)
Discussion started by: janakors
3 Replies
10. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT DEBIAN
amzfs-snapshot
AMZFS-SNAPSHOT(8) System Administration Commands AMZFS-SNAPSHOT(8)
NAME
amzfs-snapshot - Amanda script to create zfs snapshot
DESCRIPTION
amzfs-snapshot is an Amanda script implementing the Script API. It should not be run by users directly. It create a zfs snapshot of the
filesystem where the path specified is mounted.
PRE-DLE-* create a snapshot and the POST-DLE-* destroy the snapshot, *-DLE-AMCHECK, *-DLE-ESTIMATE and *-DLE-BACKUP must be set to be
executed on the client:
execute-on pre-dle-amcheck, post-dle-amcheck, pre-dle-estimate, post-dle-estimate, pre-dle-backup, post-dle-backup
execute-where client
The PRE_DLE_* script output a DIRECTORY property telling where the directory is located in the snapshot. The application must be able to
use the DIRECTORY property, amgtar can do it.
The script is run as the amanda user, it must have the priviledge to create and destroy snapshot:
zfs allow -ldu AMANDA_USER mount,snapshot,destroy FILESYSTEM
Some system doesn't have "zfs allow", but you can give the Amanda backup user the rights to manipulate ZFS filesystems by using the
following command:
usermod -P "ZFS File System Management,ZFS Storage Management" AMANDA_USER
This will require that your run zfs under pfexec, set the PFEXEC property to YES.
The format of the DLE must be one of:
Desciption Example
---------- -------
Mountpoint /data
Arbitrary mounted dir /data/interesting_dir
ZFS pool name datapool
ZFS filesystem datapool/database
ZFS logical volume datapool/dbvol
The filesystem must be mounted.
PROPERTIES
This section lists the properties that control amzfs-snapshot's functionality. See amanda-scripts(7) for information on the Script API,
script configuration.
DF-PATH
Path to the 'df' binary, search in $PATH by default.
ZFS-PATH
Path to the 'zfs' binary, search in $PATH by default.
PFEXEC-PATH
Path to the 'pfexec' binary, search in $PATH by default.
PFEXEC
If "NO" (the default), pfexec is not used, if set to "YES" then pfexec is used.
EXAMPLE
In this example, a dumptype is defined to use amzfs-snapshot script to create a snapshot and use amgtar to backup the snapshot.
define script-tool amzfs_snapshot {
comment "backup of zfs snapshot"
plugin "amzfs-snapshot"
execute-on pre-dle-amcheck, post-dle-amcheck, pre-dle-estimate, post-dle-estimate, pre-dle-backup, post-dle-backup
execute-where client
#property "DF-PATH" "/usr/sbin/df"
#property "ZFS-PATH" "/usr/sbin/zfs"
#property "PFEXEC-PATH" "/usr/sbin/pfexec"
#property "PFEXEC" "NO"
}
define dumptype user-zfs-amgtar {
dt_amgtar
script "amzfs_snapshot"
}
SEE ALSO
amanda(8), amanda.conf(5), amanda-client.conf(5), amanda-scripts(7)
The Amanda Wiki: : http://wiki.zmanda.com/
AUTHORS
Jean-Louis Martineau <martineau@zmanda.com>
Zmanda, Inc. (http://www.zmanda.com)
Dustin J. Mitchell <dustin@zmanda.com>
Zmanda, Inc. (http://www.zmanda.com)
Amanda 3.3.1 02/21/2012 AMZFS-SNAPSHOT(8)