Oracle client library (oci.dll) not found - Oracle Fdw about oracle_fdw HOT 29 CLOSED

What version of oracle_fdw are you using?
How exactly do you start the PostgreSQL server?

Since you are speaking of oci.dll, I assume that your PostgreSQL server is running on Windows. But then you need to install Oracle client on that Windows machine too, not on some Linux machine.

from oracle_fdw.

Oracle and PostgreSQL server should be install on same server?
Currently Oracle running on Linux server. Is it Possible to install oracle client on windows without affecting running system.

I am using oracle_fdw--1.2.sql

from oracle_fdw.

The Oracle client needs to be installed on the machine where the PostgreSQL server is.
The Oracle server can be anywhere, as long as you can get a network connection.

1.2 is the extension version, but what is the version of oracle_fdw?

from oracle_fdw.

How to check version of oracle_fdw?

from oracle_fdw.

I want to install freshly for all configuration. Could pls share the steps by steps manual for postgresql 11 to oracle 19.0?

from oracle_fdw.

If you can't get oracle_fdw to run yet, the easiest way to find the version (if you don't remember what you downloaded) is to look at orscle_fdw.h. The version is in the macro ORACLE_FDW_VERSION.

The installation steps are in the documentation.

from oracle_fdw.

I want to remove all the files which i copied from downloaded files. after that, i will install newly all files. could you please share the download link which version suitable for Oracle 19 c and postgresql 11

from oracle_fdw.

You can use the latest development version or the latest released version.

from oracle_fdw.

Building oracle_fdw on Windows:
below comment was not working.
msbuild oracle_fdw.sln /p:Configuration=(Debug or Release) ^
/p:Platform=(Win32 or x64) ^
/p:OracleClient=(path to Oracle Client/SDK) ^
/p:PostgreSQL=(path to PostgreSQL installation)

Could pls provide parameter with details?

from oracle_fdw.

In downloaded file i found msvc folder. what is that and where to copy those files?

from oracle_fdw.

Do you have Microsoft's Visual Studio C compiler installed? Otherwise, it won't work.

The alternative is to install the Mingw development environment and use the GNU C compiler.

If the mention of a compiler confuses you, I'm afraid you will have problems installing oracle_fdw, because it has to be compiled from source.

from oracle_fdw.

i have installed Program Files\Microsoft Visual Studio\2022\Community edition.

after that i have tried, below comment. it was not working.
below comment was not working.
msbuild oracle_fdw.sln /p:Configuration=(Debug or Release) ^
/p:Platform=(Win32 or x64) ^
/p:OracleClient=(path to Oracle Client/SDK) ^
/p:PostgreSQL=(path to PostgreSQL installation)
Could you tell me what configuration need in the Microsoft Visual Studio\2022\Community edition.

from oracle_fdw.

Try following the documentation.
Disclaimer: I don't have any Windows system within reach.

from oracle_fdw.

Hi,
@SGopishan It seems your databases run on Linux for Oracle and it's a good practice.
Even if you manage to make things work in this particular case, on a long term perspective, I suggest you to also install PostgreSQL on Linux.
The disclaimer "I don't have any Windows system within reach." is very common among PostgreSQL hackers and experts and the best support, community or commercial, will be with Linux.
Windows is somehow an exotic platform for PostgreSQL, as it is for Oracle.
Best regards,
Phil

from oracle_fdw.

PostgreSQL on Linux installation : i cannot install same oracle running server. can i create new linux server and install postgres?
I have two server Windows for development and linux for production. (postgres)

from oracle_fdw.

It was just a general advice. Windows is an official platform for PostgreSQL and it has been native since version 8 (2005). But I noticed it's still an exotic platform on some aspects, especially if you plan to use third-party tools or extensions like oracle-fdw.
Hence it's up to you to build a new Linux dev server but if your production runs on a Linux server for Postgres, it would be interesting/logical to have your dev & tests also on a Linux server for Postgres. Don't mix Oracle database & PostgreSQL database on the same server but run everything on Linux.

from oracle_fdw.

If i have Linux separate server for postgres. Shall i need to install oracle client on the same postgres server?

from oracle_fdw.

Yes and you don't need a full client for oracle-fdw. You need an Oracle Instant Client which is freely available and easy to install : https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html
It's documented on the main page of this git repo.

from oracle_fdw.

Could please support on this oracle_fdw integration remotely?

from oracle_fdw.

I think that it is perfectly fine to use oracle_fdw on Windows.
Only building is a bit more difficult, the rest should be just as simple.

from oracle_fdw.

I can do that, but that would be commercial support - you can contact my company Cybertec.

from oracle_fdw.

@laurenz Yes I agree it's not that complicated perhaps I should not have given this advice... That said I really think it's a better idea to run PostgreSQL on Linux in terms of support. At some point tools like Barman had no Windows port for example. You often have a specific Windows section etc.

from oracle_fdw.

I do agree that the PostgreSQL experience is better on Linux.

from oracle_fdw.

from oracle_fdw.

Please write to [email protected] and ask them for a pool over two hours of consulting.

from oracle_fdw.

I have requested could pls check with your team and let me know.

from oracle_fdw.

We haven't heard back from you. Shall I close this issue?

from oracle_fdw.

from oracle_fdw.

We could install the extension in an interactive session. These were the steps we had to perform:

• install Oracle Instantclient 19.22
• reinstall VisualStudio, as the installation was messed up somehow
• update PostgreSQL v11 to 11.22, because an API break in PostgreSQL 11.11 made earlier minor releases unusable

Then we could open the "development command prompt" of VisualStudio, change to the msvc subdirectory of oracle_fdw and build with msbuild according to the documentation.

from oracle_fdw.