Acess Oracle with dbi-link (PostgreSQL) Error Compile

Started by Emanuel Araújoabout 13 years ago2 messagesgeneral
Jump to latest
#1Emanuel Araújo
eacshm@gmail.com

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*

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Emanuel Araújo (#1)
Re: Acess Oracle with dbi-link (PostgreSQL) Error Compile

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general