10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am new to shell scripting and i want to know how to execute the *.sql files from a folder through sqlplus in shell script and files should be execute in sequentially one by one while execution if any ORA error it has to exit from sqlplus session
1) scripts from external folder
2) logs has... (1 Reply)
Discussion started by: sreekanth Reddy
1 Replies
2. Shell Programming and Scripting
Hi,
I require help to complete below requirement through Linux Script.
I have a SQL query which shows two columns as output. One is Report Name and other is report path. Query return multiple rows. below is the output.
Report Name
Cotton Stock Report (Net Weight)- Customized
Output... (3 Replies)
Discussion started by: usman_oracle
3 Replies
3. Shell Programming and Scripting
Hello,
I want to use shell script to generate network files (I tried with python but its taking too long).
I have a list of nodes:
node.txt
LOC_Os11g37970
LOC_Os01g07760
LOC_Os03g19480
LOC_Os11g45740
LOC_Os06g08290
LOC_Os07g02800
I have an edge-list as well: edge.txt
Source_node ... (2 Replies)
Discussion started by: Sanchari
2 Replies
4. Shell Programming and Scripting
Hi, We are having multiple .sql files generated programatically which is not containing..
create or replace -- at the start
and
/ -- at the end
We need to append those .sql files with the above 2 statements at their respective positions.
We will be really thankful to get responses... (6 Replies)
Discussion started by: Rami Reddy
6 Replies
5. UNIX for Dummies Questions & Answers
A perl script that displays the list of files which have multiple links..!
ls -l shows number of links in a field. (0 Replies)
Discussion started by: aadi_uni
0 Replies
6. UNIX Desktop Questions & Answers
How can we find files that were soft linked to an original file and then the original has been deleted. these soft linked files won't then be accessible. How can we find orphan linked files?
Thanks, (3 Replies)
Discussion started by: Pouchie1
3 Replies
7. Shell Programming and Scripting
hi Friends,
Please help me in writing shell script to run list of sql files.
database is Oracle 9i,
unix os is solaris
Requirement is
1. sql file must take two inputs a)feed id and b)business date
2.shell script must out put .xls or .csvfile as out put without trimming any column name and... (1 Reply)
Discussion started by: balireddy_77
1 Replies
8. Shell Programming and Scripting
I am currently trying to find a way to loop through files in a given directory and for each file modify a ctl file and sql load it. I have been using the sed command to change the infile, badfile parameters of the control file. I have not yet tried to sql load it.
Requirement: files are ftp to... (1 Reply)
Discussion started by: dba_nh
1 Replies
9. UNIX for Advanced & Expert Users
Hi,
What is command in unix to find what are all the files linked with an executable binary.
Thanks in advance.
Rgds,
Omkumar (2 Replies)
Discussion started by: tc.omkumar
2 Replies
10. UNIX for Advanced & Expert Users
How do I rdist a directory from one server to another, excluding soft and hard links?
current rdist syntax:
1 2 * * * cd /apps/oasis/prdsch/log; rdist -c j1*.log oasis@oastdby:/apps/schiller/oasis/prdsch/log
31 2 * * * cd /apps/oasis/prdsch/log; rdist -c oasis_bin_trans*.log... (6 Replies)
Discussion started by: captainzeb
6 Replies
cron(8) System Manager's Manual cron(8)
NAME
cron - The system clock daemon
SYNOPSIS
/usr/sbin/cron
DESCRIPTION
The cron daemon runs shell commands at specified dates and times. Commands that are to run according to a regular or periodic schedule are
found within the crontab files. Commands that are to run once only are found within the at files. You submit crontab and at file entries
by using the crontab and at commands. Because the cron process exits only when killed or when the system stops, only one cron daemon
should exist on the system at any given time. Normally, you start the cron daemon from within a run command file.
During process initialization and when cron detects a change, it examines the crontab and at files. This strategy reduces the overhead of
checking for new or changed files at regularly scheduled intervals. The cron command creates a log of its activities. The cron daemon
must be started from the system startup scripts because it must begin execution without a login user ID set. The cron daemon starts each
job with the following process attributes stored with the job by the invoking process: Login user ID Effective and real user IDs Effective
and real group IDs Supplementary groups
It also establishes the following attributes from the authentication profile of the account associated with the login user ID of the invok-
ing process: Audit control and disposition masks Kernel authorizations
DIAGNOSTICS
The at and batch programs will refuse to accept jobs submitted from processes whose login user ID is different from the real user ID.
FILES
Specifies the command path. Main cron directory Directory containing the crontab files. List of allowed users. List of denied users His-
tory information for cron Queue description file for at, batch, and cron
RELATED INFORMATION
Commands: at(1), crontab(1), rc0(8), rc2(8), rc3(8)
Files: queuedefs(4) delim off
cron(8)