On Tue, Apr 6, 2010 at 2:06 PM, Shlomi Fish <shlo...@iglu.org.il> wrote:
> Hi Chen, > > "newbie01 perl" has asked a question about Oracle and Perl 5/DBI. Would you > be > able to enlighten them? (Everyone should note that Chen is an Oracle DBA > and a > good friend of mine). Please hit reply all as the @perl.org mailing lists > accept replies from non-subscribers and others may be interested in hearing > that. > > Regards, > > Shlomi Fish > > On Tuesday 06 Apr 2010 14:47:16 newbie01 perl wrote: > > Hi all, > > > > We currently have OEM installed but will have to uninstall it due to > > Oracle Licensing issues. Customers do not want to pay > > for the performance and diagnostic pack and are actually considering > > to move to SQLServer .. :-) > > > > Anyway, am wanting to try out and install oracletool or orcaware. Both > > of these require the DBI/DBD module. > > > > At the moment, am not allowed to do another install of Perl. I checked > > the OEM's .pl Perl scripts and just wrote a simple Perl script > > that has the use DBI; line on it and the full path to the Perl binary > > of the OEM install. Unfortunately, this does not work and the script > > cannot find the DBI module. > > > > Am writing to ask if anyone had tried a similar thing that am trying > > to do, that is use the DBI/DBD modules that comes with the OEM > > install? > > > > Any response will be very much appreciated to those who had tried > > this, whether it work or does not work. > > > > Thanks in advance. > > -- > ----------------------------------------------------------------- > Shlomi Fish http://www.shlomifish.org/ > "The Human Hacking Field Guide" - http://shlom.in/hhfg > > Deletionists delete Wikipedia articles that they consider lame. > Chuck Norris deletes deletionists whom he considers lame. > > Please reply to list if it's a mailing list post - http://shlom.in/reply . > > -- > To unsubscribe, e-mail: beginners-unsubscr...@perl.org > For additional commands, e-mail: beginners-h...@perl.org > http://learn.perl.org/ > > > So lets see the script and the error then :-) It makes it a lot easier to explain what is going on. But form my experience (never messed about with OEM my self), this sounds like a simple perl library issue. Your OEM program likely sets some environment variables that point perl to the right path for the library files. Writting your own script and simply calling the perl interpeter that comes with OEM will not work as it will not have the environment set correctly. What I woudl try is "hack" the OEM version of the perl script and have it print things like @INC and other environment variables that might help you simply make it write a file to /tmp at the start of the script and you should be fine. Then all you do is setup the same environment for your perl script and you should be good to go. Regards, Rob
