Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

control timeout of sqlplus process

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting control timeout of sqlplus process
Prev   Next
# 1  
Old 08-27-2009
control timeout of sqlplus process
Hi,

I'm using simple sqlplus to test DB availability.

When DB is going down, sqlplus command is hang for a few minutes

I want to implement the following:

1. execute sqlplus
2. if after 20 sec I dont get a response, kill the process and exit with error.
3. if I get immediate response (DB is up), go on without waiting 20 sec.

Thanks
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Control not returning from Sqlplus to calling UNIX shell script.

Hello All, I have exactly same issue @vikas_trl had in following link: https://www.unix.com/shell-programming-and-scripting/259854-control-not-returning-sqlplus-calling-unix-shell-script.html I wonder if he or somebody else could find the issue's cause or the solution. Any help would... (4 Replies)
Discussion started by: RicardoQ
4 Replies

2. Shell Programming and Scripting

Control not returning from Sqlplus to calling UNIX shell script.

Hello All, I have a UNIX script which will prepare anonymous oracle pl/sql block in a temporary file in run time and passes this file to sqlplus as given below. cat > $v_Input_File 2>>$v_Log << EOF BEGIN EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL DML PARALLEL 16'; EXECUTE... (1 Reply)
Discussion started by: vikas_trl
1 Replies

3. Red Hat

TNS Timeout Error when connecting to SQLPLUS through scripts only

Hi, I am facing a strange issue when connecting to SQLPLUS via a shell scripts. I am using Linux 2.6.18-274.18.1 and gbash shell. When I connect to SQLPLUS through scripts then it throws TNS Time Out error ""sometimes"" and connects successfully other times.This is only happening when... (9 Replies)
Discussion started by: aashish.sharma8
9 Replies

4. Shell Programming and Scripting

kill process if timeout Python

I have a python script that calls a binary. I want to make sure that if the binary fails (with a 2 min timeout) it kills the process. Currently I'm unable to do that as I only kill the function but the binary is still running. Please help #!/usr/bin/python26 from optparse import OptionParser... (0 Replies)
Discussion started by: erick_tuk
0 Replies

5. UNIX for Dummies Questions & Answers

Find out excat timing of ftp control session timeout

We are facing difficulties in ftp'ing large files.For large file transfer using FTP, the control session gets timed out where as the the data session is active and transfers the file completely. Is there a way to make the control session active as long as data session? How to find the control... (1 Reply)
Discussion started by: rocker
1 Replies

6. Shell Programming and Scripting

job/process scheduling or control

Hi forum, I have a problem concerning job or process scheduling and control. I have to run 24 jobs (could be more sometimes less) of the same programme with different parameters. The machine this code is running on is an 8-core machine, so I was thinking that running all the processes at once... (0 Replies)
Discussion started by: deiphon
0 Replies

7. UNIX for Dummies Questions & Answers

init and process control

I'm trying to wrap my head around process control in Unix... particularly init and how it fits in to the equation. Init is responsible for creating sessions by spawning instances of getty which calls login effectively creating sessions right? Why then can init belong to a session? If you ps jx... (4 Replies)
Discussion started by: dexfantasy
4 Replies

8. UNIX for Advanced & Expert Users

control the process

I found that in my system , there are some strange process , it will make the system crash so I would like to control the system no such process is running , this is if the system process that its process name is "ora" AND its ppid is not "2" , then it will crash the system, can suggest how to... (2 Replies)
Discussion started by: ust
2 Replies

9. UNIX for Advanced & Expert Users

timeout opening writing control channel /dev/initctl problem occur i cant shoudown

Hi... This is message that occurs when i am trying to shutdown the linux system timeout opening writing control channel /dev/initctl how can i shutdown what is the problem here.. Thanks in advance ... (2 Replies)
Discussion started by: arunkumar_mca
2 Replies

10. Filesystems, Disks and Memory

unix process control

can anyone send me enything about "unix process control " nicko@freemail.com.mk (2 Replies)
Discussion started by: nicko
2 Replies
Login or Register to Ask a Question

LEARN ABOUT LINUX

flock

FLOCK(1)							  H. Peter Anvin							  FLOCK(1)

NAME

       flock - Manage locks from shell scripts

SYNOPSIS

       flock [-sxon] [-w timeout] lockfile [-c] command...

       flock [-sxon] [-w timeout] lockdir [-c] command...

       flock [-sxun] [-w timeout] fd

DESCRIPTION

       This utility manages flock(2) locks from within shell scripts or the command line.

       The  first and second forms wraps the lock around the executing a command, in a manner similar to su(1) or newgrp(1).  It locks a specified
       file or directory, which is created (assuming appropriate permissions), if it does not already exist.

       The third form is convenient inside shell scripts, and is usually used the following manner:

       (
	 flock -n 9
	 # ... commands executed under lock ...
       ) 9>/var/lock/mylockfile

       The mode used to open the file doesn't matter to flock; using > or >> allows the lockfile to be created if it does not already exist,  how-
       ever, write permission is required; using < requires that the file already exists but only read permission is required.

       By default, if the lock cannot be immediately acquired, flock waits until the lock is available.

OPTIONS

       -s, --shared
	      Obtain a shared lock, sometimes called a read lock.

       -x, -e, --exclusive
	      Obtain an exclusive lock, sometimes called a write lock.	This is the default.

       -u, --unlock
	      Drop  a  lock.   This  is  usually  not required, since a lock is automatically dropped when the file is closed.	However, it may be
	      required in special cases, for example if the enclosed command group may have forked a background process which should not be  hold-
	      ing the lock.

       -n, --nb, --nonblock
	      Fail (with an exit code of 1) rather than wait if the lock cannot be immediately acquired.

       -w, --wait, --timeout seconds
	      Fail (with an exit code of 1) if the lock cannot be acquired within seconds seconds.  Decimal fractional values are allowed.

       -o, --close
	      Close  the  file	descriptor  on	which the lock is held before executing command.  This is useful if command spawns a child process
	      which should not be holding the lock.

       -c, --command command
	      Pass a single command to the shell with -c.

       -h, --help
	      Print a help message.

AUTHOR

       Written by H. Peter Anvin <hpa@zytor.com>.

COPYRIGHT

       Copyright (C) 2003-2006 H. Peter Anvin.
       This is free software; see the source for copying conditions.  There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU-
       LAR PURPOSE.

SEE ALSO

       flock(2)

AVAILABILITY

       The flock command is part of the util-linux package and is available from ftp://ftp.kernel.org/pub/linux/utils/util-linux/.

flock utility							    4 Feb 2006								  FLOCK(1)