Oracle 19 client driver for U1032

Hello,

My SLES 12.5 server has newly upgraded Oracle 19.0.0 client to connect to Oracle 19 DB server. after the installation my Uniface is giving Oracle client library error.
Earlier to this upgrade, i was using Oracle 12.2 client to connect to Oracle 19 DB and was using Uora7.1 in my asn files.

I tried 7.1, 7.2 and 7.3 drivers in my asn file

Anyone please assist?

Feature USRVORA does not expire

Checkout USRVORA: 1 (D)
Existence check: /ford/thishost/proj/gspas/1003/lib/libuora73.so is a file.
Could not load shared library /ford/thishost/proj/gspas/1003/lib/libuora73.so.
Dlerror: libclntsh.so.18.1: cannot open shared object file: No such file or directory

Thank you.

------------------------------
Venkat Nv
Ford Motor Company
Allen Park MI US
------------------------------

Hello Venkat

The Oracle connector U7.3 should be used.

I copy here part off insunis files I use here:

standard Oracle 19
LANG="en_US.UTF-8" ; export LANG
LC_CTYPE="en_US.UTF-8" ; export LC_CTYPE
ORACLE_HOME="/local/products/dbms/oracle1930"; export ORACLE_HOME
ORACLE_SID="sid"; export ORACLE_SID
LD_LIBRARY_PATH="`setpath.sh l $ORACLE_HOME/rdbms/lib $LD_LIBRARY_PATH`"; export LD_LIBRARY_PATH
LD_LIBRARY_PATH="`setpath.sh l $ORACLE_HOME/lib $LD_LIBRARY_PATH`"; export LD_LIBRARY_PATH
PATH="`setpath.sh l $ORACLE_HOME/bin $PATH`"; export PATH
NLS_LANG="AMERICAN_AMERICA.AL32UTF8"; export NLS_LANG

and in asn file
[DRIVER_SETTINGS]
ORA U7.3
;connector options
USYS$ORA_PARAMS = dhfr, open cursors 250

[PATHS]
$ORA ORA:|<dbuser>|<dbuserpwd>
;$ORA ORA:<hostname>:<portnumber (1521 is a standard port used by Oracle)>/<oracle_sid>|<dbuser>|<dbuserpwd>


Oracle instant client
LANG="en_US.UTF-8" ; export LANG
LC_CTYPE="en_US.UTF-8" ; export LC_CTYPE
ORACLE_HOME="/h/thelinuxuser/instantclient_21_1"; export ORACLE_HOME
LD_LIBRARY_PATH="`setpath.sh l $ORACLE_HOME $LD_LIBRARY_PATH`"; export LD_LIBRARY_PATH
PATH="`setpath.sh l $ORACLE_HOME $PATH`"; export PATH
NLS_LANG="AMERICAN_AMERICA.AL32UTF8"; export NLS_LANG

and in asn file
[DRIVER_SETTINGS]
ORA U7.3
;connector options
USYS$ORA_PARAMS = dhfr, open cursors 250

[PATHS]
$ORA ORA:<hostname>:<portnumber (1521 is a standard port used by Oracle)>/<oracle_sid>|<dbuser>|<dbuserpwd>

Peter Beugel
Principal Technical Support Engineer
Rocket Software B.V.

------------------------------
Peter Beugel
Rocket Internal - All Brands
Amsterdam NL
------------------------------

Hello Venkat

The Oracle connector U7.3 should be used.

I copy here part off insunis files I use here:

standard Oracle 19
LANG="en_US.UTF-8" ; export LANG
LC_CTYPE="en_US.UTF-8" ; export LC_CTYPE
ORACLE_HOME="/local/products/dbms/oracle1930"; export ORACLE_HOME
ORACLE_SID="sid"; export ORACLE_SID
LD_LIBRARY_PATH="`setpath.sh l $ORACLE_HOME/rdbms/lib $LD_LIBRARY_PATH`"; export LD_LIBRARY_PATH
LD_LIBRARY_PATH="`setpath.sh l $ORACLE_HOME/lib $LD_LIBRARY_PATH`"; export LD_LIBRARY_PATH
PATH="`setpath.sh l $ORACLE_HOME/bin $PATH`"; export PATH
NLS_LANG="AMERICAN_AMERICA.AL32UTF8"; export NLS_LANG

and in asn file
[DRIVER_SETTINGS]
ORA U7.3
;connector options
USYS$ORA_PARAMS = dhfr, open cursors 250

[PATHS]
$ORA ORA:|<dbuser>|<dbuserpwd>
;$ORA ORA:<hostname>:<portnumber (1521 is a standard port used by Oracle)>/<oracle_sid>|<dbuser>|<dbuserpwd>


