control timeout of sqlplus process


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting control timeout of sqlplus process
# 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
# 2  
Old 08-27-2009
I would do this by strarting a background process that would monitoring to a some special file for amound of time you need - 20 sec. It would have a while loop with sleep 1 sec inside and check if file exist. If file found - just exit, to end this background monitoring. After loop need to have the a kill -9 of the sqlplus connection process (that could be some effort to get the process ID..)
The file-indicator should be created by the sqlplus connection script with system command, say, touch the file-indicator, after connection.

That the plan. Have no time to try it.
# 3  
Old 08-28-2009
Thanks for advice

I found two good articles with suitable solution

Cateee: shell: parallel execution with timeouts
comp.unix.shell | Google Groups
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