标签: 杂谈 分类: 数据库
sybase的interfaces中存储了sybase的服务名、IP地址与端口,该文件在sybase用户主目录下,其修改方法有两种:
1、通过dscp命令进行修改,示例如下
$ dscp【回车】
open【回车】
ok
FailOver to Interface Driver.
Session 1 InterfacesDriver>> list【回车】
Server objects found:
SYBASE
SYB_BACKUP
Session 1 InterfacesDriver>> list all【回车】
DIT base for object: interfaces
Distinguish name: SYBASE
Server Entry Version: 1
Server Name: SYBASE
Server Service: SQL Server
Server Status: 4 (Unknown)
Server Address:
Transport Type: tli tcp
Transport Address: 192.168.125.181 8000
Distinguish name: SYB_BACKUP
Server Entry Version: 1
Server Name: SYB_BACKUP
Server Service: SQL Server
Server Status: 4 (Unknown)
Server Address:
Transport Type: tli tcp
Transport Address: 192.168.125.181 8001
Session 1 InterfacesDriver>> mod SYBASE【回车】
Address:
Transport Type: [tli tcp] 【回车】
Transport Address: [192.168.125.181 8000] 192.168.67.181 8000【回车】
Transport Type: [] 【回车】
Modified SYBASE
Session 1 InterfacesDriver>> mod SYB_BACKUP【回车】
Address:
Transport Type: [tli tcp] 【回车】
Transport Address: [192.168.125.181 8001] 192.168.67.181 8001【回车】
Transport Type: [] 【回车】
Modified SYB_BACKUP
Session 1 InterfacesDriver>> list all【回车】
DIT base for object: interfaces
Distinguish name: SYBASE
Server Entry Version: 1
Server Name: SYBASE
Server Service: SQL Server
Server Status: 4 (Unknown)
Server Address:
Transport Type: tli tcp
Transport Address: 192.168.67.181 8000
Distinguish name: SYB_BACKUP
Server Entry Version: 1
Server Name: SYB_BACKUP
Server Service: SQL Server
Server Status: 4 (Unknown)
Server Address:
Transport Type: tli tcp
Transport Address: 192.168.67.181 8001
Session 1 InterfacesDriver>>exit或quit退出
mod (修改)如上例;
如果需要增加,可以使用add 命令(比如add SYBASE);
如果要删除配置,可以使用del 命令(比如del SYBASE)
注意,修改、删除不能使用modify或者delete,只能使用mod 和 del,否则报语法错误(Syntax Error)。
2、直接修改interfaces文件
1)sybase11.9.2修改示例
SYBASE
master tli tcp /dev/tcp \x00021f40c0a843b50000000000000000
query tli tcp /dev/tcp \x00021f40c0a843b50000000000000000
SYB_BACKUP
master tli tcp /dev/tcp \x00021f41c0a843b50000000000000000
query tli tcp /dev/tcp \x00021f41c0a843b50000000000000000
可以发现IP地址和端口都以16进制方式存储,如下:
ip地址为:c0(192)a8(168)43(67)b5(181)
端口为:1f40(8000) 1f41(8001)
因此,如果需要修改,请自行转换,将相应的位改成需要的值。
2)sybase 12.5修改示例
对于较高版本的sybase, interfaces文件中的ip是通过点分10进制方式存储,端口也是10进制数,这个修改就很容易了,如下示例:
vi interfaces
SYBASE
master tcp ether 192.168.125.181 8000
query tcp ether 192.168.125.181 8000
SYB_BACKUP
master tcp ether 192.168.125.181 8001
query tcp ether 192.168.125.181 8001
使用DbVisualizer连接sybase数据库:
url书写:
jdbc:jtds:sybase://192.168.125.181:8000;DatabaseName=testdb;charset=eucgb