Thread: Oracle_fdw
Hello Team!
We are using Postgresql-15, ahd having issues importing foreign schema with all its objects from an Oracle databse. Here is the error I am getting, "error connecting to Oracle: OCIEnvCreate failed to create environment handle: Detail: SQL state: HV00N
I have installed oracle instantclient 19_24
I would appreciate any help getting this resolved.
Regards
Yong Serk
On Tue, 2025-04-22 at 07:28 -0400, Yongye Serkfem wrote: > We are using Postgresql-15, ahd having issues importing foreign schema with all > its objects from an Oracle databse. Here is the error I am getting, > "error connecting to Oracle: OCIEnvCreate failed to create environment handle: Detail: SQL state: HV00N > I have installed oracle instantclient 19_24 > I would appreciate any help getting this resolved. This error usually indicated that you configured the Oracle Client wrongly. Usually, that is a question of setting environment variables wrong, but unfortunately it is a very generic error that Oracle throws when "something is wrong". Your best bet is to research all the oracle_fdw issues that reported this error. Hopefully, one of these cases matches yours: https://github.com/laurenz/oracle_fdw/issues?q=is%3Aissue%20OCIEnvCreate Yours, Laurenz Albe
Thanks, I'll look into it.
On Tue, Apr 22, 2025, 7:54 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Tue, 2025-04-22 at 07:28 -0400, Yongye Serkfem wrote:
> We are using Postgresql-15, ahd having issues importing foreign schema with all
> its objects from an Oracle databse. Here is the error I am getting,
> "error connecting to Oracle: OCIEnvCreate failed to create environment handle: Detail: SQL state: HV00N
> I have installed oracle instantclient 19_24
> I would appreciate any help getting this resolved.
This error usually indicated that you configured the Oracle Client wrongly.
Usually, that is a question of setting environment variables wrong, but
unfortunately it is a very generic error that Oracle throws when "something
is wrong".
Your best bet is to research all the oracle_fdw issues that reported this
error. Hopefully, one of these cases matches yours:
https://github.com/laurenz/oracle_fdw/issues?q=is%3Aissue%20OCIEnvCreate
Yours,
Laurenz Albe