Postgres Pro
Downloads
Home   >   mailing lists

Thread: FDW for Oracle

FDW for Oracle

From
"Gilberto Castillo"
Date:

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>

Re: FDW for Oracle

From
"Gilberto Castillo"
Date:

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>

Re: FDW for Oracle

From
Michael Paquier
Date:
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