SAP ASE 16 / Sybase ASE - Installation and Configuration

How to install and perform initial configuration of SAP ASE / Sybase on Linux. Step by step tutorial with quizes and lab

Created byRafał Mobilo

Last updated 1/2025

English

What you'll learn

How to prepare virtual machine for the course
How to install Linux on it
How to configure Linux for SAP ASE installation
How to install SAP ASE
How to validate the installation
How the start-up procedure works
How to start/stop ASE, how to configure it to automatic start/stop
What environmental variables are used by ASE
Which files are the most important, what kind of information they contain and how and when it is used
How to configure ASE to listen on external network interfaces
How to troubleshoot some common problems with installation or configuration
How to install Interactive SQL on Windows
How to work with sp_configure and how to work with configuration files

Course content

10 sections • 52 lectures • 2h 43m total length

Introduction2:08
Word from the author:
Why to learn SAP ASE / Sybase?
How to learn?
Why should you choose this course?
About the course3:16
Welcome on the course! Here you can find some tips how to work with the course. I know it is not an easy task. Try to plan your study, watch the video, solve the quiz, try to do some exercises. And remember - not the tempo is important, but the quality!
What you need to download for the excercises?0:27
Here you can find all the packages that will help you to actively participate in the course!

Configuring Virtual Machine on Hyper-V - VIDEO8:36
This lesson shows how to configure Hyper-V on Windows machine, to have it ready for Linux Fedora installation. Hyper-V is available only on the higher editions of Windows, so if you have Windows Home edition see the another video about VMPlayer installation and configuration
Configuring Virtual Machine on Hyper-V - QUIZ
Configuring Virtual Machine on Hyper-V - LAB0:04
Do some exercises!
Configuring a Virtual Machine on VMPlayer - VIDEO7:56
In this lesson you will see how to install VMPlayer and use it as a virtual environment in the scope of that course. This lesson is not mandatory. It should help you to get familiar with VMPlayer if you don't have Hyper-V
Configuring a Virtual Machine on VMPlayer - QUIZ
Configuring a Virtual Machine on VMPlayer - LAB0:05
Do some excercises!

Linux Fedora Installation - VIDEO8:29
In this lesson you will see how to install Linux Fedora. The most important points here are the disk configuration and the network configuration. If you are using Hyper-V, this video covers all you need. If you have installed VMPlayer, than the network configuration differs slightly. No worries - this part of network configuration is included in Video telling about VMPlayer installation and configuration.
Linux Fedora Installation - QUIZ
Linux Fedora Installation - LAB0:05
Do some exercises!
Integrating Linux with Windows host - VIDEO7:20
Sometimes we need to copy some files from Windows host to Linux machin and vice versa. This lesson shows how integrate Windows and Linux. Of course such integration can be condigured in many different ways, so choose the best from your point of view.
Integrating Linux with Windows host - QUIZ
Integrating Linux with Windows host - LAB0:05
Do some exercises!

Disabling IPv6 - VIDEO4:51
Software like Sybase 16 may have some problems of compatibility nature. In such a case you need first to perform some initial configuration and disable components causing problems. Here you will see, how to disable the IPv6 protocol on Linux
Disabling IPv6 - QUIZ
Disabling IPv6 - LAB0:08
Do some excercises!
Prerequisites - installing required packages - VIDEO5:50
In this lesson you will learn which additional packages are required for successful installation of SAP Sybase on Linux. You will get familiar with package manager dnf.
Prerequisites - installing required packages - QUIZ
Prerequisites - installing required packages - LAB0:05
Do some exercises!
Creating user accout for SAP Sybase ASE installation - VIDEO3:03
In this lesson you can learn how to create a user account for the Sybase database engine installation. You will add a user account, define a password and add the user to sudoers file.
Creating user accout for SAP Sybase ASE installation - QUIZ
Creating user accout for SAP Sybase ASE installation - LAB0:20
Do some exercises!
Basic Linux Security Info - VIDEO8:44
In this lesson some security related topics will be shown allowing to better understand how some works and how security on Linux works. You will see how to work with sudo, visudo, mount, umount, whoami, id. You will also see the content of passwd, groups, shadow and sudoers files.
Basic Linux Security Info - QUIZ
Basic Linux Security Info - LAB0:17
Do some excercises!

