Part 1:SAP Business objects: Let's make installation simple with combination of Linux and ASE DB

[patelyogesh]

Hello,

I dealt with the ASE database for the first time in a long time. I spend the majority of my time dealin with HANA-Linux and Windows-SQL, however SAP's ASE DB and Linux are extremely different.

I started with the following.

SAP Business Object : 4.2

Linux : Suse X64

DB : ASE 16

Installation : Shared (Clusters as shown below)

The following is the layout of the installation... 

I'm not pointing too many arrows in this picture because it's really high level and they're all connected.

 

Let's get started... one by one... What should be done?

1. Database Server Settings

User:

First, I established a user to install the database on the server.

I'm making a single user who can share a name with all other servers, such as DB and bobj sid.

Please set up the user as shown below.

Please enter your username.



Set Login Shell



When you create this user on the remainder of the clustered servers, make sure the User ID is the same on all of them.

Next, install the appropriate library files and make kernel adjustments.

Library files and kernel settings

Referance: https://help.sap.com/viewer/65018c09dbe04052b082e6fc4ab60030/4.2.7/en-US/9714a878-d607-458e-9118-de9...

Required libraries can be installed by ZYPPER

• zypper install glibc


• zypper install glibc-32bit


• zypper install libstdc++33


• zypper install libstdc++33-32bit

Example as below



 

Edit or add the following kernel parameters and values to the /etc/sysctl.conf file

• kernel.sem = 250 32000 32 1024


• kernel.msgmni = 1024


• kernel.shmmax = 18446744073709551615

Now get your disks ready for installation

Disk Mounts

I've made the mounts listed here.

The examples below are merely examples of how to build mounts; you can name your disc mounts whatever you like. 

The secret name is the SID name I'd like to use for my system and database.

 

Ensure that the user you created has read/write access to all mounts (Each and every server)

As shown below, an optional component can be installed.

unixODBC

Install unixODBC through YaST2



 

Now your server is ready to begin installing the ASE database.

Part 2:SAP Business objects: Let's make installation simple with combination of Linux and ASE DB

Thank you for taking the time to read this.

Yogesh Patel