[Orca-users] Re: Oracle Database

[Phillip B. Bruce]

Blair Zajac wrote:

> Of the possible solutions to get data from the clients to the main
> orca server:
>
>       1) Use NFS
>       2) Use rsync
>       3) Have orcallator.se/Orca use their own private protocol
>       4) Have orcallator.se execute a command after compressing the
> percol-*
>          files, such as scp or something.  If cp cannot be used
> because
>          NFS is not installed, then this could also be a security
> concern
>          if scp keys need to be installed.
>
> Number 3) is probably the hardest, especially if security is an issue,
> and
> it'll be hard to get it right.  I'd rather use standard tools that
> most
> people understand.
>
> 1) and 2) are probably around the same amount of work, but 1) may
> already be
> set up for many sites.
>
> Patches for 4) are welcome.
>
> A separate notes document Orcale's script would be helpful.
>
> Blair
>
> "Phillip B. Bruce" wrote:
> >
> > Blair Zajac wrote:
> >
> > > Phillip,
> > >
> > > The hiding of email address is not for you, its for any spam
> gathering
> > >
> > > programs out there that may find this email archived on a public
> web
> > > site.
> > >
> > > In any case, it's my private mail archive where I found it.  I
> checked
> > > and
> > > there's no public archive of this thread.
> > >
> > > I tried commenting out the Sprite module and the module compiled.
> > > There
> > > are two CPAN modules that have the name Sprite, one of them that
> may
> > > be
> > > useful since its a DBD:  DBD::Sprite.
> > >
> > > I was going to clean the code up also, but not do a major
> rewrite.  It
> > >
> > > definitely could be integrated into Orca's build and install
> process
> > > to
> > > properly set the Perl program to use and other details.
> > >
> > > Let me know if you decide to take a hack at it, I may already have
>
> > > hacked
> > > up my copy by then.
> > >
> > > Blair
> > >
> > > > Blair,
> > > >
> > > >   Thanks. You can use real email addresses. I'm not that lame.
> > > >
> > > >    I'll keep the group posted. Let me know if that is correct
> email
> > > > address as I will
> > > >    try and if I fail. Can you let me know what  Archive Mail Box
> you
> > >
> > > > found that at?
> > > >
> > > >    This may be very, very old and the author may have just gone
> > > home.
> > > >
> > > >     I can tell you right now that you'll need at least 2 perl
> > > modules
> > > > one of which
> > > >     is DBI ( Database Interconnect) Module. I used that one
> quite a
> > > bit
> > > > while doing
> > > >     some ldap connectors for a customer of mine.
> > > >
> > > >     The other is one I haven't seen before Sprite. I'll have to
> do
> > > some
> > > > more searching cause
> > > >      This module Sprinte::General is required in the code so.
> The
> > > one I
> > > > downloaded tonight
> > > >     does have that aspect of the perl module.
> > > >
> > > >      If he can't located, I'll take a whack at it. But I'm not
> going
> > > to
> > > > waste my breath. The code
> > > >      isn't that bad but not that great either. Lack of Style
> just a
> > > > little. I want it to work first before
> > > >      I attack that problem.
> > > >
> > >
> Service.
> >
> > Blair,
> >
> >   Thanks, That made sense about the email.
> >
> >   I'll try something this weekend and see if I have any luck. I'm
> > currently running Oracle 8.1.6 on x86 platform
> >   but do have a sparc at work (Bad Power Supply). When that is fix,
> I'll
> > try your current code with Oracle
> >    running on that.
> >
> >    The code also seems to assume that you have the main ORACLE
> > environment variables set so make sure that
> >    works ok too.
> >
> >     Just a note:  Even though NFS is one of the ways to get multiple
>
> > host info updated. I think you need to look at
> >     setting up a server/client transport that is mangaed a lot
> better
> > than having users setup NFS. That is a lot of
> >     overhead to deal with on the network.
>
>                    Yahoo! Groups Sponsor
                            [Image]

>

Blair,

    Their is one more alternative that you guys need to try.

    Look at this site:   http://curl.haxx.se/

    This is a technique that Content Management Software such as
Vignette and Blue Martini
    uses. I think this will be more effective than the others that  you
have listed.


--
************************************************************
*** Phillip B. Bruce                                     ***
*** http://pbbruce.home.mindspring.com                   ***
*** pbbruce at mindspring.com                               ***
***                                                      ***
*** "Have you ever noticed? Anybody going slower than    ***
*** you is an idiot, and anyone going faster than you    ***
*** is a maniac." - George Carlin                        ***
************************************************************