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 DEBIAN
check-setuid
CHECKSECURITY(8) System Manager's Manual CHECKSECURITY(8)
NAME
checksecurity - check for changes to setuid programs
SYNOPSIS
checksecurity
DESCRIPTION
The checksecurity command scans the mounted files systems (subject to the filter defined in /etc/checksecurity.conf) and compares the list
of setuid programs to the list created on the previous run. Any changes are printed to standard output. Also, it generates a list of nfs
and afs filesystems that are mounted insecurely (i.e. they are missing the nodev and either the noexec or nosuid flags).
checksecurity is run by cron on a daily basis, and the output stored in /var/log/setuid/setuid.changes.
CONFIGURATION
The checksecurity.conf file defines several configuration variables: CHECKSECURITY_FILTER, CHECKSECURITY_NOFINDERRORS, CHECKSECURITY_NONF-
SAFS, CHECKSECURITY_EMAIL, CHECKSECURITY_DEVICEFILTER, CHECKSECURITY_PATHFILTER, and LOGDIR. Each is described below.
The CHECKSECURITY_FILTER environment variable which is the argument of 'grep -vE' applied to the output of the mount command. In other
words, the value of CHECKSECURITY_FILTER is a regular expression that removes matching lines from those file systems that will be scanned.
The default value removes all file systems of type proc, bind, msdos, iso9660, ncpfs, nfs, afs, smbfs, auto, ntfs, coda file systems, any-
thing mounted on /dev/fd*, anything mounted on /mnt or /amd, and anything mounted with option nosuid or noexec.
The checksecurity.conf file is sourced from checksecurity, so you could do some fairly tricky things to define CHECKSECURITY_FILTER.
The CHECKSECURITY_NOFINDERRORS environment variable, if set to the literal "TRUE", disables find errors from checksecurity (actually, it
re-routes them to /dev/null ).
The CHECKSECURITY_NONFSAFS environment variable, if set to the literal "TRUE", disables the message about nfs and afs file systems that are
mounted without the nodev and either the noexec or nosuid options.
If set, the CHECKSECURITY_EMAIL variable defines who is sent a copy of the setuid.changes file.
The CHECKSECURITY_DEVICEFILTER variable specifies a find clause for which matching block and character device files will not be monitored
for changing owners and permissions. For example, if you don't want to check for permission changes on tty device files beneath /dev, you
could set the following:
CHECKSECURITY_DEVICEFILTER='-path /dev/tty*'
Note that any added or modified suid programs under that path would still be detected. If you want to specify multiple expressions, sepa-
rate them with '-o', but there is no need to surround the whole clause with parentheses. To disable this filter, specify it as '-false'
(which is the default).
Note that if the system gets restarted often checksecurity will report a lot of changes in the /dev/ subdirectory due to timestamp changes.
In this case you might want to change it to:
CHECKSECURITY_DEVICEFILTER='-path /dev/'
The CHECKSECURITY_PATHFILTER variable specifies a find clause which will be pruned from the search path. This means that the entire sub-
tree will be completely skipped. Thus, specifying
CHECKSECURITY_PATHFILTER='-path /var/ftp'
then the entire /var/ftp tree will be skipped. To disable this filter, specify it as '-false' (which is the default).
LOGDIR sets the name of the directory which stores the files which track the permission and ownership changes. By default, they are in
/var/log/setuid.
FILES
/etc/checksecurity.conf
checksecurity configuration file
/var/log/setuid/setuid.today
setuid files from the most recent run
/var/log/setuid/setuid.yesterday
setuid files from the previous run
Debian Linux 2 February 1997 CHECKSECURITY(8)