[HACKERS] FDW for Oracle
Hello This is me problem: Saludos, Gilberto Castillo La Habana, Cuba --- This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu Visit our web-site: http://www.kaspersky.com, http://www.viruslist.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] 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 --- This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu Visit our web-site: http://www.kaspersky.com, http://www.viruslist.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] FDW for Oracle
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
