RE: Run command on sqlplus repetitively without reconnection

So do I!
 
    I did change 
sqlplus -s /nolog |& # Open a pipe to SQL*Plus
 
    and
    print -p -- '/'
to
    print -p -- "@$1"
 
    as now I can have a $1 sql that 
 
can be changed like:
--@$DBS/uptime
--@$DBS/VS
@$DBS/VRL
 
    so if we need to run a different script we can.
 
If say, you get 
00020, 00000, "maximum number of processes (%s) exceeded"
 
    Thanks, Philip, Jared, et. al.
 
    Larry

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Wednesday, May 23, 2007 1:23 PM
To: philipsd@xxxxxxxxx
Cc: oradbt054@xxxxxxxxx; cichomitiko@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Run command on sqlplus repetitively without reconnection


On 5/22/07, Philip Douglass <philipsd@xxxxxxxxx> wrote: 

        Here's what I've been using for awhile now to accomplish the
repetitive monitoring script in SQL*Plus pattern:
        
        #!/bin/ksh
        
        sqlplus -s / |& # Open a pipe to SQL*Plus
        
        cat <& p &
        
        print -p -- "exec
dbms_application_info.set_client_info(client_info =>
'${USER}@${HOSTNAME}');"
        print -p -- "exec dbms_application_info.set_module(module_name
=> '$(basename $0)', action_name => '$1');" 
        
        print -p -- "@$1"
        
        while (true); do
                sleep $2
                print -p -- '/'
        done
        
        


Thanks, this is clever.
Just now I have a use for it. :)

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

*************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.

If the reader of this message is not the intended recipient, you are 
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank you.
*************************************************************************

Other related posts: