Hello
#!bin/ksh
sqlplus -s system/manager < |grep '^ORA' |uniq
select * from kk;
set echo on
show spool on
end;
/
EOF
save test.sh
sh test.sh
results
ORA-00942: table or view does not exist (3 Replies)
Hi,
I am working on Solaris 8 and the "intro" man page says, "Upon termination, each command returns two bytes of status, one supplied by the system and given the cause for termination, and (in the case of 'normal' termination) one supplied by the program. The former byte is 0 for normal... (2 Replies)
I'm receiving an exit code 64 in our batch scheduler (BMC product control-m) executing a PERL script on UX-HP. Can you tell me where I can find a list of exit codes and their meaning. I'm assuming the exit code is from the Unix operating system not PERL. (3 Replies)
Hi,
Recently I install a package and try to do a make and make install.
However, in the make it gives me below error:-
make:Nothing to be done for 'install-exec-am'
make:Nothing to be done for 'install-data-am'
Can anyone please explain to me what does this mean? I have been trying... (1 Reply)
This single line of code in a sh script file
top -b -n 1 -U $USER
causes the script to prematurely exit with an exit code of 1 (i.e. an error) if the script is run with the -e option (e.g. if
set -e
is executed near the top of the script file).
Alternatively, you can execute it like
top... (8 Replies)
I attached a README file that I will refer to.
I successfully completed everything in the README file until step 4.
# pwd
/gani/gani-2.4.4
# ls
COPYING Makefile.macros gem.c
Makefile Makefile.sparc_gcc gem.h
Makefile.amd64_gcc ... (1 Reply)
I need help in the following script. I want to grep the sql errors insert into the error table and exit the shell script if there is any error, otherwise keep running the scripts.
Here is my script
#!/bin/csh -f
source .orapass
set user = $USER
set pass = $PASS
cd /opt/data/scripts
echo... (2 Replies)
Hi,
I am writing a menu driven program using shell script. THe script will be collecting data by logging into the other servers and bringing back the data to home server to process it and accordingly issue commands. TO automate commands execution , I am using expect script. However I am not able... (5 Replies)
Hi Guys,
I am calling a SQL script which runs under while loop, i need to exit the while loop if i get error in sql script which is called
while
do
sqlplus -s user/pass@db @test.sql id$i
done
test.sql
whenever sqlerror exit;
alter table t1 add &1 number;
I need to come out of... (2 Replies)
Hi All,
Good Day, seeking for your assistance on how to not perform my 2nd, 3rd,4th etc.. function if my 1st function is in else condition.
#Body
function1()
{
if
then
echo "exist"
else
echo "not exist"
}
#if not exist in function1 my all other function will not proceed.... (4 Replies)
Discussion started by: meister29
4 Replies
LEARN ABOUT OPENSOLARIS
halockrun
halockrun(1M) System Administration Commands halockrun(1M)NAME
halockrun - run a child program while holding a file lock
SYNOPSIS
/usr/cluster/bin/halockrun [-nsv] [-e exitcode] lockfilename
prog [args]
DESCRIPTION
The halockrun utility provides a convenient means to claim a file lock on a file and run a program while holding that lock. As this utility
supports script locking, this utility is useful when programming in scripting languages such as the Bourne shell. See sh(1).
halockrun opens the file lockfilename and claims an exclusive mode file lock on the entire file. See fcntl(2)fcntl(2)). Then it runs the
program prog with arguments args as a child process and waits for the child process to exit. When the child exits, halockrun releases the
lock, and exits with the same exit code with which the child exited.
The overall effect is that the child prog is run as a critical section, and that this critical section is well-formed, in that no matter
how the child terminates, the lock is released.
If the file lockfilename cannot be opened or created, then halockrun prints an error message on stderr and exits with exit code 99.
You can run this command in the global zone or in a non-global zone. The command affects only the global or non-global zone in which you
issue the command.
OPTIONS
The following options are supported:
-e exitcode Normally, errors detected by halockrun exit with exit code 99. The -e option provides a means to change this
special exit code to a different value.
-n The lock should be requested in non-blocking mode: if the lock cannot be granted immediately, halockrun exits
immediately, with exit code 1, without running prog. This behavior is not affected by the -e option.
Without the -n option, the lock is requested in blocking mode, thus, the halockrun utility blocks waiting for
the lock to become available.
-s Claim the file lock in shared mode, rather than in exclusive mode.
-v Verbose output, on stderr.
EXIT STATUS
Errors detected by halockrun itself, such that the child process was never started, cause halockrun to exit with exit code 99. (This exit
code value can be changed to a different value using the -e option. See OPTIONS.
Otherwise, halockrun exits with the same exit code with which the child exited.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWscu |
+-----------------------------+-----------------------------+
|Interface Stability |Evolving |
+-----------------------------+-----------------------------+
SEE ALSO fcntl(2), attributes(5)Sun Cluster 3.2 10 Apr 2006 halockrun(1M)