Installing SAP Adaptive Server Enterprise - VIDEO10:30
In this lesson you will see how to install Sybase ASE step by step, screen by screen
Installing SAP Adaptive Server Enterprise - QUIZ
Installing SAP Adaptive Server Enterprise - LAB0:07
Do some excercises!
Testing Sybase Installation - VIDEO4:23
In this lesson you will see, how to configure the session of a unix user, who want to work with isql command. You will learn also how to test if the server is running or not.
Testing Sybase Installation - QUIZ
Testing Sybase Installation - LAB0:23
Do some excercises!

Starting Sybase Servers -VIDEO7:23
This lesson presents how to start and stop Sybase server process.It will be also discussed, how the Sybase start script (RUN FILE) is built.
Starting Sybase Servers - QUIZ
Starting Sybase Servers -LAB0:17
Do some exercises!
Stopping Sybase Servers -VIDEO4:25
This lesson presents information about how to stop the dataserver and the backupserver. After finishing the module you will understand the difference between shutdown and shutdown with nowait option.
Stopping Sybase Servers - QUIZ
Stopping Sybase Servers - LAB0:10
Do some excercises!
Interfaces file -VIDEO5:14
In this lesson you will learn about interfaces file, its syntax and how it is used by client applications and by the server during the booting procedure.
Interfaces file -QUIZ
Interfaces file - LAB0:12
Do some exercises!

Important Files and Directories in Sybase Installation - VIDEO5:53
For a dba it is important to know the location of some critical files and folders. You need to know where the logs can be found, where the programs are located, where the configuration files are hold and so on. This type of information is covered by this lesson.
Important Files and Directories in Sybase Installation - QUIZ
Important Files and Directories in Sybase Installation - LAB0:16
Do some excercises!
Sybase Environmental Variables - VIDEO6:20
In this lesson you can learn how to define environmental variables and what are the most important Sybase variables. You will also see how to modify sap user's profile to automatically load all the required by Sybase client tools variables.
Sybase Environmental Variables - QUIZ
Sybase Environmental Variables - LAB0:12
Do some excercises!
Configuration files - VIDEO3:05
In this lesson you will find some basic and introductory information about the sybase configuration files: where to find them, what is the content of them, when copies of the config file are created.
Configuration files - QUIZ
Configuration files - LAB0:10
Do some excercises!
Sybase Error Log - VIDEO7:29
This lesson concentrates on the error log of Sybase server. .You will see where the error log is saved, how to work with error log and you will take look into the error log, So that you will be aware of what kind of information is saved in the errorlog.
Sybase Error Log - QUIZ
Sybase Error Log - LAB0:13
Do some exercises
Open Client and Interactive SQL Installation - VIDEO4:09
In this lesson you will learn how to install the Open Client and Interactive SQL on Windows. You will also see the fundamental info about how to use Interactive SQL
Open Client and Interactive SQL Installation - QUIZ
Open Client and Interactive SQL Installation - LAB0:09
Do some exercises!

Script to start and stop Sybase - VIDEO9:56
In this lesson you will analyze the script used to start and stop Sybase. You will also learn how to use the script.
Script to start and stop Sybase - QUIZ
Script to start and stop Sybase - LAB1:25
Do some excercises!
Configuring Sybase ASE for Autostart - VIDEO8:16
Here you will learn how to configure Sybase service to start automatically when operating system boots. Exact steps of how to define a new service will be shown, as well as the entire configuration with tests.
Configuring Sybase ASE for Autostart - QUIZ
Configuring Sybase ASE for Autostart - LAB0:03
Do some exercises!
Configuring Sybase to listen on external network interface - VIDEO7:23
This lesson is dedicated to configuration of Sybase to listen incoming requests on external network requests. You will get familiar with configuration of firewall on Linux and with pure-Sybase configuration. You will work with sp_listener procedure
Configuring Sybase to listen on external network interface - QUIZ
Configuring Sybase to listen on external network interface - LAB0:10
Do some exercises!

