public inbox for [email protected]  

help / color / mirror / Atom feed

From: Yongye Serkfem <[email protected]>
To: Laurenz Albe <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Oracle_fdw
Date: Tue, 22 Apr 2025 13:06:28 -0400
Message-ID: <CAAu_hGsoB3drCJJaBhE73r3QtkmBhnA4hg-SDYb3GOBWt7y3sA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAAu_hGs2hGk8M4+1QO=6mK+nEHR0HHc49RciADRBAWmsqgFDpw@mail.gmail.com>
	<[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
>

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Oracle_fdw
  In-Reply-To: <CAAu_hGsoB3drCJJaBhE73r3QtkmBhnA4hg-SDYb3GOBWt7y3sA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox