10-23-2007
Unable to open .sql file
Hi,
Thanks for your reply.
I am using the following script. GetJobDetails is a script in unix. It assigns the value for JobCommand, $JobDesc and JobType. Then i am passing this sqlplus -s @"$JobCommand" > "${LogString}" 2>"${ErrorString}" command in IF loop.
The partial script is
==================================================
GetJobDetails
case $JobType
in
SQL)
InsertLoadStatus $WorkDate "$JobDesc" $Step $Iteration 'START'
if ( PrereqsCheck ) then
print "$Step - $JobCommand > $LogString 2>$ErrorString"
if (time sqlplus -s @"$JobCommand" > "${LogString}" 2>"${ErrorString}" ) then
UpdateLoadStatus $WorkDate "$JobDesc" $Step $Iteration 'COMPLETE' 0
else
UpdateLoadStatus $WorkDate "$JobDesc" $Step $Iteration 'HALTED' 0
NotifyOperator 1 "$JobDesc" URGENT
fi
CompressInput
CompressOutput
fi
;;
esac
---------------------------------------------------
Thanks in Advance.
Regards,
Ananth P
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I am trying to build a tuxedo server which in turn depends on several Pro*C programs. I am doing it on HP-UX system.
It looks to me that the ORACLE_HOME is set properly.
But I am getting error message when trying to build.
PCC-F-NOERRFILE, unable to open error message file, facility PR2
exit... (1 Reply)
Discussion started by: asutoshch
1 Replies
2. UNIX for Dummies Questions & Answers
Hi ,
We are running Oracle 8.1.7 on HP-UX B.11.00. Recently we have upgraded Oracle from 8.0.6. to 8.1.7. Almost all the shell script we use has the Sqlplus as sqlplus -s @/apps/prod/sql/xxxx.sql > /apps/prod/log/xxxx.out .
However we receive the error
SP2-0310: unable to open file... (2 Replies)
Discussion started by: guru_2007
2 Replies
3. Solaris
am unable to open a .log file which is 4MB size. (18 Replies)
Discussion started by: venkatramana
18 Replies
4. AIX
Hi All,
Can't find any documentation on the web for this anywhere, except about three web pages that are in Chinese.
When I enter SMIT on this box, I get
ERROR MESSAGE: Unable to open temp file
I suspected smit.log, but it is universal readable, writeable by root, and I am root.... (6 Replies)
Discussion started by: jeffpas
6 Replies
5. UNIX for Advanced & Expert Users
I am working on a unix server.
I killed all the processes with my id on the machine.
After that I tried to delete a file, I got an error:-
file not removed.Text File busy.
Deletion of directory prompted:-
Directory not empty.
Can anyone help me regarding this...???
Thanks,
Vikas (11 Replies)
Discussion started by: vikasrout
11 Replies
6. Shell Programming and Scripting
Hi,
I was compiling few C programs in the unix server and getting the following error message
rm: /home/a0xxx28/AVT/SEEDLIBRARYDB/LIB/*.a non-existent
proc MODE=ANSI CODE=ANSI_C INCLUDE=/home/a0xxx28/PVT/SEEDLIBRARYDB/INCLUDE
INCLUDE=/home/a0xxx28/PVT/SEEDLIBRARY/INCLUDE ... (1 Reply)
Discussion started by: kavithakuttyk
1 Replies
7. Red Hat
Hi,
I am unable to create/open any file in vi editor for normal user, though using root I am able to create/open any file, using redhat 5.5,
example
vi test
it showing nothing after entering command (9 Replies)
Discussion started by: manoj.solaris
9 Replies
8. Shell Programming and Scripting
Not able to open a file using this code
why not?
use strict;
use warnings;
my $file = "verInfo.txt";
unless(open FILE, $file) {
# Die with error message
# if we can't open it.
die "\nUnable to open $file\n";
}
my $line = <FILE>;
print $line;
close FILE; (7 Replies)
Discussion started by: srijith
7 Replies
9. Shell Programming and Scripting
Hi All,
I am new to shell script. I am trying to pass value from .sh file to .sql file .
But I am able to run the .sql file from .sh file with values in sql file.
But I am unable to pass the values from .sh file. can some one please help to resolve this.
here is my .sh file
s1.sh
... (4 Replies)
Discussion started by: reddy298599
4 Replies
10. UNIX for Beginners Questions & Answers
Hi,
Getting the below error while installing from ks.cfg unable to open input kickstart file curl#37 Couldn't open file /tmp/swappart
Here am trying to include /tmp/swappart file from pre section under disks and partition section. Dont know where exactly am doing wrong
My kickstart file... (3 Replies)
Discussion started by: Sumanthsv
3 Replies
PCIC(4) BSD Kernel Interfaces Manual PCIC(4)
NAME
pcic -- PC Card bridge driver
SYNOPSIS
device pcic
device pccard
DESCRIPTION
The pcic driver provides support for older ISA and non-Yenta PCI PC Card bridges. The pcic driver supports most ExCA devices attached to the
ISA bus or PCI devices that do not conform to the Yenta specification.
The following ISA devices, or true clones, are supported in the current code.
Intel i82365SL Step A
Intel i82365SL Step B
Intel i82365SL Step C Intel's original 16-bit PC Card controller.
Intel i82365SL-DF Intel's last version of this device. 3.3V support was added.
VLSI 82C146 An older VLSI part with some issues on some machines.
Cirrus Logic PD-6710
Cirrus Logic PD-6720
Cirrus Logic PD-6722 Cirrus Logic's pcic controller. Compatible with the i82365SL Step C with the addition of a different 3.3V control.
Ricoh RF5C296
Ricoh RF5C396 Ricoh's PC Card bridge chips. These are compatible with the i82365SL Step C, but with yet another different 3.3V con-
trol.
Vadem 365
Vadem 465 Compatible with i82365SL Step C.
Vadem 468
Vadem 469 Like the earlier Vadem models, but with Vadem's own, incompatible, 3.3V control system.
IBM PCIC IBM clone of the original i82365SL part, with its own ID register value. Has no 3.3V ability.
Many other vendors made parts in this arena, but most of them were compatible with one of the above chipsets.
The following PCI pcmcia bridges are supported:
Cirrus Logic PD6729
Cirrus Logic PD6730
O2micro OZ6729
O2micro OZ6730
BUGS
This does not work at all at the moment.
BSD
July 9, 2002 BSD