Shell script is hanging up every time even after it's successful


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Shell script is hanging up every time even after it's successful
# 1  
Old 09-19-2019
Shell script is hanging up every time even after it's successful

We are using a korn shell script which is meant to trigger a Oracle job to load the data from a flat file to an Oracle database . Also the same script addresses the following tasks also like triggering a SFTP job to pick the file from one path to the target location and checking the same with control file to validate the control file and finally it triggers an email on success and failure of the jobs.

But everytime even after successful completion ,it's hanging up everytime and we need to exit the script forcefully by using ctrl c command though it has exit 0 at end of the script.

Last edited by senmng; 09-23-2019 at 12:43 AM..
# 2  
Old 09-19-2019
Hi
There are probably commands in the script running in the subshell. Try adding the wait command at the end
This User Gave Thanks to nezabudka For This Post:
# 3  
Old 09-19-2019
Set xtrace and verbose ON and run the script to understand at which stage it is waiting.

Code:
#!/bin/ksh -xv

# 4  
Old 09-19-2019
Just adding wait will work?

Code:
wait
exit 0

This User Gave Thanks to senmng For This Post:
# 5  
Old 09-20-2019
I think the wait only waits for its background commands (fired with &)
More promising is to run the script with ksh -x and watch what it does.
Another quick shot is to run it with < /dev/null
# 6  
Old 09-20-2019
Hi - Where can we give? the < /dev/null(exit suppresss exit status command) in my code ? also what's the difference between ksh -x and ksh -xv while debugging the code?
# 7  
Old 09-20-2019
ksh -v shows the original shell code as it gets processed.
ksh -x shows the code after all substitutions were done.
ksh -x -v or ksh -xv shows both.

</dev/null redirects the input. In case something in the script unwantedly reads from (and waits for) input, the /dev/null inputs nothing, and the script continues.
How do you run your script, what is the command that runs it? Just add a </dev/null
This User Gave Thanks to MadeInGermany For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script verify connection to Oracle if not successful

i have a script that connects to the oracle database and executes the query statements. it works fine and i would like to add some message to check if the connection to oracle is not successful. basically this is the code snippet: #!/bin/sh ... ... ... sqlplus -s username/password@dbName... (2 Replies)
Discussion started by: wtolentino
2 Replies

2. Shell Programming and Scripting

Capture run time of python script executed inside shell script

I have bash shell script which is internally calling python script.I would like to know how long python is taking to execute.I am not allowed to do changes in python script.Please note i need to know execution time of python script which is getting executed inside shell .I need to store execution... (2 Replies)
Discussion started by: Adfire
2 Replies

3. Shell Programming and Scripting

Shell script to convert epoch time to real time

Dear experts, I have an epoch time input file such as : - 1302451209564 1302483698948 1302485231072 1302490805383 1302519244700 1302492787481 1302505299145 1302506557022 1302532112140 1302501033105 1302511536485 1302512669550 I need the epoch time above to be converted into real... (4 Replies)
Discussion started by: aismann
4 Replies

4. Shell Programming and Scripting

Perl Script Hanging

Hey, Does anyone know why my Perl script is hanging when i execute it. print "looking around ...\n"; my ($out, $err, $exit) = $scon->cmd('ls'); print "done"; i get the following error: channel 1: open confirm rwindow 131043 rmax 32768 I'm using use Net::SSH::W32Perl Module.... (4 Replies)
Discussion started by: Phi01
4 Replies

5. Shell Programming and Scripting

script hanging???

ok... this is where i am at... i need a script to call another script as a wrapper because the first script creates a sub-shell. here is what i got... i kick off the first script "CCBDEMO-threadpoolworker.sh" #!/bin/bash clear #clearing screen directory="/data1/spl/cis/CCBDEMO/bin"... (1 Reply)
Discussion started by: Dagaswolf
1 Replies

6. Shell Programming and Scripting

Script is hanging

Hello, I have the following shell script and when i execute, it keeps hanging and nothing happens Please let me know. Requirement is to read data from file and pass it to the sql and create files as shown. code /******** #!/bin/sh while read user.dat do echo "user = $1 email =... (1 Reply)
Discussion started by: rakeshsr12
1 Replies

7. Linux

Script to simulate hanging process

I want to create a script to simulate a process that hangs to test a java application. My java app executes a system command, which can also be executing scripts, etc. Any ideas on such a script? The java code is: Runtime rt = Runtime.getRuntime(); Process p = rt.exec("sh... (4 Replies)
Discussion started by: brendan76
4 Replies

8. UNIX for Dummies Questions & Answers

Help with EXPECT script hanging

I am new at developing EXPECT scripts. I'm trying to create a script that will automatically connect to a UNIX server via FTP and download a log file from the server within a specified server directory on the remote machine. I'm having problems with the EXPECT script "hanging" at the password... (0 Replies)
Discussion started by: markus2008
0 Replies

9. Shell Programming and Scripting

script hanging - remsh

Greetings to everyone, My Problem: I have a script which inturn calls couple of other scripts in different servers (solaris) to do a server startups on the respecitve boxes. My script ... #!/usr/bin/ksh siebsrvr_root=/users/siebelserver/siebsrvr cd $siebsrvr_root . ./siebenv.sh... (2 Replies)
Discussion started by: vivsiv
2 Replies

10. UNIX for Dummies Questions & Answers

hanging sql script

Need your help pls... I have integrated my shell script with sqlplus statements that will fetch necessary data for the rest of the script. As observed, sometimes problems at the oracle database occurs wherein users can not login via sqlplus, so does the script. During execution, the logging of... (4 Replies)
Discussion started by: inquirer
4 Replies
Login or Register to Ask a Question