public inbox for [email protected]
help / color / mirror / Atom feedRe: Oracle_fdw
2+ messages / 2 participants
[nested] [flat]
* Re: Oracle_fdw
@ 2025-04-22 11:54 Laurenz Albe <[email protected]>
2025-04-22 17:06 ` Re: Oracle_fdw Yongye Serkfem <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Laurenz Albe @ 2025-04-22 11:54 UTC (permalink / raw)
To: Yongye Serkfem <[email protected]>; pgsql-generallists.postgresql.org <[email protected]>
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Oracle_fdw
2025-04-22 11:54 Re: Oracle_fdw Laurenz Albe <[email protected]>
@ 2025-04-22 17:06 ` Yongye Serkfem <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Yongye Serkfem @ 2025-04-22 17:06 UTC (permalink / raw)
To: Laurenz Albe <[email protected]>; +Cc: pgsql-generallists.postgresql.org <[email protected]>
Thanks, I'll look into it.
On Tue, Apr 22, 2025, 7:54 AM Laurenz Albe <[email protected]> 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
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-04-22 17:06 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-04-22 11:54 Re: Oracle_fdw Laurenz Albe <[email protected]>
2025-04-22 17:06 ` Yongye Serkfem <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox