Uniface User Forum

 View Only

  • 1.  Oracle 19 client driver for U1032

    Posted 02-14-2022 17:48
    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
    ------------------------------


  • 2.  RE: Oracle 19 client driver for U1032

    ROCKETEER
    Posted 02-15-2022 08:12
    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
    ------------------------------

    Original Message


  • 3.  RE: Oracle 19 client driver for U1032

    Posted 02-15-2022 09:45
    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
    ------------------------------

    Original Message


  • 4.  RE: Oracle 19 client driver for U1032

    ROCKETEER
    Posted 02-15-2022 10:43
    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
    ------------------------------

    Original Message


  • 5.  RE: Oracle 19 client driver for U1032

    Posted 02-15-2022 16:05
    Hello Peter,

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




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

    Original Message