Re: Running SQLs betweem RAC Instance

On Jan 3, 2:38 pm, ibodogan <idogan_t..._at_yahoo.com> wrote:
> On Jan 3, 1:23 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
>
> > On Jan 2, 3:44 pm, ibodogan <idogan_t..._at_yahoo.com> wrote:
>
> > > Is there a way to run a SQL in a RAC instance #1 from instance # 2 ?
>
> > > thanks,
> > > i.d.
>
> > Yes if you want to setup via a job/schedule ... you can control which
> > instance it is executed on.
>
> > Google around for something like "dbms_job run on instance RAC" or
> > similar.  I think orafaq.com has some examples as well as oaktable ...
>
> Thanks hpuxrac this was closest for what I asked but unfortunatelly I
> need to run this manually and as you see part of the code is running
> on instance # X while other part is running on another instance of
> RAC.
>
> i.d.

There are several ways to get parameters passed into things running under jobs/scheduler ... are you sure you can't get something workable by this mechanism rather than having to run it manually?

I didn't take a good look at your sample code ... can you explain what it is exactly you are trying to accomplish because perhaps there is a less complicated alternative available? Received on Thu Jan 03 2008 - 14:06:22 CST