Problem in installing Orafce extension

[Somanath Narayan]

Hi Team,

We are unable to install orafce extension in postgres:15 docker images with
alpine 3.17.

Get following error
[image: image]

We had copied orafce--4.3.sql & orafce.control files into the docker
container instance under the path 'user/local/share/postgresql/extension'



Can you please help to install the orafce extension ?

[Pavel Stehule]

Hi

I am sorry

I am not able to read your screenshots

Please, paste error message as text

regards

Pavel

[Somanath Narayan]

Hi Pavel

This is the error message

ERROR: could not access file "$libdir/orafce: No such file or directory".

//Thank you

Somanath Narayan

[Somanath Narayan]

Hi Pavel,

We are unable to install orafce extension in postgres:15 docker images with
alpine 3.17.

Getting error as shown in attachment - Extension_error.png

We had copied orafce--4.3.sql & orafce.control files into the docker
container instance under the path 'user/local/share/postgresql/extension'

Shown in attachment - orafce_extension.png

Let me know if you need more info.

//Thank you 

Somanath Narayan

On Wednesday, May 17, 2023 at 12:25:25 PM UTC Pavel Stehule wrote:

[Pavel Stehule]

st 17. 5. 2023 v 15:52 odesílatel Somanath Narayan <somanath...@gmail.com> napsal:

Hi Pavel,

We are unable to install orafce extension in postgres:15 docker images with
alpine 3.17.

Getting error as shown in attachment - Extension_error.png

We had copied orafce--4.3.sql & orafce.control files into the docker
container instance under the path 'user/local/share/postgresql/extension'

Shown in attachment - orafce_extension.png

you need orafce.dll too. And this library should compiled for your mayor version Postgres. So you cannot to use orafce.dll compiled for Postgres 10 if you use Postgres 11.

 

Let me know if you need more info.

//Thank you 

Somanath Narayan

On Wednesday, May 17, 2023 at 12:25:25 PM UTC Pavel Stehule wrote:

Hi

I am sorry

I am not able to read your screenshots

Please, paste error message as text

regards

Pavel

--
You received this message because you are subscribed to the Google Groups "Better Oracle functions support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orafce-genera...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/9145f083-2f86-4429-a432-a24be4e5f2b4n%40googlegroups.com.

[Somanath Narayan]

Hi Pavel,

Our underlying operating system is linux not windows, 

not sure we can bring orafce.dll here. Do we have reference document?