MAKE lib linking issues about oracle_fdw HOT 3 CLOSED

The README says:

You need to install Oracle's C header files as well (SDK package for Instant
Client).

So that would have saved you from your first problem.
I had no mention of your second problem, but it is frequent enough that I updated the documentation:

PostgreSQL and Oracle need to have the same architecture, for example you
cannot have 32-bit software for the one and 64-bit software for the other.

Now that you have installed 64-bit Oracle, everything should work.
What is the error message you get?
I recommend that you uninstall the 32-bit Oracle Instant Client before trying, as it is all too easy to get confused with different Oracle installations on the same maching.

from oracle_fdw.

Thanks for the reply.

I made the beginner's mistake of thinking that Instantclient_64 meant that the client was 64-bit.
Here's my solution:

1. I re-installed instantclient and sdk from the Oracle site, being careful to grab the 64-bit versions.
2. I added sym links to /usr/lib for libclntsh.dylib and libclntsh.dylib.11.1 to /usr/lib/
3. Added the new paths to my DYLD_LIBRARY_PATH and my LD_LIBRARY_PATH env variables in my .profile.
4. Closed and re-opened all terminal sessions just to be sure that my environment was being defined by my .profile settings.
5. Restarted Postgres and followed the rest of your README install instructions, and was able to install the extension.

I'm very close. But not yet able to talk to the Oracle server. At this point I get the ORA-12154 error. I will call this question closed, and open another for that issue.

Thanks.
R

from oracle_fdw.

Ok, thanks for the feedback.

from oracle_fdw.