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
------------------------------
Page 1 / 1
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
------------------------------
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
------------------------------
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
------------------------------
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
------------------------------
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
------------------------------
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
------------------------------
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
------------------------------
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
------------------------------
Thank you. I have raised a new case with Uniface support.
------------------------------
Venkat Nv
Ford Motor Company
Allen Park MI US
------------------------------
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
