Thread: Acess Oracle with dbi-link (PostgreSQL) Error Compile

Acess Oracle with dbi-link (PostgreSQL) Error Compile

From
Emanuel Araújo
Date:
Hello!

I'm having trouble making a base to access Oracle via dbi-link, because when installing DBD::Oracle version 1.58 the same mistakes some missing files. Ago as "oci.h", it is being called within the oracle.h

The purpose would be to sync data between two tools for integration.

Has anyone experienced this?
Have any solution or suggestion?
There is another tool that I could be using to make this access?

The following error returned by Perl when you squeegee "make"

make
gcc-c-D_REENTRANT-D_GNU_SOURCE -I/root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/DBI-fno-strict-aliasing-pipe-fstack-protector -I/usr/local/include - D_LARGEFILE_SOURCE-D_FILE_OFFSET_BITS = 64-g-O2-pipe-Wall-Wp,-D_FORTIFY_SOURCE = 2-fexceptions-fstack-protector - param = ssp-buffer-size = 4-m64-mtune = generic-DVERSION = \ "1:58 \ "-DXS_VERSION = \" 1:58 \ "-fPIC" -I/usr/lib64/perl5/CORE "-Wall-Won-comment-DUTF8_SUPPORT-DORA_OCI_VERSION = \" 10.2.0.3 \ "-DORA_OCI_102 Oracle.c
In file included from Oracle.xs: 1:0:
Oracle.h: 37:17: fatal error: oci.h: File or directory not found
compilation terminated.
make: ** [Oracle.o] Error 1

Thank you.


--
Atenciosamente,

Emanuel Araújo

http://eacshm.wordpress.com/
http://www.rootserv.com.br/

Linux Certified
LPIC-1

Re: Acess Oracle with dbi-link (PostgreSQL) Error Compile

From
Albe Laurenz
Date:
Emanuel Araújo wrote:
> I'm having trouble making a base to access Oracle via dbi-link, because when installing DBD::Oracle
> version 1.58 the same mistakes some missing files. Ago as "oci.h", it is being called within the
> oracle.h
>
> The purpose would be to sync data between two tools for integration.
>
> Has anyone experienced this?
> Have any solution or suggestion?
> There is another tool that I could be using to make this access?
>
> The following error returned by Perl when you squeegee "make"
>
> make
> gcc-c-D_REENTRANT-D_GNU_SOURCE -I/root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/DBI-fno-strict-
> aliasing-pipe-fstack-protector -I/usr/local/include - D_LARGEFILE_SOURCE-D_FILE_OFFSET_BITS = 64-g-O2-
> pipe-Wall-Wp,-D_FORTIFY_SOURCE = 2-fexceptions-fstack-protector - param = ssp-buffer-size = 4-m64-
> mtune = generic-DVERSION = \ "1:58 \ "-DXS_VERSION = \" 1:58 \ "-fPIC" -I/usr/lib64/perl5/CORE "-Wall-
> Won-comment-DUTF8_SUPPORT-DORA_OCI_VERSION = \" 10.2.0.3 \ "-DORA_OCI_102 Oracle.c
> In file included from Oracle.xs: 1:0:
> Oracle.h: 37:17: fatal error: oci.h: File or directory not found
> compilation terminated.
> make: ** [Oracle.o] Error 1

You need Oracle's header files.
In Instant Client they are called "SDK", and in the regular Oracle
client installation they are called "Programmer" or some similar
cryptic name.  If in doubt, install everything.

If you have PostgreSQL 9.1 or later, you could consider using
oracle_fdw (http://oracle-fdw.projects.pgfoundry.org/).

Yours,
Laurenz Albe