linux - Multiple Oracle versions using Perl -
have 1 system monitoring 2 oracle databases different versions
12.1 , 10.1
oracle client, sdk, sqlplus installed each , can query either 12.1 db or 10.1 setting theses after setting appropriate values for
export ld_library_path= export path= export oracle_base= export oracle_home= export tns_admin=`
but perl not seem pick the different versions. get:
critical - cannot connect 10.16.183.98:1521/cv. ora-03134: connections server version no longer supported. (dbd error: ocisessionbegin)
indicating using 12.1 try , connect 10.1. what's best method able query 2 different oracle database versions perl?
as trying control via environment variables, assume don't need talk both databases within same program.
if recall correctly, dbd::oracle needs built against specific oracle client intend use with. such, may wish compile 2 different versions of library separate directories , use lib
point specific 1 wish use.
Comments
Post a Comment