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).
Received on Mon May 26 2003 - 18:56:38 CDT