Oracle instant client
LANG="en_US.UTF-8" ; export LANG
LC_CTYPE="en_US.UTF-8" ; export LC_CTYPE
ORACLE_HOME="/h/thelinuxuser/instantclient_21_1"; export ORACLE_HOME
LD_LIBRARY_PATH="`setpath.sh l $ORACLE_HOME $LD_LIBRARY_PATH`"; export LD_LIBRARY_PATH
PATH="`setpath.sh l $ORACLE_HOME $PATH`"; export PATH
NLS_LANG="AMERICAN_AMERICA.AL32UTF8"; export NLS_LANG

and in asn file
[DRIVER_SETTINGS]
ORA U7.3
;connector options
USYS$ORA_PARAMS = dhfr, open cursors 250

[PATHS]
$ORA ORA:<hostname>:<portnumber (1521 is a standard port used by Oracle)>/<oracle_sid>|<dbuser>|<dbuserpwd>

Peter Beugel
Principal Technical Support Engineer
Rocket Software B.V.

------------------------------
Peter Beugel
Rocket Internal - All Brands
Amsterdam NL
------------------------------

Hello Peter,

Thanks for the reply.

I changed the asn oracle params to look like this:

USYS$ORA_PARAMS =dhfr, open cursors 250
ORA = U7.3

I added the only line missing in my insunis 
LC_CTYPE="en_US.UTF-8" ; export LC_CTYPE

Am still getting the same error:

Existence check: /ford/thishost/proj/gspas/1003/lib/libuora73.so is a file.
Could not load shared library /ford/thishost/proj/gspas/1003/lib/libuora73.so.
Dlerror: libclntsh.so.18.1: cannot open shared object file: No such file or directory


Thank you.




------------------------------
Venkat Nv
Ford Motor Company
Allen Park MI US
------------------------------

Hello Peter,

Thanks for the reply.

I changed the asn oracle params to look like this:

USYS$ORA_PARAMS =dhfr, open cursors 250
ORA = U7.3

I added the only line missing in my insunis 
LC_CTYPE="en_US.UTF-8" ; export LC_CTYPE

Am still getting the same error:

Existence check: /ford/thishost/proj/gspas/1003/lib/libuora73.so is a file.
Could not load shared library /ford/thishost/proj/gspas/1003/lib/libuora73.so.
Dlerror: libclntsh.so.18.1: cannot open shared object file: No such file or directory


Thank you.




------------------------------
Venkat Nv
Ford Motor Company
Allen Park MI US
------------------------------

Hello Venkat NV

You could look with strace:
An userver.sh in /ford/thishost/proj/gspas/1003/common/project containing something like this 
#!/bin/ksh
.  /ford/thishost/proj/gspas/1003/adm/insunis
FICTRACE=/ford/thishost/proj/gspas/1003/log/straceuserver`date +%H%M%S`.log
/usr/bin/strace -f -r -T -o ${FICTRACE} /ford/thishost/proj/gspas/1003/common/bin/userver $*

and in urouter.asn something like this
sh =/ford/thishost/proj/gspas/1003/common/project/userver.sh -dir=/ford/thishost/proj/gspas/1003/common/project -adm=/ford/thishost/proj/gspas/1003/uniface/adm



If this still does not help to find the problem it is better to open a case for this via our portal.

Best regards
Peter Beugel
Principal Technical Support Engineer
Rocket Software B.V.

------------------------------
Peter Beugel
Rocket Internal - All Brands
Amsterdam NL
------------------------------

Hello Venkat NV

You could look with strace:
An userver.sh in /ford/thishost/proj/gspas/1003/common/project containing something like this 
#!/bin/ksh
.  /ford/thishost/proj/gspas/1003/adm/insunis
FICTRACE=/ford/thishost/proj/gspas/1003/log/straceuserver`date +%H%M%S`.log
/usr/bin/strace -f -r -T -o ${FICTRACE} /ford/thishost/proj/gspas/1003/common/bin/userver $*

and in urouter.asn something like this
sh =/ford/thishost/proj/gspas/1003/common/project/userver.sh -dir=/ford/thishost/proj/gspas/1003/common/project -adm=/ford/thishost/proj/gspas/1003/uniface/adm



If this still does not help to find the problem it is better to open a case for this via our portal.

Best regards
Peter Beugel
Principal Technical Support Engineer
Rocket Software B.V.

------------------------------
Peter Beugel
Rocket Internal - All Brands
Amsterdam NL
------------------------------

Hello Peter,

Thank you. I have raised a new case with Uniface support.




------------------------------
Venkat Nv
Ford Motor Company
Allen Park MI US
------------------------------