orafce bug issue

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

orafce bug issue

Prakash Ramakrishnan-2

Hi Team ,
  
while we are creating the orafce extension getting below error.

AIBE01PR=# create extension orafce;
ERROR:  could not load library "/usr/pgsql-11/lib/orafce.so": /usr/pgsql-11/lib/orafce.so: undefined symbol: DatumGetFloat4
AIBE01PR=#


==> ls
adminpack.so         dict_xsyn.so         jsonb_plpython2.so      libpgtypes.so.3      passwordcheck.so       pltcl.so            utf8_and_cyrillic.so
amcheck.so           earthdistance.so     latin2_and_win1250.so   libpgtypes.so.3.11   pg_buffercache.so      postgres_fdw.so     utf8_and_euc2004.so
ascii_and_mic.so     euc2004_sjis2004.so  latin_and_mic.so        libpq.a              pgcrypto.so            refint.so           utf8_and_euc_cn.so
auth_delay.so        euc_cn_and_mic.so    libecpg.a               libpq.so             pg_freespacemap.so     seg.so              utf8_and_euc_jp.so
auto_explain.so      euc_jp_and_sjis.so   libecpg_compat.a        libpq.so.5           pg_hint_plan.so        sepgsql.so          utf8_and_euc_kr.so
autoinc.so           euc_kr_and_mic.so    libecpg_compat.so       libpq.so.5.11        pgoutput.so            sslinfo.so          utf8_and_euc_tw.so
bitcode              euc_tw_and_big5.so   libecpg_compat.so.3     libpqwalreceiver.so  pg_prewarm.so          tablefunc.so        utf8_and_gb18030.so
bloom.so             file_fdw.so          libecpg_compat.so.3.11  llvmjit.so           pgrowlocks.so          tcn.so              utf8_and_gbk.so
btree_gin.so         fuzzystrmatch.so     libecpg.so              llvmjit_types.bc     pg_stat_statements.so  tds_fdw.so          utf8_and_iso8859_1.so
btree_gist.so        hstore_plperl.so     libecpg.so.6            lo.so                pgstattuple.so         test_decoding.so    utf8_and_iso8859.so
citext.so            hstore_plpython2.so  libecpg.so.6.11         ltree_plpython2.so   pg_trgm.so             timetravel.so       utf8_and_johab.so
cube.so              hstore.so            libpgcommon.a           ltree.so             pg_visibility.so       tsm_system_rows.so  utf8_and_sjis2004.so
cyrillic_and_mic.so  insert_username.so   libpgfeutils.a          moddatetime.so       pgxml.so               tsm_system_time.so  utf8_and_sjis.so
dblink.so            _int.so              libpgport.a             oracle_fdw.so        pgxs                   unaccent.so         utf8_and_uhc.so
dict_int.so          isn.so               libpgtypes.a            orafce.so            pkgconfig              utf8_and_ascii.so   utf8_and_win.so
dict_snowball.so     jsonb_plperl.so      libpgtypes.so           pageinspect.so       plpgsql.so             utf8_and_big5.so    uuid-ossp.so
[hidden email]:/usr/pgsql-11/lib


--



Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : +91-8939599426
Reply | Threaded
Open this post in threaded view
|

Re: orafce bug issue

Tom Lane-2
Prakash Ramakrishnan <[hidden email]> writes:
> while we are creating the orafce extension getting below error.
> AIBE01PR=# create extension orafce;
> ERROR:  could not load library "/usr/pgsql-11/lib/orafce.so":
> /usr/pgsql-11/lib/orafce.so: undefined symbol: DatumGetFloat4

Perhaps that extension was compiled against some old version of
Postgres (probably 9.6 or earlier)?  Ideally you'd get a version
incompatibility complaint first ... but unfortunately if the dynamic
linker is unhappy, that's going to come out before we can find out
what version the .so is for.

                        regards, tom lane


Reply | Threaded
Open this post in threaded view
|

Re: orafce bug issue

Prakash Ramakrishnan-2
Hi Tom,

