MIME-Version: 1.0
References: <CAAu_hGs2hGk8M4+1QO=6mK+nEHR0HHc49RciADRBAWmsqgFDpw@mail.gmail.com>
 <76bb8214bcb3a4164b2d99c65982848f1e5d8a0d.camel@cybertec.at>
In-Reply-To: <76bb8214bcb3a4164b2d99c65982848f1e5d8a0d.camel@cybertec.at>
From: Yongye Serkfem <yserkfem@gmail.com>
Date: Tue, 22 Apr 2025 13:06:28 -0400
Message-ID: <CAAu_hGsoB3drCJJaBhE73r3QtkmBhnA4hg-SDYb3GOBWt7y3sA@mail.gmail.com>
Subject: Re: Oracle_fdw
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000001728670633610296"
Archived-At: <https://www.postgresql.org/message-id/CAAu_hGsoB3drCJJaBhE73r3QtkmBhnA4hg-SDYb3GOBWt7y3sA%40mail.gmail.com>
Precedence: bulk

--0000000000001728670633610296
Content-Type: text/plain; charset="UTF-8"

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
>

--0000000000001728670633610296
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<p dir=3D"ltr">Thanks, I&#39;ll look into it.</p>
<br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=
=3D"gmail_attr">On Tue, Apr 22, 2025, 7:54 AM Laurenz Albe &lt;<a href=3D"m=
ailto:laurenz.albe@cybertec.at">laurenz.albe@cybertec.at</a>&gt; wrote:<br>=
</div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-l=
eft:1px #ccc solid;padding-left:1ex">On Tue, 2025-04-22 at 07:28 -0400, Yon=
gye Serkfem wrote:<br>
&gt; We are using Postgresql-15, ahd having issues importing foreign schema=
 with all<br>
&gt; its objects from an Oracle databse.=C2=A0Here is the error I am gettin=
g,<br>
&gt; &quot;error connecting=C2=A0to Oracle: OCIEnvCreate failed to create e=
nvironment handle: Detail: SQL state: HV00N<br>
&gt; I have installed oracle instantclient=C2=A019_24<br>
&gt; I would appreciate any help getting this resolved.=C2=A0<br>
<br>
This error usually indicated that you configured the Oracle Client wrongly.=
<br>
Usually, that is a question of setting environment variables wrong, but<br>
unfortunately it is a very generic error that Oracle throws when &quot;some=
thing<br>
is wrong&quot;.<br>
<br>
Your best bet is to research all the oracle_fdw issues that reported this<b=
r>
error.=C2=A0 Hopefully, one of these cases matches yours:<br>
<a href=3D"https://github.com/laurenz/oracle_fdw/issues?q=3Dis%3Aissue%20OC=
IEnvCreate" rel=3D"noreferrer noreferrer" target=3D"_blank">https://github.=
com/laurenz/oracle_fdw/issues?q=3Dis%3Aissue%20OCIEnvCreate</a><br>
<br>
Yours,<br>
Laurenz Albe<br>
</blockquote></div>

--0000000000001728670633610296--