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

[Tux]

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.

[seekhelp]

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 !!

[Tux]

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.

[seekhelp]

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 !!