Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: Perl DBI not working with Oracle DBD in 11g r2 environment

by Tux (Monsignor)
on Nov 22, 2011 at 20:15 UTC ( #939535=note: print w/ replies, xml ) Need Help??


in reply to Perl DBI not working with Oracle DBD in 11g r2 environment

So you jump from oracle 9 to Oracle 11, which probably took over 7 hours to complete, but you are still at perl-5.6.1 (released on 2001-04-08), DBI-1.21 (released 2002-02-07) and DBD::Oracle-1.06 (released 2000-07-14).

Current is perl-5.14.2, DBI-1.616, and DBD::Oracle-1.34. Maybe, just maybe, these new versions might have "fixed" issues with these newer Oracle releases.

I do not know exactly when exactly Oracle-11 was released, but I'm sure it was waaaaaaay later than 14-07-2000.

I am very very sure noone will fix this bug for you with these old versions.

update: Here is the Oracle release scheme (published 2008-11-11):

Release Released Oracle 6 1988 Oracle 7 1992 Oracle 8 1997 Oracle 8i 1998 Oracle 9i 2001 Oracle 10g 2004 Oracle 11g 2007

There is no way bugs in DBD::Oracle (or DBI) related to Oracle released later than the versions you use could have been fixed/tested before this newer version was available to test with.


Enjoy, Have FUN! H.Merijn


Comment on Re: Perl DBI not working with Oracle DBD in 11g r2 environment
Download Code
Re^2: Perl DBI not working with Oracle DBD in 11g r2 environment
by seekhelp (Initiate) on Nov 23, 2011 at 17:20 UTC
    Thank you very much for you response !!
    I will try to get PERL DBI upgraded.
    I think there is some libraries from 9i that are getting used my 11g.

    ------------------------------- Even below code is failing:
    </code>
    #!/u00/app/xxx/bin/perl
    my $ORACLE_HOME = "/u00/app/oracle/product/11.2.0.2";
    my $ORACLE_SID="xxxxT11";
    $ENV{ORACLE_HOME}=$ORACLE_HOME;
    $ENV{ORACLE_SID}=$ORACLE_SID;
    $ENV{PATH}="$ORACLE_HOME/bin";
    $ENV{LD_LIBRARY_PATH}="$ORACLE_HOME/lib";
    use strict;
    use DBI;
    my $dbh = DBI->connect( 'dbi:Oracle:orcl', 'scott', 'tiger', ) || die "Database connection not made: $DBI::errstr";
    $dbh->disconnect;
    </code>
    ----------------------- Error : failed: (UNKNOWN OCI STATUS 1804) OCIInitialize. Check ORACLE_HOME and NLS settings etc. at newtest line 10
    -------------------------

    its not even checking my Credentials..( scott is not login user ) failing to connect.
    ----------------------- Please let me know if I am missing something here !!


    Thanks all !!


      Just FYI, it is way more important to update DBD::Oracle than it is to update DBI. The latter has no knowledge of oracle connections at all. Current DBD::Oracle requires DBI version 1.51 (since 27-01-2011, DBD::Oracle-1.28). Before that, it had no prerequired version for DBI. You just had to keep your hopes up.


      Enjoy, Have FUN! H.Merijn
        Let me even get the DBD upgraded.
        I read this below in link
        http://search.cpan.org/~pythian/DBD-Oracle-1.34/Oracle.pm
        It say :

        “ORACLE_HOME can be left unset if you aren't using any of Oracle's executable, but it is not recommended and error messages may not display. It should be set to the ORACLE_HOME directory of the version of Oracle that DBD::Oracle was compiled with.”

        Does it mean DBD oracle need to be upgraded if we have a new version of oracle.
        for example : DBD was compile when the version was 9i and oracle home poin to 9.2 directory.
        Now DBD is not compilled just we changes the oracle_home to 11.2.
        Thanks all !!

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://939535]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (7)
As of 2014-12-21 23:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (109 votes), past polls