Message-ID: <76bb8214bcb3a4164b2d99c65982848f1e5d8a0d.camel@cybertec.at>
Subject: Re: Oracle_fdw
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Yongye Serkfem <yserkfem@gmail.com>, "pgsql-generallists.postgresql.org"
	 <pgsql-general@lists.postgresql.org>
Date: Tue, 22 Apr 2025 13:54:44 +0200
In-Reply-To: <CAAu_hGs2hGk8M4+1QO=6mK+nEHR0HHc49RciADRBAWmsqgFDpw@mail.gmail.com>
References: 
	<CAAu_hGs2hGk8M4+1QO=6mK+nEHR0HHc49RciADRBAWmsqgFDpw@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/76bb8214bcb3a4164b2d99c65982848f1e5d8a0d.camel%40cybertec.at>
Precedence: bulk

On Tue, 2025-04-22 at 07:28 -0400, Yongye Serkfem wrote:
> We are using Postgresql-15, ahd having issues importing foreign schema wi=
th all
> its objects from an Oracle databse.=C2=A0Here is the error I am getting,
> "error connecting=C2=A0to Oracle: OCIEnvCreate failed to create environme=
nt handle: Detail: SQL state: HV00N
> I have installed oracle instantclient=C2=A019_24
> I would appreciate any help getting this resolved.=C2=A0

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=3Dis%3Aissue%20OCIEnvCreate

Yours,
Laurenz Albe