求教高手,关于安装sybase的问题??急!!!

发布于 2022-10-01 11:23:10 字数 3578 浏览 6 评论 0

我在安装sybase时,sybase版本是11。9。2,用的是./srvbuildres -r ./sql.rs建立ASE;用./srvbuildres -f ./sqlbak.rs建立back,
启动是正常,但是不能进行dump 和load
interfaces 文件如下
CHINA
        master tcp ether 192.168.100.224 5000
        query tcp ether 192.168.100.224 5000

CHINA_back
        master tcp ether 192.168.100.224 6000
        query tcp ether 192.168.100.224 6000

sql.rs如下:
sybinit.release_directory: /opt/sybase-11.9.2
sybinit.product: sqlsrv
sqlsrv.server_name: CHINA
sqlsrv.new_config: yes
sqlsrv.do_add_server: yes
sqlsrv.network_protocol_list: tcp
sqlsrv.network_hostname_list: 192.168.100.224
sqlsrv.network_port_list: 5000
sqlsrv.master_device_physical_name: /home/sybase/master.dat
sqlsrv.master_device_size: 60
sqlsrv.master_database_size: 50
sqlsrv.errorlog: /home/sybase/errlog.dat
sqlsrv.do_upgrade: no
sqlsrv.sybsystemprocs_device_physical_name: /home/sybase/sysproc.dat
sqlsrv.sybsystemprocs_device_size: 80
sqlsrv.sybsystemprocs_database_size: 60
sqlsrv.sybsystemdb_device_physical_name: /home/sybase/temp.dat
sqlsrv.sybsystemdb_device_size: 80
sqlsrv.sybsystemdb_database_size: 60
sqlsrv.default_backup_server: CHINA_back

sqlbak.rs如下:
sybinit.release_directory: /opt/sysbase-11.9.2
sybinit.product: bsrv
bsrv.server_name: CHINA_back
bsrv.do_add_backup_server: yes
bsrv.network_protocol_list: tcp
bsrv.network_hostname_list: 192.168.100.224
bsrv.network_port_list: 6000
bsrv.language: us_english
bsrv.character_set: cp850
bsrv.tape_config_file: /opt/sybase-11.9.2/install/CHINA_back.cfg
bsrv.errorlog: /opt/sybase-11.9.2/install/CHINA_back.log

错误信息如下:
isql -Usa -P -SCHINA
1>; dump database master to '/home/sybase/master.dump'
2>; go
00:00000:00008:2003/12/05 09:56:28.30 kernel  Connectivity Library (Directory Control Layer) Error: Error returned by service provider.
00:00000:00008:2003/12/05 09:56:28.30 kernel  Connectivity Library (Directory Control Layer) Error: (InterfacesDriver): Requested server name not found.
00:00000:00008:2003/12/05 09:56:28.30 server  Error: 7220, Severity: 11, State: 1
00:00000:00008:2003/12/05 09:56:28.30 server  Site 'SYB_BACKUP' not found in interfaces file.
00:00000:00008:2003/12/05 09:56:28.30 server  Error: 7235, Severity: 17, State: 0
00:00000:00008:2003/12/05 09:56:28.30 server  No other query entry found for the remote server SYB_BACKUP - site SYB_BACKUP. Aborting this site handler, as no remote server responded. Please make sure the remote server is accepting connections.
WARNING: In order to LOAD the master database, the SQL Server must run in
single-user mode.  If the master database dump uses multiple volumes, you must
execute sp_volchanged on another SQL Server at LOAD time in order to signal
volume changes.
Msg 7205, Level 17, State 2:
Line 1:
Can't open a connection to site 'SYB_BACKUP'.  See the error log file in the SQL
Server boot directory.
Msg 7205, Level 18, State 3:
Line 1:
Can't open a connection to site 'SYB_BACKUP'.  See the error log file in the SQL
Server boot directory.

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文