SAP Sybase Database ASE Installation steps on Linux


Summary :-


This document contains the steps that how to install SAP Sybase ASE on Linux. I have gone through many SAP SCN link and created this documents.


About SAP ASE :


SAP Adaptive Server® Enterprise 15.7 is a high-performance relational database management system for mission-critical, data-intensive environments.It ensures highest operational efficiency and throughput on a broad range of platforms.

SAP ASE Sybase recommends that you use the GUI wizard to install Adaptive Server.

Table of Contents :-

1) SAP ASE Sysbase Architecture

2) Hardware Requirements

3) Software & Installation

1) SAP  ASE 15.7 Sybase Architecture

Capture.PNG

ASE 15.7 – Virtual Server Architecture (VSA)

Capture22.PNG



2) Hardware Requirements & Operating system


Operating system requirements for Linux
Hardware Operating system RAM
x86_64 processor (Intel Xeon with EM64T) Red Hat Enterprise Linux Server release 6.0 (Santiago) • kernel-2.6.32-71.el6.x86_64 • glibc-2.12-1.7.el6.x86_64 • compat-glibc-2.5-46.2.x86_64 At least 1GB
x86_64 processor (AMD Opteron or Intel Xeon with EM64T) SuSE Linux Enterprise Server 11 (x86_64); version 11 patch level 0: • kernel-2.6.27.19-5.1 • glibc-2.9-13.2 1BG

Required libraries for Linux

• openmotif-2.3.1-2.el5

• libXp-1.0.0-8.1.el5

• libXt-1.0.2-3.1.fc6

• libXtst-1.0.1-3.1

• libXi-1.6.1-1

• libXmu-1.0.2-5

• libXext-1.0.1-2.1

• libSM-1.0.1-3.1

• libICE-1.0.1-2.1

• libX11-1.0.3-9.el

Required X/Motif-related RPM package

manager files

• libXtst-devel

• libXi-devel

• openmotif-devel

• libXmu-devel

• libXt-devel

• libXext-devel

• libXp-devel

• libX11-devel

• libSM-devel

• libICE-devel

These files should be compatible with RHEL5.3 or later.

Linux Disk Space Requirements
Product Linux X64 Requirements Linux X64 PSeries Requirements
Adaptive Server typical installation 921MB 1092MB
Default databases created during installation 306MB 164MB

In addition, there is a known OS kernel bug in scheduling threads in RHEL 6.0 that has been

fixed in RHEL 6.1; for this reason, Sybase recommends that you use 6.1.

Linux 64-bit x64 system memory requirements are:

• MinimumRAM required for AdaptiveServer, with defaultstack size, packetsize, and user

log cache size – 127 MB

• Minimum RAM per additional user – approximately 324KB

• Default user stack size – 128KB

3) Software &  Installation


Downloaded the product from SPDC or SAP Service Marketplace, go to the directory where you extracted the

installation image and start the installer:

Note : Before you can install a 64-bit Adaptive Server version 15.7 ESD #2 to a Red Hat Enterprise

Linux 6.x x86_64, install the 32-bit GNU C Libraries package (glibc-2.xxx.xx.el6.i686.rpm). Each operating system has a default maximum shared-memory segment. Configure your operating system to allow the allocation of a shared-memory segment at least as large as the maximum memory value.


step 1


Log into OS level in Linux and use x-manager or other tool to launch the GUI wizard


Once you extracted the file which you  are extracted the got to the directories   and execute the below command


./setup.bin


1. Choose as the installation directory

/sysdbase


Capture1.PNG

2. ‘Full’ installation then click ‘ Next’

Capture2.PNG

3. Select license  then click ‘Next’

Capture3.PNG

4. Accept the license for your location  and then Click ‘ Next’

Capture4.PNG

5. Review the Pre-Installation Summary – All components will be installed ‘Next’

Capture5.PNG

Capture6.PNG

6. Select to configure ASE and its companion servers, plus Sybase Control Center and then Click ‘Next’Capture7.PNG

7. The ASE Server name will default to the machine’s network node name – leave this asa default. Then click ‘Next’

Capture8.PNG

8. Set network port to 5000 (Windows default)

9. Leave Language, Character Set and Sort Order at default (see Notes)

10. Do NOT select to optimize ASE

11. Select to Create Sample databases

12. Click OK for the following message. We want 4k or higher page size

Capture9.PNG

13. Ensure all devices are under the $SYBASE\data directory and default sizes. Then Click ‘ Next’

Capture10.PNG

