03-16-2005
Thanks
Hi tmarikle,
Thanks a lot for your input. Now i am using dat file instead of piping. The maximum available buffer size for piping causes the issue and now i write to a file and then give that file as input to the sqlldr. Please find below the code.
Before:
$rc = 0xfff & system ("echo \"$if_admin\"|$ORACLE_HOME/bin/sqlldr userid=$USER/$PASSWD control=cfg/IF_ADMIN.ctl bad=/dev/null discard=/dev/null log=$LOGDIR/$interface.int.log > /dev/null");
After:
$rc = 0xfff & system("$ORACLE_HOME/bin/sqlldr userid=$USER/$PASSWD data=$LOGDIR/myAdmin.log control=cfg/IF_ADMIN.ctl bad=/dev/null discard=/dev/null log=$LOGDIR/$interface.int.log > /dev/null");
I use myAdmin.log as the input file to sqlldr.
Thanks,
Jai
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
When I try to format a slice in Solaris 10 I get the follow error :confused: :
-bash-3.00# mkfs /dev/dsk/c1d0s5 18877824
Can not determine partition size: Inappropriate ioctl for device
Some format command output:....
AVAILABLE DISK SELECTIONS:
0. c1d0 <DEFAULT cyl 38735 alt 2... (0 Replies)
Discussion started by: spoonman
0 Replies
2. UNIX for Dummies Questions & Answers
Hello,
I have a cron entry:
59 23 * * * . $HOME/.profile;mydate=`date '+%Y%m%d'`;mv filename filename_$mydate
Which works fine interactively, but gives me the following error when it runs in cron:
Your "cron" job on servername
. $HOME/.profile;mydate=`date '+
produced the... (4 Replies)
Discussion started by: steelrose
4 Replies
3. Solaris
When I try to format a slice in Solaris 10 I get the follow error :
-bash-3.00# mkfs /dev/dsk/c1d0s5 18877824
Can not determine partition size: Inappropriate ioctl for device
Some format command output:....
AVAILABLE DISK SELECTIONS:
0. c1d0 <DEFAULT cyl 38735 alt 2 hd 64 sec 63>... (2 Replies)
Discussion started by: spoonman
2 Replies
4. Shell Programming and Scripting
Dear all,
Problem goes like this:
I have a shell script which when run manually runs perfectly.
When same script is executed through a job schdeduler I get an error as Inappropriate ioctl for device and the script fails.
This problems seems quite guiling to me.
Any clues are heartly... (11 Replies)
Discussion started by: RishiPahuja
11 Replies
5. UNIX for Dummies Questions & Answers
Hello guys,
on my Red Hat machine the /bin/mt status command gives the output dev/tape: inappropriate ioctl for device. This messages comes up after the Server has been rebooted.
Anybody an idea?
Thx
masterofdesaster (8 Replies)
Discussion started by: masterofdesaste
8 Replies
6. Shell Programming and Scripting
Hi All,
Am finding performance of my SD card using hdparm.
Code:
hdparm -tT /dev/BlockDev0
/dev/BlockDev0:
Timing cached reads: 1118 MB in 2.00 seconds = 558.61 MB/sec
HDIO_DRIVE_CMD(null) (wait for flush complete) failed: Inappropriate
ioctl for device
Timing buffered disk... (1 Reply)
Discussion started by: amio
1 Replies
7. Shell Programming and Scripting
Hello everyone
I am finishing a script allowing me to purge logs on multiple servers, i have one last pb with the ssh command.........it is throwing me the following error :
tcgetattr: Inappropriate ioctl for device (full screen in attached file 1, full script in attached file 2)
It... (15 Replies)
Discussion started by: jimmy75_13
15 Replies
8. UNIX for Advanced & Expert Users
Hi!
I am getting a nohup issue on mac osx while trying to start a process through nohup in the startup script.
nohup: can't detach from console: Inappropriate ioctl for device
Please help!
Thanks,
Allan. (0 Replies)
Discussion started by: jacki
0 Replies
9. UNIX for Dummies Questions & Answers
Hi,
ssh -q -t -l $usr $host bin/test.sh
I am using above command to run script remotely. script is working without any issues. but I am getting "tcgetattr: Inappropriate ioctl for device" message on console.
plz help how can I avoid this message.
Thanks
Moved thread from Emergency... (1 Reply)
Discussion started by: Kri
1 Replies
10. Shell Programming and Scripting
Sample program tty, this will be get called from my script test_script.
#include <stdio.h>
#include <unistd.h>
#define TTY_NAME_MAX 32
#define STDIN_FILENO 0 /* Standard input. */
int main(void) {
int ret = 0;
char local_device_file;
printf("\npid =... (7 Replies)
Discussion started by: Gajendra_PH
7 Replies
LEARN ABOUT SUSE
tally.control
TALLY.CONTROL(8) InterNetNews Documentation TALLY.CONTROL(8)
NAME
tally.control - Keep track of newsgroup creations and deletions
SYNOPSIS
tally.control < logfile
DESCRIPTION
tally.control is normally daily invoked by scanlogs. It reads its standard input, which should be the newgroup.log and rmgroup.log control
log files. They contain a summary line describing the control message and the action taken by controlchan, followed by the article
indented by four spaces, and a blank line. Then, tally.control updates the cumulative list of newsgroup creations and deletions which is
kept in control.log.
All these log files reside in the pathlog directory set in inn.conf. In order to generate them, you need to enable control articles
logging in control.ctl(5), as explained in the control.log entry of newslog(5).
FILES
pathbin/tally.control
The Shell script itself used to tally newsgroup creations and deletions up.
pathlog/control.log
This file maintains a count of the number of newgroup and rmgroup control messages seen for each newsgroup. The count is of the number
of control messages with the indicated arguments, regardless if they were actually processed. All control arguments, including invalid
ones, are counted. An example of lines which can be found in that log file is:
3 Control: newgroup foo.bar moderated
3 Control: rmgroup misc.removed
1 Control: newgroup misc.created
HISTORY
Written by Landon Curt Noll <chongo@toad.com> and Rich $alz <rsalz@uunet.uu.net> for InterNetNews. Rewritten and converted to POD by
Julien Elie.
$Id: tally.control.pod 8357 2009-02-27 17:56:00Z iulius $
SEE ALSO
control.ctl(5), news.daily(8), newslog(5), scanlogs(8).
INN 2.5.2 2009-05-21 TALLY.CONTROL(8)