SAP ASE 16 Sybase ASE Installation and Configuration Part 1. To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers. To know about me visit my profile at www.rnsangwan.com. I deliver online training on Business Analysis, Linux, Unix, MySQL, Sybase, SQL Server, Perl, Python, R Data Analysis, Scala etc.
Sequence 1 . Prepare the Operating System
1. Disk Space : A full installation needs approx. 1.5 Gb so 4 Gb should give you enough room to handle upgrades too. In this case we install the software in /opt/sap. Database files will be stored /var/sap.
Add a group "sybase" and a user "sybase" to the system. Also create the needed directories.
useradd -d /opt/sap sybase
mkdir -p /var/sap
chown sybase:sybase /var/sap
2. Enable the operating system to allow more than the default value for shared memory.
Add following line to /etc/sysctl.conf
Now Issue the Command
# sysctl -p
3. Install 32 bit libraries
When installing Sybase ASE 64 bit version on Linux, you need to install the 32 bit shared libraries as well. This will prevent problems when running isql or bcp.
yum -y install libX11.i686 libXtst.i686 gtk2.i686 glibc.i686 libgcc.i686 webkitgtk.i686
Save the Commands listed in Next Three Steps (4,5 and 6) in /etc/init.d/rc.local
4. Create Raw devices from the Partitions (Create Necessary Partitions before performing this)
Sybase recommends to store all database files on raw devices except for temporary databases like tempdb.
# raw /dev/raw/raw1 /dev/sdb1
# raw /dev/raw/raw2 /dev/sdb2
# raw /dev/raw/raw3 /dev/sdb3
# raw /dev/raw/raw5 /dev/sdb5
# raw /dev/raw/raw6 /dev/sdb6
5. Change permissions on the raw devices...
# chmod 600 /dev/raw/raw1
# chmod 600 /dev/raw/raw2
# chmod 600 /dev/raw/raw3
# chmod 600 /dev/raw/raw5
# chmod 600 /dev/raw/raw6
6. Change ownership on the raw devices to sybase...
# chown sybase:sybase /dev/raw/raw1
# chown sybase:sybase /dev/raw/raw2
# chown sybase:sybase /dev/raw/raw3
# chown sybase:sybase /dev/raw/raw5
# chown sybase:sybase /dev/raw/raw6
We shall be using
/dev/raw/raw1 master (100 Mb)
/dev/raw/raw2 sybsystemprocs (200M)
/dev/raw/raw3 sybsystemdb (10M)
/dev/raw/raw5 data01 (We shall use 100MB for testing. You can always add more)
/dev/raw/raw6 log01(we shall use 25MB for testing. You can always add more).
Sequence 2. Installation of the software
1. Switch to the newly created user:
su - sybase
You should now be in the directory /opt/sap. Make a work directory and put the downloaded Sybase software in it.
# mkdir install
# cd install
# tar -xf ase160_linuxx86-64.tgz
2. Logout from root and login as "sybase" to Start the installation
# cd install
If Installation fails to start in GUI, this problem can occur for the following reasons:
1. The file /usr/lib/libstdc++.so.5.0.7 or later is not installed on the system.
2. The $DISPLAY environment variable is not properly set.
3. The necessary X Windows libraries for running the GUI installer are not available.
The solutions below relate to the cause above:
1. Install libstdc++.so.5.0.7 or later.
2. See the AppScan Source Edition release notes, which are included in the docs directory of the installation files for information on installing this library.
3. Set your $DISPLAY environment variable to a valid display.
Run the installation process with the system's default 64-bit JRE:
./setup.bin LAX_VM /usr/bin/java
If after performing the steps above the issue still persist, this may be variation of the issue where the issue is the uninstaller is unable to open the display. To validate that issue is due to lack of access to the display, launch the installer without sudo. If the installer displays as the user this is an access issue to the display. If VNC was used to connect to the server, then the following command will need to be ran:
If physically present at the server or if ssh was used to connect to the server use the following command:
sudo -E ./setup.bin
3. Complete the Installation
Use /opt/sap as the destination directory, do a full installation. At the list of possible servers to configure, deselect all options. We will do a manual configuration.
When the installation has finished successful you can safely remove the work directory and the installation package.
4. Setup the environment
In /opt/sap you will find SYBASE.sh. Run this file:
Check the value of $SYBASE: