Oracle, Rexx, and NT commands

From: Ed Stevens <74730.2006_at_compuserve.com>
Date: 1998/03/27
Message-ID: <OHYmpDoW9GA.363_at_nih2naaa.prod2.compuserve.com>#1/1


I am writing a program (using IBM's ObjectRexx) to do housekeeping on the listener log. To make a long story short, I need to stop the listener, rename the log file, then restart the listener. In Rexx it looks like this:

/* Rexx 'address cmd' passes a string to the os cmd processor */
address cmd 'lsnrctl stop listener_name > lsnrstop.log' /* stop the listener and trap msgs*/
address cmd os_cmd 'ren listener.log listener.sav' /* rename the now closed listener log */
address cmd 'lsnrctl stop listener_name > lsnrstop.log' /* start the listener and trap msgs*/
/* end Rexx code sample */

Performing the commands from the os prompt works correctly. When performed from within the pgm, shutdown and startup of the listener failes, and the listener has to be stopped and restarted using the NT Services applet.

Other commands passed from Rexx to the OS (such as "ren") work fine, which would indicate that there is no problem with the mechanism of Rexx passing commands. Since I can do the same commands manually at the os prompt, it would indicate that there is no problem with the listener. And yet . . .

It would be easy for the Oracle people to say "It's a Rexx problem" and for the Rexx people to say "It's an Oracle problem" so I'm asking both sides in hopes that someone will have some insight to help me solve this.

Please reply via e-mail to the address below, which is my office address. I can't access USENET from there, so am forwarding this thru my personal account.

  • Ed Stevens E-mail: Ed.Stevens_at_NMM.Nissan-USA.com
Received on Fri Mar 27 1998 - 00:00:00 CET

Original text of this message