14. Keep Backup Server default name and port (5001) and the click ‘ Next’

Capture11.PNG

15. Keep XP server name and port (5002) and then click ‘Next’

Capture12.PNG

16. Keep Job Scheduler agent name and port(4900) and then click ‘Next’

Capture13.PNG

17. Leave ‘sa’ as self management user and then click ‘Next’

Capture14.PNG

18. Only configure UDP Adapter for discovery services and then click ‘Next’

Capture15.PNG

19. Leave default ports (8282, 8283) for SCC  and then click ‘Next’

Capture16.PNG

20. Leave RMI service port at 9999 and then Click ‘Next’

Capture17.PNG

21. Set sccadmin password and uafadmin

password to ‘sybase’ and then click ‘Next’

Capture18.PNG

22. Select ‘Yes’ to start SCC as a service and then click ‘Next’

Capture19.PNG

23. Review final installation summary screen

Capture20.PNG

24. Installation and configuration starts – ASE and XP server first, then BS, JS_AGENT and SCC.

ASE may be stopped and restarted several times during this process

Capture21.PNG

All the steps are done!

To report this post you need to login first.

14 Comments

You must be Logged on to comment or reply to a post.

  1. Jeroen Rijnbergen

    For the shared memory segments, configure in /etc/sysctl.conf

    Maybe other parameters, depending on your server, #cores, #memory, storage, etc.

    also depends if your server is only running Sybase ASE, or also other apps

    some sample values:

    kernel.shmmax = <amount of memory, e.g.75% of available memory>

    vm.swappiness = 0

    kernel.exec-shield = 0

    kernel.randomize_va_space = 0

    fs.aio-max-nr = 65536

    (0) 
    1. Jeroen Rijnbergen

      sure, SAP ASE works perfectly fine on RHEL

      If you don’t have X libraries available, you can also do the whole install from the cmdline using resource files. After you install the Sybase package (setup.bin also runs in non-gui mode), you can find sample resource files in directory $SYBASE/$SYBASE_ASE/init/sample_resource_files

      you can build the instance then with command: srvbuildres -r <resource file>

      (0) 
      1. Vasilije Topalovic

        Hi Jeroen,

        Thanks for the information.

        Does we have full SAP support if we want to install SAP ASE on RedHat EL with the virtual platform Oracle VM ?

        Thanks in advance.

        Best regards

        (0) 
        1. Jeroen Rijnbergen

          I wouldn’t know why not.

          VMware is supported as well. If OS is RHEL, then it should be fine.

          Though you should verify this with SAP Support

          Better check how SAP ASE licenses are handled in Oracle VM. How many cores etc.

          SAP ASE licenses are based on hostid, this might impact the way you take care of the VM. Like moving the VM to another server might change the hostid on the VM and impact your SAP ASE licenses.

          How it combines with things like ZFS no idea. But AFAIK Sybase never certifies using any particular filesystem anyway.

          (0) 
  2. Vasilije Topalovic

    Thanks again for your help.

    We plan to have a SAP ASE installation on Oracle Vm with Redhat EL. How can we contact SAP Support to know for sure, that our plan is the right installation procedure and for that we have full SAP support?

    Best regards.

    (0) 
    1. Jeroen Rijnbergen

      You’ll need a support contract to get support from SAP

      though plenty of people here if you’ve got some technical questions

      you can start with either the free developer or express edition to get some ideas if it works technically

      https://www.sap.com/campaign/ne/sybase/ase_developer_edition_download/index.epx

      The developer and express editions provide most functionality, but are limited in number of cores, memory, number of user connections, and database size.

      note if you want any bug fixes, you’ll need a support contract

      (0) 
  3. Vasilije Topalovic

    Hi Jeroen,

    What we gonna do to be sure that the combination of :

    1. Virtual platform ( Oracle Vm, )

    2. Os ( RedHat, Oracle Linux)

    3. SAP +  ASE database

    are fully official supported by SAP ?

    (0) 
    1. Jeroen Rijnbergen

      SAP will support SAP ASE

      If it’s running on RHEL then should be fine

      I don’t think SAP will support Oracle Linux itself šŸ™‚

      But that’s the same for Solaris, HP-UX, AIX, etc.

      if you want official answer, contact SAP sales…

      (0) 
  4. Yogesh Kotwani

    We did the sapseĀ installation using the Ā above method,now we are installation SAP application using SWPM and it is asking all details on Sybase DB.My question is does SWPM has the capability to install sybase DB ? If yes whats the preferred method ?

    (0) 

Leave a Reply