Sybase ASE数据库 16/15.7安装
安装参考博客:windows/Linux下安装Sybase ASE 16/15.7-CSDN博客。
1.下载安装包
以下安装可成功,有免费安装版本
linux:
-
Sybase ASE 15.7链接:https://pan.baidu.com/s/10aJLz3hP-tCOHWBrktZjug
提取码:a47t
-
Sybase ASE 16 链接:https://pan.baidu.com/s/1VOmQ_27T_1tNWMNI5YGQ8Q
提取码:fack
Windows:
-
Sybase ASE 16 链接:https://pan.baidu.com/s/1O4EH4A8S01QQv9zkhKw_Aw
提取码:sqsd
2. Windows下安装
windows下安装直接安装即可
3. Linux下安装
3.1 环境准备
root权限登录
创建sybase用户和目录:
adduser sybase
passwd sybase
mkdir /tmp/sybase
chown -R sybase:sybase /tmp/sybase
mkdir /opt/sybase
chown -R sybase:sybase /opt/sybase
3.2 安装
1)sybase用户登录,安装:
su - sybase
cd /tmp/sybase/
./setup.bin
![](https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=https%3A%2F%2Fpic.imgdb.cn%2Fitem%2F66c2aeb7d9c307b7e96e51d0.png&pos_id=img-DQNTOQMv-1724066427529%29)
![](https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=https%3A%2F%2Fpic.imgdb.cn%2Fitem%2F66c2aeb7d9c307b7e96e521d.png&pos_id=img-15i5cRjQ-1724066435849%29)
![](https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=https%3A%2F%2Fpic.imgdb.cn%2Fitem%2F66c2aeb7d9c307b7e96e5233.png&pos_id=img-g1ZivwTG-1724066436823%29)
![](https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=https%3A%2F%2Fpic.imgdb.cn%2Fitem%2F66c2aeb7d9c307b7e96e525c.png&pos_id=img-tXJtmobi-1724066437263%29)
![](https://img-blog.csdnimg.cn/img_convert/07d74a2eb56fd1b6e858fdeddcd2c1bb.png)
![](https://img-blog.csdnimg.cn/img_convert/d72561e78f00aa947a82162a9a566994.png)
![](https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=https%3A%2F%2Fpic.imgdb.cn%2Fitem%2F66c2c26bd9c307b7e9872cdf.png&pos_id=img-bwf8AbwH-1724066438346%29)
![](https://img-blog.csdnimg.cn/img_convert/8d04a751ddc690514a07ee37b5ebf6d2.png)
![](https://img-blog.csdnimg.cn/img_convert/9c96399f3dd8cbfd27a7885e2b756c73.png)
![](https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=https%3A%2F%2Fpic.imgdb.cn%2Fitem%2F66c2c26cd9c307b7e9872d14.png&pos_id=img-drSMd4lF-1724066439480%29)
3.3 配置文件
安装完成后,配置变量
修改sybase下SYBASE.sh文件(默认在/opt/sybase)
追加:
export DSQUERY=SYBASE
复制SYBASE.sh到/etc/profile.d
source /etc/profile
source ../sybase/SYBASE.sh
修改sybase/interfaces
sybase
master tcp ether 192.168.198.170 5000
query tcp ether 192.168.198.170 5000
3.4 连接数据库
使用isql进行交互查询
通过showserver命令查看服务名
[sybase@sybase sybase]$ showserver
F S UID PID PPID C PRI NI ADDR SZ WCHAN STIME TTY TIME CMD
0 S sybase 25670 25669 0 80 0 - 9459 poll_s 12:08 pts/0 00:00:00 /opt/sybase/ASE-15_0/bin/backupserver -e/opt/sybase/ASE-15_0/install/sybase_BS.log -N25 -C20 -M/opt/sybase/ASE-15_0/bin/sybmultbuf -Ssybase_BS -h/opt/sybase/ASE-15_0/install/sybase_BS.hosts.allow
0 S sybase 25632 25631 1 80 0 - 178353 futex_ 12:07 ? 00:02:50 /opt/sybase/ASE-15_0/bin/dataserver -ssybase -d/opt/sybase/data/master.dat -e/opt/sybase/ASE-15_0/install/sybase.log -c/opt/sybase/ASE-15_0/sybase.cfg -M/opt/sybase/ASE-15_0
一、 连接数据库
isql -U 用户名 -P 密码 -S 服务名 -D 数据库名
[sybase@sybase sybase]$ isql -U sa -P 123456 -S sybase -J utf8
1> select @@version
2> go
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Adaptive Server Enterprise/15.7/EBF 28476 SMP SP141 /P/x86_64/Enterprise Linux/
ase157sp141x/4331/64-bit/FBO/Wed Aug 14 03:15:04 2019
(1 row affected)
二、 显示当前版本
1> select @@version
2> go
或
1> sp_version
2> go
三、显示所有数据库名
1> sp_helpdb
4. 安装错误
见[Sybase安装问题记录](Sybase安装问题记录 - 零の守墓人 - 博客园 (cnblogs.com))