Re: multiple versions of oracle and dbi/dbd

If I compile the module for oracle 10g and move the build to a box that has
only oracle 9i, it will not work.

I can't be making different versions of the module for each aix box I have,
there is too many of them.

for example, the Oracle.so library is hardcoded to oracle 9i, so it would
not work on box that has 10g, since 9i does not exist.

#dump -H ./auto/DBD/Oracle/Oracle.so

../auto/DBD/Oracle/Oracle.so:

***Loader Section***
Loader Header Information
VERSION# #SYMtableENT #RELOCent LENidSTR
0x00000001 0x00000091 0x00000152 0x0000009e

#IMPfilID OFFidSTR LENstrTBL OFFstrTBL
0x00000005 0x00001d90 0x00000930 0x00001e2e


***Import File Strings***
INDEX PATH BASE MEMBER
0
/opt/oracle/product/9.2.0.6/lib32/:/opt/oracle/product/9.2.0.6/rdbms/lib32/:/usr/lib:/lib
1 libpthreads.a shr_xpg5.o
2 libc_r.a shr.o
3 ..
4 libclntsh.a shr.o


On Feb 6, 2008 10:57 AM, Alexander Foken <alexander@xxxxxxxx> wrote:

On 06.02.2008 16:27, Richard Labutis wrote:
hi,

I have an AIX box with Oracle 9i and 10g, how do deal with dbi/dbd
modules
that wants to be compiled specifically with one version of oracle.
How do I make this work with any version of oracle?


Oracle is backwards and forwards compatible, at least within a certain
range of version numbers. You should be able to connect to a 10g
database using a 9i client and vice versa.

Using the latest DBI, DBD::Oracle, and Oracle client libraries would not
hurt, though.

Alexander

--
Alexander Foken
mailto:alexander@xxxxxxxx http://www.foken.de/alexander/


Relevant Pages

  • Re: Cannot run a 64 bit program on a 32 bit processor
    ... For Oracle 9i and your questions about setting up AIX in 32-bit mode, ... As for Tuxedo, I only did the install once, but don't remember it ... Use the CIO mount option for JFS2 filesystems containing Oracle data ...
    (comp.unix.aix)
  • Re: AIX Performance issue
    ... however approx 30 users normally access AIX server ... > through oracle application, every thing was running fine during last 3 ... > sar and lpstat command and their output was as given below. ... > Mostly when error occurred our database daily backup was in process ...
    (comp.unix.aix)
  • Re: ORA-01115 IO errors
    ... Metalink indicates hardware problems and implies that indeed these ... The error is an operating system error, not an Oracle error. ... last time I worked with AIX files had names ... ... The root cause is probably related to the SAN, but it could also be an AIX ...
    (comp.databases.oracle.server)
  • Re: How to enable 64 bit environment on AIX 4.3.3
    ... oracle versions can run under which AIX versions. ... How to enable 64 bit environment on AIX 4.3.3 ... bos.64bit fileset is on the 4.3.x media, however, installing it does not ...
    (AIX-L)
  • Re: Oracle 9i RAC, AIX and GPFS
    ... Oracle 9i RAC, AIX and GPFS ... Have you considered not using the GPFS component and substituting raw lv's? ... We have a similar environment, 2x p690s, similar versions of AIX and Oracle. ...
    (AIX-L)