Configuration Parameters of SAP - VIDEO5:21
This lesson presents configuration parameters of SAP Sybase server. You will learn how the dataserver process knows which parameters should be loaded and where the parameters file can be found. Next you will learn about how to display the current parameters values and how to get help about them.
Configuration Parameters of SAP - QUIZ
Configuration Parameters of SAP - LAB0:11
Do some excercises!
Changing configuration parameters - VIDEO3:03
In this lesson you will learn how to change the configuration parameter.
Changing configuration parameters - QUIZ
Changing configuration parameters - LAB0:12
Do some excercises!
Operation on Configuration Files -VIDEO4:25
This lesson shows how to replace the entire set of configuration options at once and not one by one.
Operation on Configuration Files -LAB0:06
Do some excercises!
Operation on Configuration Files -QUIZ

Requirements

Advanced Windows user
Some basic experience in Linux (course explains the Linux stuff in detail, but some prior knowledge is a bonus)
Basic understanding of how services work
Basic understanding of database terminology

Description

SAP Adaptive Server Enterprise (formerly known as Sybase ASE) is a relational database management system used by companies where high performance and stability counts.

There is not many good educational materials available teaching how to administer this database type, specially on Linux environment. That is why this course has been created. Specially difficult is the installation part, as a lot of manual pre-installtion and post-installation steps need to be done to have the environment ready to use. All those steps are covered in this course.

If you want to be a SAP ASE professional database administrator join the course and learn step by step:

How to prepare virtual machine for the course
How to install Linux on it
How to configure Linux for SAP ASE installation
How to install SAP ASE
How to validate the installation
How the start-up procedure works
How to start/stop ASE, how to configure it to automatic start/stop
What environmental variables are used by ASE
Which files are the most important, what kind of information they contain and how and when it is used
How to configure ASE to listen on external network interfaces
How to troubleshoot some common problems with installation or configuration
How to install Interactive SQL on Windows
How to work with sp_configure and how to work with configuration files

After completing the course you will be able to install and configure SAP Adaptive Server Enterprise and troubleshoot the installation and configuration issues by yourself.

For active participation in the course you will need:

Windows computer with virtual machine, where Linux will be installed, or just Linux machine - Fedora 23 is used in the course. Fedora can be downloaded from Internet repositories.
SAP Adaptive Server installation package for Linux and Windows - it can be downloaded from vendor site after registration.

Course helps in preparation towards certification exam C_SASEAA157 SAP Certified Technology Associate - Database Administrator for SAP Sybase ASE 15.7

Join our course and become the professional SAP Adaptive Server Enterprise administrator!

ISBN 978-83-945846-6-5

Who this course is for:

Administrators of other database types like Oracle, MSSQL, MySQL and others
Beginners in the area of SAP Adaptive Server Enterprise / Sybase ASE
Linux and Windows administrators specializing in applications
Developers, who want to understand, how the databases internally work

SAP ASE 16 / Sybase ASE - Installation and Configuration

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 6min

Preparation to study4 lectures • 17min

Linux Fedora Installation4 lectures • 16min

Sybase prerequisits - pre configuration8 lectures • 23min

SAP Sybase ASE Installation4 lectures • 15min

Adaptive Server start and stop procedures6 lectures • 18min

Becoming Familiar with the SAP Sybase ASE Installation10 lectures • 28min

Configuring Sybase ASE on Operating System Level6 lectures • 27min

SAP Sybase ASE configuration6 lectures • 13min

What next?1 lecture • 1min

Requirements

Description

Who this course is for: