FDW for Oracle

Hello

This is me problem:

fdw_test=# SELECT oracle_diag();
oracle_diag
---------------------------------------------------------------------------------------------------------------
oracle_fdw 1.2.0, PostgreSQL 9.1.8, Oracle client 11.2.0.1.0,
ORACLE_HOME=/opt/oracle/, TNS_ADMIN=/opt/oracle
(1 row)

In PostgreSQL:
SELECT pg_backend_pid();
5543

In a second session in the shell:
ps -p5543 -oppid=
5290

As root or PostgreSQL OS user:
cat /proc/5290/environ | xargs -0 -n1

LD_LIBRARY_PATH=/usr/lib:/opt/PostgreSQL/9.1/lib:/opt/oracle/instantclient:$LD_LIBRARY_PATH
HOME=/opt/PostgreSQL/9.1
TNS_ADMIN=/opt/oracle
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/opt/PostgreSQL/9.1/bin:/usr/lib/postgresql/9.1/bin:/opt/PostgreSQL/9.1/bin/bin
ORACLE_HOME=/opt/oracle
DYLD_LIBRARY_PATH=/opt/oracle/instantclient:$ORACLE_HOME

My error is: OCIEnvCreate

¿What is the solution? Please.

Saludos,
Gilberto Castillo
La Habana, Cuba

On Fri, Feb 20, 2015 at 7:15 AM, Gilberto Castillo wrote:

This is me problem:
fdw_test=# SELECT oracle_diag();
oracle_diag
---------------------------------------------------------------------------------------------------------------
oracle_fdw 1.2.0, PostgreSQL 9.1.8, Oracle client 11.2.0.1.0,
ORACLE_HOME=/opt/oracle/, TNS_ADMIN=/opt/oracle
(1 row)
[...]
My error is: OCIEnvCreate
¿What is the solution? Please.

If you have an issue with this fdw, you had better contact the project
maintainers here:
https://github.com/laurenz/oracle_fdw
Regards,
--
Michael

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