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: 59203
Status: resolved
Priority: 0/
Queue: DBD-Oracle

People
Owner: Nobody in particular
Requestors: ribasushi [...] leporine.io
Cc:
AdminCc:

Bug Information
Severity: Unimportant
Broken in: (no value)
Fixed in: (no value)



Subject: Unable to automatically locate a *.mk on oracle-xe under debian
DBD::Oracle compiles cleanly against the .deb of Oracle XE (distributed by oracle themselves), but sadly requires handholding: =================== Files available from Oracle: =================== rabbit@Thesaurus:~/src/DBD-Oracle-1.24$ locate .mk | grep oracle /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/demo_xe.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/env_ctx.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/lib/ins_ctx.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk =================== Without hints: =================== rabbit@Thesaurus:~/src/DBD-Oracle-1.24$ ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client perl Makefile.PL Using DBI 1.611 (for perl 5.013002 on i686-linux-thread-multi) installed in /home/rabbit/perl5/perlbrew/perls/5.13.2/lib/site_perl/5.13.2/i686-linux-thread-multi/auto/DBI/ Configuring DBD::Oracle for perl 5.013002 on linux (i686-linux-thread-multi) Remember to actually *READ* the README file! Especially if you have any problems. Installing on a linux, Ver#2.6 Using Oracle in /usr/lib/oracle/xe/app/oracle/product/10.2.0/client DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR) Oracle version 10.2.0.1 (10.2) Unable to locate an oracle.mk, proc.mk or other suitable *.mk file in your Oracle installation. (I looked in /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/demo_rdbms32.mk /usr/share/oracle/xe/app/oracle/product/10.2.0/client/demo.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/precomp/demo/proc/proc.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/precomp/demo/proc/demo_proc.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/proc/lib/proc.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/proc16/lib/proc16.mk /usr/share/oracle/10.2/client/demo.mk /usr/share/oracle/10.2/client64/demo.mk under /usr/lib/oracle/xe/app/oracle/product/10.2.0/client) The oracle.mk (or demo_rdbms.mk) file is part of the Oracle RDBMS product. The proc.mk (or demo_proc.mk) file is part of the Oracle Pro*C product. You need to build DBD::Oracle on a system which has one of these Oracle components installed. (Other *.mk files such as the env_*.mk files will not work.) Alternatively you can use Oracle Instant Client. In the unlikely event that a suitable *.mk file is installed somewhere non-standard you can specify where it is using the -m option: perl Makefile.PL -m /path/to/your.mk See the appropriate README file for your OS for more information and some alternatives. at Makefile.PL line 1095. =================== With -m: =================== rabbit@Thesaurus:~/src/DBD-Oracle-1.24$ ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client perl Makefile.PL -m /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/demo_xe.mk Using DBI 1.611 (for perl 5.013002 on i686-linux-thread-multi) installed in /home/rabbit/perl5/perlbrew/perls/5.13.2/lib/site_perl/5.13.2/i686-linux-thread-multi/auto/DBI/ Configuring DBD::Oracle for perl 5.013002 on linux (i686-linux-thread-multi) Remember to actually *READ* the README file! Especially if you have any problems. Installing on a linux, Ver#2.6 Using Oracle in /usr/lib/oracle/xe/app/oracle/product/10.2.0/client DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR) Oracle version 10.2.0.1 (10.2) Found /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/demo_xe.mk Using /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/demo_xe.mk Looks like Oracle XE (/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/demo_xe.mk) Reading /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/demo_xe.mk Your LD_LIBRARY_PATH env var is set to '' WARNING: Your LD_LIBRARY_PATH env var doesn't include '/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib' but probably needs to. Checking for functioning wait.ph System: perl5.013002 linux thesaurus 2.6.29.2.thes2 #1 preempt tue sep 8 11:27:43 cest 2009 i686 gnulinux Compiler: cc -O2 -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 Linker: /usr/bin/ld Sysliblist: Oracle makefiles would have used these definitions but we override them: CC: /usr/bin/gcc LDFLAGS: -g [-g] Linking with -L/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/ -lclntsh -lpthread Checking if your kit is complete... Looks good LD_RUN_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib Using DBD::Oracle 1.24. Using DBD::Oracle 1.24. Using DBI 1.611 (for perl 5.013002 on i686-linux-thread-multi) installed in /home/rabbit/perl5/perlbrew/perls/5.13.2/lib/site_perl/5.13.2/i686-linux-thread-multi/auto/DBI/ Writing Makefile for DBD::Oracle *** If you have problems... read all the log printed above, and the README and README.help.txt files. (Of course, you have read README by now anyway, haven't you?) Cheers!
Will have to call on you for a little debugging for the Makfile.PL Having a quick look at the output and what I know I am looking for I can see that the Makefile.PL is not finding the file for whatever reason. The only difference is you are using perl 5.13 which is rather new and I have yet to work with it myself. This would lead me to believe that something might be up with perl in this case. Anyway the bug is in find_mkfile someplace if you could have a look there for it yourself as the best I can do now (without the same environment/perl as you) is just provide a warning to use -M if it a debian XE
On Thu Jul 08 14:37:41 2010, PYTHIAN wrote: Show quoted text
> Will have to call on you for a little debugging for the Makfile.PL > > Having a quick look at the output and what I know I am looking for I can > see that the Makefile.PL is not finding the file for whatever reason.
Sorry I thought it's rather obvious thus didn't elaborate: my @mk_oci32 = ( 'rdbms/demo/demo_rdbms32.mk' ); my @mk_oci64 = ( 'rdbms/demo/demo_xe.mk', 'rdbms/lib/oracle.mk', 'rdbms/demo/oracle.mk', 'rdbms/demo/demo_rdbms.mk', 'rdbms/demo/demo_rdbms64.mk', 'rdbms/lib/ins_rdbms.mk' #Oracle 11 full client for 64 bit and maybe 32 bit?? ); my @mk_oci = perl_is_64bit() ? @mk_oci64 : @mk_oci32; I however run an all-32bit system and yet my file is still called demo_xe.mk. I am attaching a list of files in the Oracle-XE client .deb obtainable from http://download.oracle.com/otn/linux/oracle10g/xe/10201/oracle-xe-client_10.2.0.1-1.0_i386.deb: rabbit@Thesaurus:~/src/DBD-Oracle-1.24$ dpkg -L oracle-xe-client /. /usr /usr/lib /usr/lib/oracle /usr/lib/oracle/xe /usr/lib/oracle/xe/app /usr/lib/oracle/xe/app/oracle /usr/lib/oracle/xe/app/oracle/product /usr/lib/oracle/xe/app/oracle/product/10.2.0 /usr/lib/oracle/xe/app/oracle/product/10.2.0/client /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.csh /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/nls_lang.sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/ott /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/zip /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/unzip /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/jdbc /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/jdbc/lib /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/jdbc/lib/ojdbc14.jar /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/jlib /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/jlib/orai18n.jar /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libsqlplusic.so /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libsqlplus.so /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libocixe.so /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libsqora.so.10.1 /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libnnz10.so /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libocci.so.10.1 /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libclntsh.so.10.1 /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libocijdbc10.so /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libheteroxa10.so /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/odbc /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/odbc/utl /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/odbc/utl/odbc_update_ini.sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/odbc/html /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/odbc/html/ODBC_Readme_Unix.html /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/odbc/html/ODBCRelnotesUS.htm /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/odbc/html/ODBCRelnotesJA.htm /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/precomp /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/precomp/lib /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/precomp/lib/ottclasses.zip /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/precomp/admin /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/precomp/admin/ottcfg.cfg /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/xa.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/ort.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/oro.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/orl.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/orid.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/ori.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/oratypes.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/odci.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/ocixmldb.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/ocikpr.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/ociextp.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/ocidfn.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/ocidem.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/ocidef.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/ociapr.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/ociap.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/oci8dp.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/oci1.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/oci.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/occiObjects.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/occiData.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/occiControl.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/occiCommon.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/occiAQ.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/occi.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/nzt.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/nzerror.h /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/odbcdemo.c /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/occiobj.typ /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/occiobj.cpp /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/occidml.cpp /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/occidemo.sql /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/demo_xe.mk /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/demo/cdemo81.c /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/scripts /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/scripts/sqlplus.sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/scripts/runsqlplus.sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/scripts/registerforonlineforum.sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/scripts/readdocumentation.sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/scripts/oraclexe-client-rhel3.menu /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/scripts/oraclexe-client-merge.menu /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/scripts/gotoonlineforum.sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/sqlplus/glogin.sql /usr/lib/oracle/xe/app/oracle/doc /usr/share /usr/share/pixmaps /usr/share/pixmaps/oraclexe-client-10g.png /usr/share/pixmaps/oraclexe-client-gethelp.png /usr/share/pixmaps/oraclexe-client-gotoonlineforum.png /usr/share/pixmaps/oraclexe-client-readdocumentation.png /usr/share/pixmaps/oraclexe-client-registerforonlineforum.png /usr/share/pixmaps/oraclexe-client-runsqlcommandline.png /usr/share/applications /usr/share/applications/oraclexe-client-gotoonlineforum.desktop /usr/share/applications/oraclexe-client-readdocumentation.desktop /usr/share/applications/oraclexe-client-registerforonlineforum.desktop /usr/share/applications/oraclexe-client-runsql.desktop /usr/share/gnome /usr/share/gnome/vfolders /usr/share/gnome/vfolders/oraclexe-client-10g.directory /usr/share/gnome/vfolders/oraclexe-client-gethelp.directory /usr/share/desktop-directories /usr/share/desktop-directories/oraclexe-client-gethelp.directory /usr/share/desktop-directories/oraclexe-client-10g.directory /usr/share/lintian /usr/share/lintian/overrides /usr/share/lintian/overrides/oracle-xe-client /usr/share/doc /usr/share/doc/oracle-xe-client /usr/share/doc/oracle-xe-client/README.Debian /usr/share/doc/oracle-xe-client/copyright /usr/share/doc/oracle-xe-client/changelog.Debian.gz /usr/share/man /usr/share/man/man1 /usr/share/man/man1/client-sqlplus.1.gz /etc /etc/xdg /etc/xdg/menus /etc/xdg/menus/oraclexe-client.menu /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libclntsh.so /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libocci.so
Oh OK I think we already fixed that one (looking at the code anyway) can you give this Makefile.pl a try and see if it works for you http://svn.perl.org/modules/dbd-oracle/trunk/Makefile.PL This is the latest version from trunk and it sets this for the mk_oci32 my @mk_oci32 = ( 'rdbms/demo/demo_xe.mk', 'rdbms/demo/demo_rdbms32.mk' );
On Thu Jul 08 20:08:14 2010, PYTHIAN wrote: Show quoted text
> Oh OK I think we already fixed that one (looking at the code anyway) > > can you give this Makefile.pl a try and see if it works for you > > http://svn.perl.org/modules/dbd-oracle/trunk/Makefile.PL > > This is the latest version from trunk and it sets this for the mk_oci32 > > my @mk_oci32 = ( > 'rdbms/demo/demo_xe.mk', > 'rdbms/demo/demo_rdbms32.mk' > ); >
Yup. You may close this ticket.
This ticket has been resolved a while ago. Please close.
Duh, apparently I can do it myself.