求教高手,关于安装sybase的问题??急!!!
我在安装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 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论