It might be that sqlplus makes the shell exit somehow so that the script is not run to the end. Put some output before and after the "sqlplus" call and find out if this is the case. Something like:
If the second "print" is not executed this would confirm my suspicion.
Also check which "sqlplus" you are executing and which type of file it is. It could be: a binary, an alias, a link, a shell function, ... Sometimes the "PATH" variable is corrupted and you don't execute what you believe you do. Use "which" to find out what you really execute and how.
Also start the script with full tracing on. Replace the shebang (you [i]do] use a shebang, no?) to (add "-xv"):
Unfortunately you are on your own, as nobody has your environment. Again: try to isolate the problem by testing one part of the script after the other to be OK. Eventually you will close in and finally find the culprit. Just have patience.
That's interesting. I have the exact same script and it does not work for me. I am on HP-UX 11.31. I don't see any tweaks in your script. Where did you make the changes?
Try this method which starts one instance of SQL/Plus as a co-process. Eliminates the overhead of starting/stopping sqlplus for each database. Of course there is no error handling here but if you do some searching in the forums here you will find other examples. ---------- Post updated at 11:46 AM ---------- Previous update was at 11:38 AM ----------
Quote:
Originally Posted by DBnixUser
That's interesting. I have the exact same script and it does not work for me. I am on HP-UX 11.31. I don't see any tweaks in your script. Where did you make the changes?
Curly braces around variable names.
Last edited by gary_w; 01-31-2013 at 12:52 PM..
Reason: added "--" arg to the print command so the dahsed line will print.
Be advised that that method causes sqlplus to be started/stopped for each server. For a 3-server list that is probably not a big deal, but if the list had many servers listed or was on a machine that was heavily used, the impact of the resources used and overhead caused by all of that starting and stopping could have a greater impact on performance. Hence the second example of using sqlplus in a co-process.
A technique to keep in the back of your mind I suppose, in case you need it someday.
So I'm stumped.
First... APOLOGIES... my work is offline in an office that has zero internet connectivity, as required by our client. If need be, I could print out my script attempts and retype them here. But on the off chance... here goes.
I have a text file (file_source) of terms, each line... (3 Replies)
Hi,
I have a several files with ".out" extension in a folder and each file has the below like contents
....
appname: wonder1
.....
logname78.log
logname88.log
.....
CAP: 2
.....
appname: wonder54
......
logname28.log
logname58.log
logname54.log
.....
CAP: 3
..... (4 Replies)
We're using a ksh script for installing one product.
I've another config file, I'd need to read this configuration file from my main script
Content of the Configuration file:... (2 Replies)
Hi Guys,
I need to read a file until I find a blank line. and in the next iteration I want to continue reading from the line I find a keyword.
For ex: my file looks like
PDS_JOB_ALIAS
CRITERIA_ITEM_TYPE
PDS_JOB_CRITERIA_ITEM
CRITERIA_ITEM_TYPE
First I want to read the file... (2 Replies)
Hi so far I created this script:
vi loop.beta.sh
for i in `cat extract.filenames.tabc`
do
echo $i
done>$i
===
This is the original text file.
$ more tabc.txt
-rwx------- 1 alice staff 1586 2010-11-05 02:27 request-key
.conf
-rwx------- 1 ted staff 126 ... (3 Replies)
Data
I was trying to write shell script which will be return the output in the below format
First i was trying to do these using sed.
sed -n '/.ksh/p' mainksh.ksh
sed -e 's/*\(.*\)/\1/g' mainksh.ksh
$RUN_DIR, $SUB_DIR and the variables which will be defined in the profile file.
when i am... (0 Replies)
I have 2 functions on AIX.
Func_A () {
....
....
}
Func_B () {
....
....
}
And I have a abc.txt file (multiple lines) and I would like to read line by line and pass line by line to Func_A & Func_B.
once Func_A is done,pass same value to Func_B and in the mean time get second line from... (5 Replies)
I have a file which has following contents:
localhost_IP_SIP_1233026552455.xml
localhost_IP_SIP_1233026552460.xml
localhost_IP_SIP_1233026552467.xml
localhost_IP_SIP_1233026552759.xml
localhost_IP_SIP_1233026552969.xml
localhost_IP_SIP_1233026552975.xml ... (2 Replies)
Hi,
I need to write a shell script (ksh) to read contents starting at a specific location from one file and append the contents at specific location in another file. Please find below the contents of the source file that I need to read the contents from,
File 1
-----# more... (5 Replies)