# 解压安装包
$ tar -xvf ase160_linux_x86_64.tar

# 输出示例如下：
ase160/
ase160/setup.bin
ase160/install/
ase160/doc/
…

# 创建sybase用户
# groupadd sybase
# useradd -g sybase sybase

# 运行安装程序
$ ./setup.bin

# 输出示例如下：
Preparing to install…
Extracting the JRE from the installer archive…
Launching installer…

===============================================================================
SAP Adaptive Server Enterprise 16.0
===============================================================================

Introduction
————
This installer will guide you through the installation of SAP Adaptive Server Enterprise 16.0.

PRESS ENTER TO CONTINUE:

# 选择安装目录
Choose Install Folder
———————
Where would you like to install?

[Default: /opt/sap/ase160]

# 选择安装类型
Choose Install Set
——————
Please select the Install Set to be installed by this installer.

->1- Typical
2- Custom
3- Server only

# 配置服务器
Configure New Server
——————–
Do you want to configure a new server?

->1- Yes
2- No

# 输入服务器名称
Server Name
———–
Enter the name of the server.

[Default: SYBASE]

# 输入端口号
Port Number
———–
Enter the port number for the server.

[Default: 5000]

# 完成安装
Installation Complete
———————
Congratulations. SAP Adaptive Server Enterprise 16.0 has been successfully installed to:

/opt/sap/ase160

PRESS ENTER TO EXIT THE INSTALLER:

# 配置环境变量
$ cat >> ~/.bash_profile << EOF export SYBASE=/opt/sap/ase160 export SYBASE_ASE=ASE-16_0 export SYBASE_OCS=OCS-16_0 export PATH=$SYBASE/$SYBASE_ASE/bin:$SYBASE/$SYBASE_OCS/bin:$PATH export LD_LIBRARY_PATH=$SYBASE/$SYBASE_ASE/lib:$SYBASE/$SYBASE_OCS/lib:$LD_LIBRARY_PATH export DSQUERY=SYBASE EOF # 使环境变量生效 $ source ~/.bash_profile # 查看环境变量 $ echo $SYBASE # 输出示例如下： /opt/sap/ase160

启动数据库

# 启动ASE服务器
$ startserver -f $SYBASE/$SYBASE_ASE/install/RUN_SYBASE

# 输出示例如下：
Starting server…
Server started successfully.

# 查看服务器状态
$ showserver

# 输出示例如下：
USER PID %CPU %MEM SZ RSS TT S STARTED TIME COMMAND
sybase 12345 0.5 2.0 512000 512000 ? S 10:30:00 00:00:05 /opt/sap/ase160/ASE-16_0/bin/dataserver -d/dev/master -sSYBASE

# 连接数据库
$ isql -Usa -S SYBASE

# 输出示例如下：
Password:
1>

基本配置

# 连接数据库
$ isql -Usa -S SYBASE

# 输出示例如下：
Password:
1>

# 修改sa密码
1> sp_password NULL, “new_password”, sa
2> go

# 输出示例如下：
Password correctly set.
(return status = 0)

# 查看服务器版本
1> select @@version
2> go

# 输出示例如下：
————————————————–
Adaptive Server Enterprise/16.0/EBFxxxx/P/Linux/…
(1 row affected)

# 查看数据库
1> sp_helpdb
2> go

# 输出示例如下：
name db_size owner dbid created status
——— ——– ——— —- ———— ——————–
master 100.0 MB sa 1 Jan 01, 2026 mixed log and data
model 2.0 MB sa 3 Jan 01, 2026 mixed log and data
sybsystemprocs 200.0 MB sa 4 Jan 01, 2026 mixed log and data
tempdb 2.0 MB sa 2 Jan 01, 2026 mixed log and data
(4 rows affected)
(return status = 0)

# 创建新数据库
1> create database fgedb on master = “100M” log on master = “50M”
2> go

# 输出示例如下：
CREATE DATABASE: allocating 51200 pages on disk ‘master’
CREATE DATABASE: allocating 25600 pages on disk ‘master’
Database ‘fgedb’ is now online.

# 配置内存参数
1> sp_configure “total memory”, 524288
2> go

# 输出示例如下：
Configuration option changed. Since the option is static, Adaptive Server must be rebooted in order for the change to take effect.
(return status = 0)

# 配置缓存
1> sp_cacheconfig “default data cache”, “512M”
2> go

# 输出示例如下：
Configuration option changed. Since the option is static, Adaptive Server must be rebooted in order for the change to take effect.
(return status = 0)

# 查看配置
1> sp_configure “total memory”
2> go

# 输出示例如下：
Parameter Name Config Value Run Value
—————————— ———— ———
total memory 524288 524288
(1 row affected)
(return status = 0)

高可用配置

# 配置高可用（HA）
1> sp_configure “enable HA”, 1
2> go

# 输出示例如下：
Configuration option changed. Since the option is static, Adaptive Server must be rebooted in order for the change to take effect.
(return status = 0)

# 配置伙伴服务器
1> sp_companion “primary_server”, configure, “primary_server”, “secondary_server”
2> go

# 查看HA状态
1> sp_companion
2> go

# 输出示例如下：
Companion Server Name Mode Status
———————- ——— ———
secondary_server symmetric normal
(1 row affected)
(return status = 0)