(Fwd) Re: Cross-version DBD Oracle Connectivity for local SYSDBA connection

----- Forwarded message from Ron Warshawsky -----

Date: Mon, 26 Dec 2005 03:11:56 -0800 (PST)
From: Ron Warshawsky
Reply-To: Ron Warshawsky
Subject: Re: Cross-version DBD Oracle Connectivity for local SYSDBA connection

Dear Tim,



Please excuse me if this message is not welcome.



I would really appreciate if you can give me some advice in regards to the below question:



I am working on Perl application that needs to be able to work with multiple versions of Oracle
connecting locally (BEQ) to databases as SYSDBA:



Connect string is:



my $dbh=DBI->connect('DBI:Oracle:','/','',{ora_session_mode=>2, PrintError=> 0, RaiseError=> 0 } );



Currently, when DBD is build using 9i ORACLE_HOME, etc, it would connect okay to 9i database, but
would end up with the segmentation core dump, when trying to connect to 10g database (with the
ORACLE_HOME, LD_LIBRARY_PATH, etc set properly) - probably due to up-version compatibility issues.



When DBD is build using 10g ORACLE_HOME, etc, it would connect okay to 10g database, but would end up
with the â**OCIEnvNlsCreate (check ORACLE_HOME and NLS settings etc.)â** error, when trying to connect
to 9i database - which is not expected, since 10g should be down-version compatible.



I run DBI level 4 traces and "straced" the execution, but was not able to get to the root cause.



The configuration is:



Server: Linux redhat 2.4.20-8

DB: Oracle 9.2.0.1 and 10.1.0.3.0

Perl 5.008006

DBI 1.47

DBD::Oracle 1.16



If this is something that you think would need substantial time to resolve, please let me know what
can be the cost for the consulting task?



Best regards,



Ron Warshawsky





----- End forwarded message -----