Re: access Oracle from Perl

Mladen,

This is direct SGA attach. Works for me from root or from oracle owner. I haven't tested any thing else yet.

Anjo.

Mladen Gogala wrote:
>
> Anjo, from what I can see, you're not connecting to an instance using Oracle*Net
> as in the DBI/DBD world, you're "attaching" to it. That makes me think that you're
> using OCI to connect as SYSDBA, which means that you have written a new module
> which has to be integrated in perl. As perl executables are normally owned by root and
> their protection mode usually doesn't include setgid bit, they cannot connect to an
> instance, unless the invoker is not a member of a DBA group. That means that you're
> writing a package specifically targeting us DBAs. Goody, goody, me likes that!
>
> On 2003.05.26 17:56 Anjo Kolk wrote:
> >
> > I will show how to do this at the Miracle DBForum. After that, a simple
> > version will be available for download from oraperf.com.
> >
> > Anjo.
> >
> >
> > Mladen Gogala wrote:
> > >
> > > When and where will I be able to get oraperf.pm? I somehow suspect
> > > that it is being developed at www.oraperf.com?
> > >
> > > On 2003.05.26 15:11 Anjo Kolk wrote:
> > > > The following also works ;-)
> > > >
> > > > use oraperf;
> > > >
> > > > $c = oraperf::new_oraperf();
> > > >
> > > > $ret = oraperf::oraperf_Attach9($c, "/opt/oracle/Ora9.2.0", "ora920");
> > > >
> > > > print "ret = $ret\n";
> > > >
> > > > print "Sessions = ", oraperf::oraperf_GetNumSes($c), "\n";
> > > > print "Processes = ", oraperf::oraperf_GetNumProc($c), "\n";
> > > > printf(" version = %x\n", oraperf::oraperf_Version($c));
> > > >
> > > > $numses = oraperf::oraperf_GetNumSes($c);
> > > >
> > > > but you can't download it yet,
> > > >
> > > > Anjo.
> > > >
> > > >
> > > > Mladen Gogala wrote:
> > > > >
> > > > > I know that I'm using Linux (RH 8.0) and I don't have any problems
> > > > > with 5.8 or DBD/DBI. Here is what I have:
> > > > > $ ./drivers.pl
> > > > > Driver: ExampleP
> > > > > Data Source: dbi:ExampleP:dir=.
> > > > >
> > > > > Driver: Oracle
> > > > > Data Source: dbi:Oracle:ADM.ADELPHIA.NET
> > > > > Data Source: dbi:Oracle:LOCAL.ADELPHIA.NET
> > > > >
> > > > > Driver: Proxy
> > > > > install_driver(Proxy) failed: Can't locate RPC/PlClient.pm in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBD/Proxy.pm line 28.
> > > > > BEGIN failed--compilation aborted at /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBD/Proxy.pm line 28.
> > > > > Compilation failed in require at (eval 3) line 3.
> > > > > Perhaps a module that DBD::Proxy requires hasn't been fully installed
> > > > > at ./drivers.pl line 7
> > > > > $
> > > > >
> > > > > Here is the drivers.pl that generated the output above:
> > > > > #!/usr/bin/perl
> > > > > use DBI;
> > > > > my @drivers=DBI->available_drivers();
> > > > > die "No drivers found.\n" unless @drivers;
> > > > > foreach my $driver ( @drivers ) {
> > > > > print "Driver: $driver \n";
> > > > > my @datasources = DBI->data_sources( $driver );
> > > > > foreach my $datasource ( @datasources ) {
> > > > > print "Data Source: $datasource \n";
> > > > > }
> > > > > print "\n";
> > > > > }
> > > > > exit;
> > > > >
> > > > > As you can see, Perl 5.8 works perfectly with DBI and DBD::Oracle on Linux.
> > > > > My advice is to switch to RH 8.0 (avoid 9 at all costs).
> > > > >
> > > > > On 2003.05.26 04:26 Denham Eva wrote:
> > > > > > Jared,
> > > > > >
> > > > > > Does that mean that you don't use Perl on Windows, or don't use windows at
> > > > > > all?
> > > > > > If you do, can you give us an idea of what your set up is, please.
> > > > > >
> > > > > > Regards
> > > > > > Denham
> > > > > >
> > > > > > -----
> > > > > >
> > > > > > Mladen,
> > > > > >
> > > > > > It ain't that simple. The DBD::Oracle for Perl 5.8 needs to be compiled
> > > > > > with 5.8 libs.
> > > > > >
> > > > > > ActiveState is letting it go by the wayside. They do not have a
> > > > > > DBD::Oracle that
> > > > > > is installable with 5.8.
> > > > > >
> > > > > > Even installing on 5.6.1 is a hack, you can't just load it from PPM
> > > > > > anymore.
> > > > > >
> > > > > > There was one at xmlproj.com, but the owner of that domain has gone
> > > > > > incommunicado.
> > > > > >
> > > > > > Jared
> > > > > >
> > > > > > _____________________________________________________________________________________
> > > > > > This e-mail message has been scanned for Viruses and Content and cleared
> > > > > > by MailMarshal
> > > > > >
> > > > > > For more information please visit www.marshalsoftware.com
> > > > > > _____________________________________________________________________________________
> > > > > >
> > > > > > #####################################################################################
> > > > > > Note:
> > > > > > This message is for the named person's use only. It may contain confidential,
> > > > > > proprietary or legally privileged information. No confidentiality or privilege
> > > > > > is waived or lost by any mistransmission. If you receive this message in error,
> > > > > > please immediately delete it and all copies of it from your system, destroy any
> > > > > > hard copies of it and notify the sender. You must not, directly or indirectly,
> > > > > > use, disclose, distribute, print, or copy any part of this message if you are not
> > > > > > the intended recipient. THIS COMPANY NAME and any of its subsidiaries each reserve
> > > > > > the right to monitor all e-mail communications through its networks.
> > > > > >
> > > > > > Any views expressed in this message are those of the individual sender, except where
> > > > > > the message states otherwise and the sender is authorized to state them to be the
> > > > > > views of any such entity.
> > > > > >
> > > > > > Thank You.
> > > > > > --
> > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > > > --
> > > > > > Author: Denham Eva
> > > > > > INET: EvaD_at_TFMC.co.za
> > > > > >
> > > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > > > > San Diego, California -- Mailing list and web hosting services
> > > > > > ---------------------------------------------------------------------
> > > > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > > > (or the name of mailing list you want to be removed from). You may
> > > > > > also send the HELP command for other information (like subscribing).
> > > > > >
> > > > >
> > > > > --
> > > > > Mladen Gogala
> > > > > Oracle DBA
> > > > > --
> > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > > --
> > > > > Author: Mladen Gogala
> > > > > INET: mgogala_at_adelphia.net
> > > > >
> > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > > > San Diego, California -- Mailing list and web hosting services
> > > > > ---------------------------------------------------------------------
> > > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > > (or the name of mailing list you want to be removed from). You may
> > > > > also send the HELP command for other information (like subscribing).
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > --
> > > > Author: Anjo Kolk
> > > > INET: anjo_at_oraperf.com
> > > >
> > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > > San Diego, California -- Mailing list and web hosting services
> > > > ---------------------------------------------------------------------
> > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed from). You may
> > > > also send the HELP command for other information (like subscribing).
> > > >
> > >
> > > --
> > > Mladen Gogala
> > > Oracle DBA
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Mladen Gogala
> > > INET: mgogala_at_adelphia.net
> > >
> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > San Diego, California -- Mailing list and web hosting services
> > > ---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Anjo Kolk
> > INET: anjo_at_oraperf.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Mladen Gogala
> Oracle DBA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: mgogala_at_adelphia.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Anjo Kolk
  INET: anjo_at_oraperf.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).