The reqftp.sql will show the latest request – and you just need copy/paste the @reqft2 <request id> to download log and out files.
NB: You need to edit the reqftp2.sql with your enviroment data:
hostname:
def hostname = <hostname or ip address of the applications server>
ftp connect info:
-- edit for your environments select decode(name, 'DEV','user appdev xxxxxx', 'MASTER','user appmstr xxxxxx', 'TRAIN','user apptrain xxxxxx', '') from v$database;
Excample:
DEV> @reqftp ----------------------------------------------------- copyright thomaslundqvist.dk 2009 requestor....: XXTLQ
req id exe NAME EXE --------- -------- ------------------------------------------------------------ --------------------
12525526 1 Receiving Transaction Processor : IMMEDIATE, 303853 @reqftp2 12525526 12525531 2 Receiving Transaction Processor : IMMEDIATE, 303854 @reqftp2 12525531 12525539 1 Receiving Transaction Processor : IMMEDIATE, 303855 @reqftp2 12525539 12525558 2 Receiving Transaction Processor : IMMEDIATE, 303856 @reqftp2 12525558 12525561 1 Receiving Transaction Processor : IMMEDIATE, 303857 @reqftp2 12525561 DEV> @reqftp2 12525539 DEV> @reqftp2 12525558 DEV> @reqftp2 12525561
It is included in the sql4oracle.zip file