Page tree
Skip to end of metadata
Go to start of metadata

SAP Sybase Product Support created this combination to workaround the following SAP Sybase CR's . . . this combination has NOT been tested by SAP Sybase QA or Engineering . . . this should be used at one's own risk
       KBA 2642152 - After upgrading to Direct Connect 15.7 SP5, encountered error 16008

              CR 814679 OCS 2018/04/20 memory leak in srv__token_readparamfmt() for srv_dynamic(), when client does not use paramfmt suppression

       KBA 2180163 - No reponse to login requests when TraceOpenServer is greater than 0, such as 59, used for most Open Server tracing - ECDA
              CR 810204 OCS 2017/08/15 Open Server hangs when TraceOpenServer is set to 59 . . . fixed in OCS 15.7 sp140


cross reference the following wiki's also
         1) configure rhel 6.x, 7.x to use old convention . . . eth0 . . . associated with network
         2) Install 32bit ODBC 2.3.6 on redhat rhel 7.4 linux for use with SAP Sybase ECDA 15.7sp5
         3) Install 32bit FreeTDS linux odbc driver on redhat rhel 7.4 for use with SAP Sybase ECDA 15.7sp5

A)  download 32bit Open Server 15.7sp140[2018] from support.sap.com
B)  install OPENSERVER1570140_0-11013471.TGZ
C)  mv present /sy/e3x157sp5/DC-15_0/connectivity/* . . . to . . . /sy/e3x157sp5/DC-15_0/connectivity/hold_orig_OCS-15_0
D)  cp /ii/sy/os157sp140__ii/installed/* items . . . to . . . /sy/e3x157sp5/DC-15_0/connectivity
E)  cp /sy/e3x157sp5/DC-15_0/connectivity/hold_orig_OCS-15_0/locales/unicode/econnect
F)  cp /sy/e3x157sp5/DC-15_0/connectivity/hold_orig_OCS-15_0/locales/us_english
G)  start ECDA server
H)  login and expose upgraded OPEN SERVER layer

A)  download 32bit Open Server 15.7sp140[2018] from support.sap.com
       support.sap.com
          https://support.sap.com/en/index.html
             download software
                by alpha
                   O
                      filter
                         SAP OPEN SERVER
                            SAP OPEN SERVER 15.7
                               Support Packages and Patches (blue button . . . upper right corner)
                                  DOWNLOADS
                                     LINUX ON IA32 32BIT
                                        Name                               File Size   Release Date
                                        OPENSERVER1570140_0-11013471.TGZ   236967 KB   02.06.2018
                                        15.7 SP140 OpenServer

B)  install OPENSERVER1570140_0-11013471.TGZ
       from . . . /ii/sy/os157sp140__ii/OPENSERVER1570140_0-11013471_TGZ/uzpd/ebf27121
       to   . . . /ii/sy/os157sp140__ii/installed
          login as: uid
          uid@<host>.wbu.sap.corp's password:
          Last login: Sun Jun 17 19:05:51 2018
          tcsh:uid@<host>:/> cd /ii/sy/os157sp140__ii
          tcsh:uid@<host>:/ii/sy/os157sp140__ii> ls -al
          total 232024
          drwxr-xr-x. 2 uid   uid          46 Jun 17 12:02 .
          drwxr-xr-x. 9 uid   uid         142 Jun 17 12:02 ..
          -rw-r--r--. 1 uid   uid   237590207 Jun 17 11:56 OPENSERVER1570140_0-11013471.TGZ
          tcsh:uid@<host>:/ii/sy/os157sp140__ii> mkdir OPENSERVER1570140_0-11013471_TGZ
          tcsh:uid@<host>:/ii/sy/os157sp140__ii> mv ./OPENSERVER1570140_0-11013471.TGZ ./OPENSERVER1570140_0-11013471_TGZ
          tcsh:uid@<host>:/ii/sy/os157sp140__ii> cd ./OPENSERVER1570140_0-11013471_TGZ
          tcsh:uid@<host>:/ii/sy/os157sp140__ii/OPENSERVER1570140_0-11013471_TGZ> ls -alrt
          total 232024
          -rw-r--r--. 1 uid uid 237590207 Jun 17 11:56 OPENSERVER1570140_0-11013471.TGZ
          drwxr-xr-x. 3 uid uid        46 Jun 17 12:08 ..
          drwxrwxr-x. 2 uid uid        46 Jun 17 12:08 .
          tcsh:uid@<host>:/ii/sy/os157sp140__ii/OPENSERVER1570140_0-11013471_TGZ> mkdir uzpd
          tcsh:uid@<host>:/ii/sy/os157sp140__ii/OPENSERVER1570140_0-11013471_TGZ> cd uzpd
          tcsh:uid@<host>:/ii/sy/os157sp140__ii/OPENSERVER1570140_0-11013471_TGZ/uzpd> tar xvf ../OPENSERVER1570140_0-11013471.TGZ
          ebf28004/
          ebf28004/ThirdPartyLegal/
          ebf28004/ThirdPartyLegal/FreeDownloadComponentList.CSI.2.9.pdf
          ebf28004/ThirdPartyLegal/FreeDownloadComponentList.OpenServer.15.7.SP120.pdf

          * * * removed   27 similar lines for readability * * *

          ebf28004/archives/manifest.mf
          ebf28004/archives/version.txt
          ebf28004/sample_response.txt
          ebf28004/setup.bin
          tcsh:uid@<host>:/ii/sy/os157sp140__ii/OPENSERVER1570140_0-11013471_TGZ/uzpd>
          tcsh:uid@<host>:/ii/sy/os157sp140__ii/OPENSERVER1570140_0-11013471_TGZ/uzpd> cd /ii/sy/os157sp140__ii/OPENSERVER1570140_0-11013471_TGZ/uzpd/ebf28004
          tcsh:uid@<host>:/ii/sy/os157sp140__ii/OPENSERVER1570140_0-11013471_TGZ/uzpd/ebf28004> ./setup.bin

          * * * removed    5 similar lines for readability * * *

          Preparing to install

          * * * removed  101 similar lines for readability * * *

          InstallAnywhere will guide you through the installation of Sybase Open Server
          15.7 SP140.

          * * * removed   90 similar lines for readability * * *

          ENTER AN ABSOLUTE PATH, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
                : /ii/sy/os157sp140__ii/installed

          * * * removed   88 similar lines for readability * * *

          Installation Complete
          ---------------------
          Congratulations. Sybase Open Server has been successfully installed to:         
             /ii/sy/os157sp140__ii/installed
          PRESS <ENTER> TO EXIT THE INSTALLER:
          tcsh:uid@<host>:/ii/sy/os157sp140__ii/OPENSERVER1570140_0-11013471_TGZ/uzpd/ebf28004>

C)  mv present /sy/e3x157sp5/DC-15_0/connectivity/* . . . to . . . /sy/e3x157sp5/DC-15_0/connectivity/hold_orig_OCS-15_0
        tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity> mkdir hold_orig_OCS-15_0
        tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity> cd ./hold_orig_OCS-15_0
        tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity/hold_orig_OCS-15_0> mv ../charsets .
        tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity/hold_orig_OCS-15_0> mv ../collate .
        tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity/hold_orig_OCS-15_0> mv ../config .
        tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity/hold_orig_OCS-15_0> mv ../locales .
        tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity/hold_orig_OCS-15_0> mv ../OCS-15_0 .
        tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity/hold_orig_OCS-15_0> cd ..
        tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity> ls -al
        total 4
        drwxrwxr-x.  3 uid    uid      72 Apr 12 12:24 .
        drwxrwxr-x. 21 uid    uid    4096 Mar 22 17:07 ..
        drwxrwxr-x.  7 uid    uid      82 Apr 12 12:24 hold_orig_OCS-15_0
        lrwxrwxrwx.  1 uid    uid      51 Mar 22 17:07 interfaces -> /sy/e3x157sp5/DC-15_0/connectivity/../../interfaces
        -rw-r--r--.  1 uid    uid       0 Jan 22 17:09 interfaces.bak
        tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity>

D)  cp /ii/sy/os157sp140__ii/installed/* items . . . to . . . /sy/e3x157sp5/DC-15_0/connectivity
        tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity> cp -R /ii/sy/os157sp140__ii/installed/charsets .
        tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity> cp -R /ii/sy/os157sp140__ii/installed/config .
        tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity> cp -R /ii/sy/os157sp140__ii/installed/locales .
        tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity> cp -R /ii/sy/os157sp140__ii/installed/OCS-15_0 .
        tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity> ls -alrt
        total 8
        lrwxrwxrwx.  1 uid    uid      51 Mar 22 17:07 interfaces.bak -> /sy/e3x157sp5/DC-15_0/connectivity/../../interfaces
        drwxrwxr-x. 21 uid    uid    4096 Mar 22 17:07 ..
        drwxrwxr-x.  7 uid    uid      82 Apr 12 12:24 hold_orig_OCS-15_0
        lrwxrwxrwx.  1 uid    uid      51 May  2 16:40 interfaces -> /sy/e3x157sp5/DC-15_0/connectivity/../../interfaces
        drwxrwxr-x. 59 uid    uid    4096 Jun 17 17:42 charsets
        drwxrwxr-x.  2 uid    uid      65 Jun 17 17:42 config
        drwxrwxr-x.  4 uid    uid      55 Jun 17 17:42 locales
        drwxrwxr-x.  7 uid    uid     133 Jun 17 17:42 .
        drwxrwxr-x. 14 uid    uid     187 Jun 17 17:42 OCS-15_0
        tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity>

E)  cp /sy/e3x157sp5/DC-15_0/connectivity/hold_orig_OCS-15_0/locales/unicode/econnect
       . . . to . . .
       /sy/e3x157sp5/DC-15_0/connectivity/hold_orig_OCS-15_0/locales/unicode
                tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity/locales> cd unicode
                tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity/locales/unicode> cp -R /sy/e3x157sp5/DC-15_0/connectivity/hold_orig_OCS-15_0/locales/unicode/econnect .

F)  cp /sy/e3x157sp5/DC-15_0/connectivity/hold_orig_OCS-15_0/locales/us_english
       . . . to . . .
       /sy/e3x157sp5/DC-15_0/connectivity/locales
                tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity/locales/unicode> cd ..
                tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity/locales> cp -R /sy/e3x157sp5/DC-15_0/connectivity/hold_orig_OCS-15_0/locales/us_english .
                tcsh:uid@<host>:/sy/e3x157sp5/DC-15_0/connectivity/locales>

G)  start ECDA server
        tcsh:uid@<host>:/sy/e3x157sp5> ./ss
        tcsh:uid@<host>:/sy/e3x157sp5> ./rs__ecda__2.3.6
        [1] 10634
        tcsh:uid@<host>:/sy/e3x157sp5> ./ss
        uid      10634     1  1 17:45 pts/1    00:00:00 /sy/e3x157sp5/DC-15_0/connectivity/../bin/direct -Se3x157sp5bw
        uid      10635 10634  0 17:45 pts/1    00:00:00 directc -R3 -W4
        tcsh:uid@<host>:/sy/e3x157sp5>

H)  login and expose upgraded OPEN SERVER layer
        OPEN SERVER VERSION   Sybase Server-Library/15.7/P-EBF28004-27990 SP140/DRV.15.7.0.14/Linux Intel/Linux 2.6.18-128.el5 i686 Native Threads/BUILD1570-054/OPT/Wed May  9 06:45:15 2018
        ******************************************************************************************
        isql -S<ecda_srvcenm> -Usy -P<pwd> -w2048 -Dsndbx
        select @@version
        go
        exec sp_helpserver
        go
        select @@sqldbmsname
        go
        select @@sqldbmsver
        go
        select @@sqldrivername
        go
        select @@sqldriverver
        go
        exec master..atatversion
        go
        quit
        ******************************************************************************************
                ******************************************************************************************
                c:\x\sy_sdk6_157e7\OCS-15_0\bin>isql -S<ecda_srvcenm> -Usy -P<pwd> -w2048 -Dsndbx
 (0 rows affected)
 1> select @@version
 2> go
  Version
  -----------------------------------------------------------------------------------------------------------------------
  DirectConnect for DCANY/15.7 SP05/P-EBF25402/INTEL i686/Linux Red Hat 2.4.21-27.0.2.ELsmp/015/OPT/Nov  2 2015 01:00:11
 (1 row affected)
 1> exec sp_helpserver
 2> go
                SERVER_PROPERTY                  PROPERTY_VALUE
                -------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------
                SERVICENAME                      <ecda_srvcenm>
                OPEN SERVER VERSION              Sybase Server-Library/15.7/P-EBF28004-27990 SP140/DRV.15.7.0.14/Linux Intel/Linux 2.6.18-128.el5 i686 Native Threads/BUILD1570-054/OPT/Wed May  9 06:45:15 2018
                SERVICE MANAGER VERSION          DirectConnect Service Manager/15.7 SP05/P-EBF25402/INTEL i686/Linux Red Hat 2.4.21-27.0.2.ELsmp/015/OPT/Nov  2 2015 01:00:11
                ACCESS SERVICE LIBRARY VERSION   DirectConnect Anywhere Access Service/15.7 SP05/P-EBF25402/INTEL i686/Linux Red Hat 2.4.21-27.0.2.ELsmp/015/OPT/Nov  2 2015 01:03:48
                TARGET VERSION                   DirectConnect 13.00.4001
                (5 rows affected)
                1> select @@sqldbmsname
                2> go
                SQLDbmsName
                ---------------------
                Microsoft SQL Server
                (1 row affected)
                1> select @@sqldbmsver
                2> go
                SQLDbmsVer
                -----------
                13.00.4001
                (1 row affected)
                1> select @@sqldrivername
                2> go
                SQLDriverName
                --------------
                libtdsodbc.so
                (1 row affected)
                1> select @@sqldriverver
                2> go
                SQLDriverVer
                ------------
                01.00.0083
                (1 row affected)
                1> exec master..atatversion
                2> go
                expression 1
                ---------------------------------------------------------------------------------------------------------
                Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64)
                Oct 28 2016 18:17:30
                Copyright (c) Microsoft Corporation
                Standard Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor)
                (1 row affected)
                1> quit
                c:\x\sy_sdk6_157e7\OCS-15_0\bin>
                ******************************************************************************************

 author:  MALCOLM B WEAVER JR

  • No labels