RE: Unix Question

Mladen, what you said has a strong basis in truth, but sometimes these other tools are not available or allowed to be used due to requirements that all code be done in a specific tool set. I tried to provide a solution that would work with the tools at hand.

I would think most job scheduler applications such as CA-Unicenter would handle this as part of their nature, but apparently Ryan does not have the benefit of such a tool. It is good to know that Java, Perl, and Python provide IPC facilities. One of these days perhaps I will learn a scripting language.

• Mark D Powell --

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mladen Gogala Sent: Wednesday, May 26, 2004 9:55 AM
To: oracle-l_at_freelists.org
Subject: Re: Unix Question

Actually, I think that shell is not the right tool to do so. Any programming language (including the scripting ones like Java, Perl or Python) has facilities
to run jobs in background and communicate either by using SYSV IPC, pipes or some fancy queueing software like MQ-Series, Rendesvouz or Oracle AQ. The problem that Ryan has comes from trying to solve it with the wrong tool, like forcing the proverbial square peg through the round hole. Not everything
can be solved by hammer, duct tape and WD-40. Shell is the right tool for interactive stuff and has only rudimentary programming
abilities. It's not meant to be a "fix it all" programming solution. Multithreading
with threads communicating with each other is something that should be done by
specialized scripting languages.

On 05/26/2004 09:31:54 AM, "Powell, Mark D" wrote:
> Here is an idea. Add a write to a dbms_pipe to each script that sends the
> task return code to the pipe reader. Now add one more script that opens
the
> pipe for read and goes into a loop: read, sleep until all tasks have
> registered. When all tasks have registered thier ending status then this
> monitoring task exists success otherwise it fires off an error message and
> exists failure.

-- 
Mladen Gogala
Oracle DBA



Note:
This message is for the named person's use only.  It may contain
confidential, proprietary or legally privileged information.  No
confidentiality or privilege is waived or lost by any mistransmission.  If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender.  You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. Wang Trading LLC and any of its subsidiaries each reserve the
right to monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be the views of any such entity.

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------