Skip Menu |

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-Oracle CPAN distribution.

Report information
The Basics
Id: 72463
Status: resolved
Priority: 0/
Queue: DBD-Oracle
People
Owner: Nobody in particular
Requestors: cj10 [...] cam.ac.uk
Cc:
AdminCc:
Bug Information
Severity: Normal
Broken in: 1.34
Fixed in: (no value)
Attachments
suggested_patch

History Show all quoted text
  Wed Nov 16 07:53:27 2011 cj10 [...] cam.ac.uk - Ticket created
Subject: Problems building against a 32-bit full Oracle client
The purpose of the request is to report a problem which occurs when attempting to build DBD::Oracle 1.34 against a full Oracle 11.2 client on a 32-bit unix platform, and to suggest a fix for it. For the record, I am using perl 5.14.2. My 32-bit platform is Open SUSE 11.4, and my 64-bit platform is SLES 11 SP 1. The Oracle version is 11.2.0.3.0. Background: There are two routes to a successful build on a 64-bit platform. A. Using the Oracle-recommended make-file. The make file Oracle recommend for building OCI applications for Oracle 11 is $ORACLE_HOME/rdbms/demo/. See http://download.oracle.com/docs/cd/E11882_01/server.112/e10839/prcmp_cll_int.htm#BABDGIDJ This file is not shipped as part of either the full client or the server. It is shipped with the 'Database Examples' on disc 7 of 7. If the examples are installed into the same ORACLE_HOME as the full client, Makefile.PL will use $ORACLE_HOME/rdbms/demo/demo_rdbms.mk, and succeed. B. Without the Oracle-recommended make-file. If the Oracle-recommended make file is not installed, Makefile.PL will use instead $ORACLE_HOME/rdbms/lib/ins_rdbms.mk. In this case Makefile.PL writes an alarming warning message (which will be the subject of another RT request), but succeeds. A successful build ensues. On a 32-bit platform, neither route works. This is because the required make-files are not included in the list @mk_oci32 at the beginning of the subroutine find_mkfile in Makefile.PL. Attached is a patch which which fixed this, and makes both routes work in a 32-bit context. Note the necessity to include demo_rdbms.mk in @mk_oci32 after demo_rdbms32.mk. The use of these file names in Oracle 11 is documented in the Oracle documentation referenced above.
Subject: suggested_patch
Download suggested_patch
application/octet-stream 806b

Message body not shown because it is not plain text.

  Thu Nov 17 08:16:33 2011 bohica [...] ntlworld.com - Status changed from 'new' to 'patched'
  Thu Nov 17 08:18:08 2011 bohica [...] ntlworld.com - Correspondence added
On Wed Nov 16 07:53:27 2011, cj10@cam.ac.uk wrote: Show quoted text
> The purpose of the request is to report a problem which occurs when > attempting to build DBD::Oracle 1.34 against a full Oracle 11.2 client > on a 32-bit unix platform, and to suggest a fix for it. > > For the record, I am using perl 5.14.2. My 32-bit platform is > Open SUSE 11.4, and my 64-bit platform is SLES 11 SP 1. The > Oracle version is 11.2.0.3.0. > > Background: > > There are two routes to a successful build on a 64-bit platform. > > A. Using the Oracle-recommended make-file. > > The make file Oracle recommend for building OCI applications > for Oracle 11 is $ORACLE_HOME/rdbms/demo/. See >
http://download.oracle.com/docs/cd/E11882_01/server.112/e10839/prcmp_cll_int.htm#BABDGIDJ Show quoted text
> This file is not shipped as part of either the full client or > the server. It is shipped with the 'Database Examples' on > disc 7 of 7. If the examples are installed into the same > ORACLE_HOME as the full client, Makefile.PL will use > $ORACLE_HOME/rdbms/demo/demo_rdbms.mk, and succeed. > > B. Without the Oracle-recommended make-file. > > If the Oracle-recommended make file is not installed, Makefile.PL > will use instead $ORACLE_HOME/rdbms/lib/ins_rdbms.mk. In this > case Makefile.PL writes an alarming warning message (which will be > the subject of another RT request), but succeeds. A successful > build ensues. > > On a 32-bit platform, neither route works. This is because the > required make-files are not included in the list @mk_oci32 at the > beginning of the subroutine find_mkfile in Makefile.PL. > > Attached is a patch which which fixed this, and makes both routes > work in a 32-bit context. > > Note the necessity to include demo_rdbms.mk in @mk_oci32 after > demo_rdbms32.mk. The use of these file names in Oracle 11 is > documented in the Oracle documentation referenced above.
Thanks Charles, Applied to subversion trunk. Would be grateful if you got a chance to check it applied correctly as I had to do it manually - since your patch was against an older version. Martin -- Martin J. Evans Wetherby, UK
  Thu Nov 17 08:18:09 2011 The RT System itself - Status changed from 'patched' to 'open'
  Thu Nov 17 08:20:19 2011 bohica [...] ntlworld.com - Status changed from 'open' to 'patched'
  Thu Nov 17 12:08:49 2011 cj10 [...] cam.ac.uk - Correspondence added
From: cj10 [...] cam.ac.uk
On Thu Nov 17 08:18:08 2011, MJEVANS wrote: Show quoted text
> On Wed Nov 16 07:53:27 2011, cj10@cam.ac.uk wrote:
> > The purpose of the request is to report a problem which occurs when > > attempting to build DBD::Oracle 1.34 against a full Oracle 11.2 client > > on a 32-bit unix platform, and to suggest a fix for it.
Show quoted text
> > Thanks Charles, > > Applied to subversion trunk. Would be grateful if you got a chance to > check it applied correctly as I had to do it manually - since your > patch was against an older version.
Thank you. The patch applied correctly. Indeed this is the first change to the file in question since the 1.34 release. I should have patched against the svn trunk. I am sorry. I will do this right next time.
  Thu Nov 17 12:08:51 2011 The RT System itself - Status changed from 'patched' to 'open'
  Tue Dec 06 16:55:07 2011 champoux [...] pythian.com - Correspondence added
released in v1.36
  Tue Dec 06 16:55:08 2011 champoux [...] pythian.com - Status changed from 'open' to 'resolved'