lsnrctl cause mail to wait.

I have a problem:

On Sun computer (OS 5.6) with Oracle 7.3.4.

I have a crontab command that starts a listener. When I redirect the output to a file:
58 16 * * * /u01/app/oracle/autosys/script/START_ORACLE hrdemo 1>/tmp/foo 2>&1
everything is fine.

This START_ORACLE essentially contains: “lsnrctl start $1”.

If I redirect the output to mail:
58 16 * * * /u01/app/oracle/autosys/script/START_ORACLE hrdemo 2>&1 | /usr/bin/mailx -s "START_ORACLE" Pierre-Andre_Morin_at_japan.ml.com the mail process is hanging there and not moving.

Further research shows that “Lsnrctl” create a new process (like below):

oracle 4475 1 0 17:03:45 ? 0:00 /u01/app/oracle/product/7.3.4/bin/tnslsnr hrdemo -inherit which has “1” as a parent id. This is the actual listener “listening”.

If you kill that process 4475 then mail is released but then you have no listener… not good!
If you stop the listener, the mail process also gets release… More elegant (no killing) but still not good. Of course if the listener is already started, everything goes fine and the mail gets through.

My interpretation: It seems that the mail is waiting for every process that was created by the script “START_ORACLE” to be finished. On the other hand, Oracle has changed the parent id to “1” but mail is not aware of it.

Thanks for your attention Received on Thu Mar 04 1999 - 03:43:19 CST