Thanks for the update and please let me know how can we check the version and incompatibility.

 orafce             | 3.8           | public     | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS  for another one server i created successfully this time only getting error for other server.

regards, prakash. 



On Thu, May 2, 2019 at 7:49 PM Tom Lane <[hidden email]> wrote:
Prakash Ramakrishnan <[hidden email]> writes:
> while we are creating the orafce extension getting below error.
> AIBE01PR=# create extension orafce;
> ERROR:  could not load library "/usr/pgsql-11/lib/orafce.so":
> /usr/pgsql-11/lib/orafce.so: undefined symbol: DatumGetFloat4

Perhaps that extension was compiled against some old version of
Postgres (probably 9.6 or earlier)?  Ideally you'd get a version
incompatibility complaint first ... but unfortunately if the dynamic
linker is unhappy, that's going to come out before we can find out
what version the .so is for.

                        regards, tom lane


--



Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : +91-8939599426
Reply | Threaded
Open this post in threaded view
|

Re: orafce bug issue

Pavel Stehule


čt 2. 5. 2019 v 16:53 odesílatel Prakash Ramakrishnan <[hidden email]> napsal:
Hi Tom,

Thanks for the update and please let me know how can we check the version and incompatibility.

 orafce             | 3.8           | public     | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS  for another one server i created successfully this time only getting error for other server.

Orafce 3.8 is fresh, but nobody knows from this number for what version of Postgres this dll was compiled.

If you want Orafce, you have to find package that support Postgres that you use - or compile Orafce from source files against dev files of PostgreSQL that you use.

Regards

Pavel Stehule




regards, prakash. 



On Thu, May 2, 2019 at 7:49 PM Tom Lane <[hidden email]> wrote:
Prakash Ramakrishnan <[hidden email]> writes:
> while we are creating the orafce extension getting below error.
> AIBE01PR=# create extension orafce;
> ERROR:  could not load library "/usr/pgsql-11/lib/orafce.so":
> /usr/pgsql-11/lib/orafce.so: undefined symbol: DatumGetFloat4

Perhaps that extension was compiled against some old version of
Postgres (probably 9.6 or earlier)?  Ideally you'd get a version
incompatibility complaint first ... but unfortunately if the dynamic
linker is unhappy, that's going to come out before we can find out
what version the .so is for.

                        regards, tom lane


--



Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : +91-8939599426
Reply | Threaded
Open this post in threaded view
|

Re: orafce bug issue

Prakash Ramakrishnan-2
Hi Pavel and tom,

Thanks for your support now am able to create the extesnion.

Regards,
Prakash.r

On Thu, May 2, 2019 at 11:15 PM Pavel Stehule <[hidden email]> wrote:


čt 2. 5. 2019 v 16:53 odesílatel Prakash Ramakrishnan <[hidden email]> napsal:
Hi Tom,

Thanks for the update and please let me know how can we check the version and incompatibility.

 orafce             | 3.8           | public     | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS  for another one server i created successfully this time only getting error for other server.

Orafce 3.8 is fresh, but nobody knows from this number for what version of Postgres this dll was compiled.

If you want Orafce, you have to find package that support Postgres that you use - or compile Orafce from source files against dev files of PostgreSQL that you use.

Regards

Pavel Stehule




regards, prakash. 



On Thu, May 2, 2019 at 7:49 PM Tom Lane <[hidden email]> wrote:
Prakash Ramakrishnan <[hidden email]> writes:
> while we are creating the orafce extension getting below error.
> AIBE01PR=# create extension orafce;
> ERROR:  could not load library "/usr/pgsql-11/lib/orafce.so":
> /usr/pgsql-11/lib/orafce.so: undefined symbol: DatumGetFloat4

Perhaps that extension was compiled against some old version of
Postgres (probably 9.6 or earlier)?  Ideally you'd get a version
incompatibility complaint first ... but unfortunately if the dynamic
linker is unhappy, that's going to come out before we can find out
what version the .so is for.

                        regards, tom lane


--



Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : +91-8939599426


--



Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : +91-8939599426