Beefy Boxes and Bandwidth Generously Provided by pair Networks
Come for the quick hacks, stay for the epiphanies.

comment on

( #3333=superdoc: print w/replies, xml ) Need Help??

Additionally (shooting in the dark). With Oracle there are major differences between local and remote databases and the way you connect to them. The most reproducible way of getting a good connection is to use the Oracle Instant Client.

The most recent version of OIC is 19.6. You require OIC-18 or up to connect to Oracle 12.2 or higher, so if your DBD::Oracle is compiled against old client libraries and you connect to Oracle Server 12.2 or higher, you might be able to connect, but the connection (if you connected) might return weird results.

You can check your client and server version most likely in a working Oracle environment by just starting sqlplus.

$ sqlplus scott/tiger SQL*Plus: Release - Production on Sun Mar 29 10:20:11 2020 Version Copyright (c) 1982, 2019, Oracle. All rights reserved. Last Successful login time: Sun Mar 29 2020 10:18:30 +02:00 Connected to: Oracle Database 12c Standard Edition Release - 64bit Produc +tion

This shows a client version connected to a server version

Also note that Oracle shows both 12.1 and 12.2 as 12c, and the two are really different!

So, even with an old(er) perl, check what OIC you are using and if your DBD::Oracle is compiled against that. If you ar not sure, be sure and just recompile from scratch.

$ wget +80.tar.gz $ tar xzf DBD-Oracle-1.80.tar.gz $ cd DBD-Oracle-1.80 $ perl Makefile.PL $ make $ make test $ make install

Why like this and not simply use cpan DBD::Oracle? Well, the described process will show you a lot of feedback and might ask you questions. Doing it interactively makes you (more) aware of the pitfalls.

Enjoy, Have FUN! H.Merijn

In reply to Re: Oracle::DBD to 12c server by Tux
in thread Oracle::DBD to 12c server by jerryhone

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

  • Are you posting in the right place? Check out Where do I post X? to know for sure.
  • Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
    <code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
  • Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
  • Want more info? How to link or How to display code and escape characters are good places to start.
Log In?

What's my password?
Create A New User
Domain Nodelet?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (3)
As of 2023-10-02 12:02 GMT
Find Nodes?
    Voting Booth?

    No recent polls found