This has got to be a FAQ, but I coud find it nowhere there...

I've been schooling myself on Oracle for purposes of pursuing some light database applications programming Ala perl/cgi, html, and Oracle. (Nothing like job skills, eh? ;^)

As might be expected, I've been having a rather beastly time getting the perl DBI/Oracle DBD code properly installed.

My oracle server is running Oracle 8.6.1 on RH6.1, 2.4 series kernel, with perl 5.006 (I think that version is correct), my webserver (where the cgi code runs) is running RH7 (also with a 2.4 series kernel), and a fairly recent Perl release (whatever was sent down the pipe with the last 'up2date' run).

I had some limited success initially when putting this stuff together - the biggest problem I seem to have had is that when I execute 'perl -MCPAN -e shell' and subsequently 'install Bundle::CPAN' (as directed by ppm) it goes out and attempts to freshen the base perl package (which takes a rather long time and generally fails).

Having gotten past the issue that the DBD::Oracle piece has to be (manually!! no ppm!) installed on the Oracle server (as opposed to the webserver ((man what was I thinking?)) ;) I guess I'm left with two installations of perl that are broken in places (or at least have some broken code installed).

As an aspiring perl programmer this is not the first time I have found myself in a situation like this; generally perl proves so difficult to fix directly that I end up reloading the O/S, or at minimum, something simillarly painfull.

I guess I what I really need to know is: Is there a clean and simple way to back out failed module installs? I've already made several runs at installing various DB* modules as I work out the particulars of this environment; I've broken code, unneccesary modules, and various other by products of experimentation that I need to clean up. Any instruction along these lines would be greatly appreciated.

Oh, and if you happen to have any good pointers for doing database appps with oracle and perl I'd be delighted to hear your suggestions there as well.

May the manifold blessings of Eureka! visit you often-

BrotherTwitch

In reply to Perl In, Perl Out... by brotherTwitch

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.