----- Forwarded message from Ron Warshawsky <[EMAIL PROTECTED]> -----
Date: Mon, 26 Dec 2005 03:11:56 -0800 (PST)
From: Ron Warshawsky <[EMAIL PROTECTED]>
Reply-To: Ron Warshawsky <[EMAIL PROTECTED]>
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 -----
