Re: Building DBD::Oracle with the new Oracle Express product.



On 12/27/05, Ethan Brown <ethandbrown@xxxxxxxxx> wrote:
> Hi Tim--
>
> I'm having problems building DBD::Oracle with the new Oracle Express
> product (see
> http://www.oracle.com/technology/products/database/xe/index.html).
> This is a new distribution that installs nicely on Linux via a single
> RPM.
>
> During the building process I'm getting an error: "Unable to locate an
> oracle.mk, proc.mk or other suitable *.mk file in your Oracle
> installation. " These files are apparently used for Oracle Pro*C.
>
> Have you come across this problem? Any suggestions?
>
> Thanks,
>
> --Ethan
>

Well, it occurred to me that dbi-users@xxxxxxxx is actually a mailing
list. I googled and found some postings by you (Tim) about a patch to
Makefile.pl in the thread
http://groups.google.com/group/perl.dbi.users/browse_thread/thread/f4c50c67f7dccfd9/08b3acd637ac2001?q=oracle+xe&rnum=1#08b3acd637ac2001

I applied the patches, but got an error in the output:
------------------------------
Using Oracle in /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)
Looks like Oracle XE
Reading /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
ERROR parsing /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk:
Unable to determine what to link with.
---------------------------------

Undaunted, I poked around in Makefile.PL and the file demo_xe.mk, and
figured I could get things to work if I just hard-coded the use of
LIBCLNTSH:
---------------------------------
$linkvia = '$(LIBCLNTSH)' if !$linkvia && $MK{LIBCLNTSH};

## EDB. Force linkvia to use LIBCLNTSH
$linkvia = '$(LIBCLNTSH)';
## END EDB

# The oracle.mk file tends to define OCILDLIBS
$linkvia = '$(OCILDLIBS)' if !$linkvia && $MK{OCILDLIBS};
---------------------------------

This ended up doing the trick.

Apologies for not searching more thoroughly before sending my last mail.
(By the way, my platform is Linux Mandrake 10.1 on x86).

Thanks,

--Ethan
.



Relevant Pages

  • Building DBD::Oracle with the new Oracle Express product.
    ... I'm having problems building DBD::Oracle with the new Oracle Express ... This is a new distribution that installs nicely on Linux via a single ... RPM. ...
    (comp.lang.perl.misc)
  • Building DBD::Oracle with the new Oracle Express product.
    ... I'm having problems building DBD::Oracle with the new Oracle Express ... This is a new distribution that installs nicely on Linux via a single ... RPM. ...
    (perl.dbi.users)
  • Dimensions in Oracle
    ... Oracle 9i, ... The date type dimension pointing to a date type column, ... is having problems building, are there any known ...
    (microsoft.public.sqlserver.olap)
  • Re: question to provable security
    ... The point is that according to Def1, ... No S with access to the second oracle can produce the same ... For Def2, an S that always outputs 0 will do the trick, since you ... distribution is known to S such that he could sample a random value ...
    (sci.crypt)
  • Re: oracle application server 10g tuning
    ... you choose to install this on a distribution of Linux ... If you google centos 5.2 oracle 10g ...
    (comp.databases.oracle.server)