2,596
社区成员
发帖
与我相关
我的任务
分享服务不能启动了 ，救急
前几天，一个协作单位写了C#一个程序访问我的数据库，但是乱码。我在网上查了一下按下面的步骤操作我的数据库：
《
安装CP936字符集!
处理步骤: (假设安装目录是c:\sybase)
１：cmd命令行状态下:
1. c:\>cd \sybase\charsets\cp936
2. c:\sybase\charsets\cp936> charset -Usa -P -S binary.srt cp936
２：在SQL Advantage中
1>select id from syscharsets where name='cp936'
2>go
把选择出来的id（我得出来的是171，网上好多人得到的也是171，如果你的不是171，就用你选择出来的值）然后：
1>sp_configure "default character set id",171
３：重启Sybase服务器。需要重启两次。第一次重启后会直接停止，需要启动第二次。或者:重新启动机器。
经过这些设定以后，乱码问题就解决了。
》
我 执行完第2步后，先停止服务，等了约20分钟好像没停掉，我就重新启动机器，结果服务启动不了了，报“在本地计算机无法启动XXXXXXX服务。服务并未返回错误。”
请问该怎么办？谢谢
《
安装CP936字符集!
处理步骤: (假设安装目录是c:\sybase)
１：cmd命令行状态下:
1. c:\>cd \sybase\charsets\cp936
2. c:\sybase\charsets\cp936> charset -Usa -P -S binary.srt cp936
２：在SQL Advantage中
1>select id from syscharsets where name='cp936'
2>go
把选择出来的id（我得出来的是171，网上好多人得到的也是171，如果你的不是171，就用你选择出来的值）然后：
1>sp_configure "default character set id",171
３：重启Sybase服务器。需要重启两次。第一次重启后会直接停止，需要启动第二次。或者:重新启动机器。
经过这些设定以后，乱码问题就解决了。
》
我 执行完第2步后，先停止服务，等了约20分钟好像没停掉，我就重新启动机器，结果服务启动不了了，报“在本地计算机无法启动XXXXXXX服务。服务并未返回错误。”
请问该怎么办？谢谢
...全文
请发表友善的回复…
发表回复
pluto1971 2009-09-03
- 打赏
- 举报
你若建了用户数据库,千万不要去改字符集,这个改动sybase是很慢的,几天,甚至几个月.
你这个情况不是有问题,而是sybase一直在改你用户数据库上的字符.
你这个情况不是有问题,而是sybase一直在改你用户数据库上的字符.
vinsonshen 2009-08-31
- 打赏
- 举报
执行完第2步后，先停止服务，等了约20分钟好像没停掉，我就重新启动机器，结果服务启动不了了
--------------------------------
像这样重新启动，往往有时在数据库系统中出现一些意想不到的问题
--------------------------------
像这样重新启动，往往有时在数据库系统中出现一些意想不到的问题
zjsyw 2009-08-31
- 打赏
- 举报
多谢各位
wwwwb 2009-08-31
- 打赏
- 举报
看来非正常退出数据库，出问题可能性较大
WWWWA 2009-08-31
- 打赏
- 举报
SYBASE是比较稳定的数据库，一般不会出现这种情况
ACMAIN_CHM 2009-08-31
- 打赏
- 举报
那应该问题不大。
恢复前，把所有文件先备份一下。以免恢复不成功。
最好恢复后再测试一下。
恢复前，把所有文件先备份一下。以免恢复不成功。
最好恢复后再测试一下。
zjsyw 2009-08-31
- 打赏
- 举报
哦,谢谢,看来只好这么办了,数据库结构上没变化多,也没增加过什么设备
wwwwb 2009-08-31
- 打赏
- 举报
[Quote=引用 9 楼 zjsyw 的回复:]
备份后的会丢失?我的数据库设备不动呀,wwwwb解释下好吗?
[/Quote]
是指备份后新产生的数据，如果量不大的话，重新输入，呵呵，遇到这种情况，
相当恼火。
备份后的会丢失?我的数据库设备不动呀,wwwwb解释下好吗?
[/Quote]
是指备份后新产生的数据，如果量不大的话，重新输入，呵呵，遇到这种情况，
相当恼火。
ACMAIN_CHM 2009-08-31
- 打赏
- 举报
master 中存放着该数据库服务器上所有数据库实例的信息。
如果你的其它数据库有过结构上的变化，则一个月前的master 会与当前情况不符。
如果你没动过则可以试一下。
如果你的其它数据库有过结构上的变化，则一个月前的master 会与当前情况不符。
如果你没动过则可以试一下。
zjsyw 2009-08-31
- 打赏
- 举报
备份后的会丢失?我的数据库设备不动呀,wwwwb解释下好吗?
WWWWA 2009-08-31
- 打赏
- 举报
有备份就好，恢复后检查一下数据是否正常
wwwwb 2009-08-31
- 打赏
- 举报
[Quote=引用 5 楼 zjsyw 的回复:]
我有一个月前的全备份,在别的机器上恢复后拷贝MASTER到这台服务器上是否可行,请指教,wwwwb,谢谢了
[/Quote]
可以，不过备份后的数据会丢失
我有一个月前的全备份,在别的机器上恢复后拷贝MASTER到这台服务器上是否可行,请指教,wwwwb,谢谢了
[/Quote]
可以，不过备份后的数据会丢失
ACMAIN_CHM 2009-08-31
- 打赏
- 举报
[Quote]我有一个月前的全备份,在别的机器上恢复后拷贝MASTER到这台服务器上是否可行,请指教,wwwwb,谢谢了[/Quote]
可以，但如果你的库定义，设置变化过则会异常。
可以，但如果你的库定义，设置变化过则会异常。
zjsyw 2009-08-31
- 打赏
- 举报
我有一个月前的全备份,在别的机器上恢复后拷贝MASTER到这台服务器上是否可行,请指教,wwwwb,谢谢了
wwwwb 2009-08-31
- 打赏
- 举报
此数据库保存了启动的许多重要信息，一般损坏需要重新安装，估计是你重新启动机器而没有
正常关闭SYBASE造成的，SQLSERVER也是一样，MASTER损坏就要需要重新安装
正常关闭SYBASE造成的，SQLSERVER也是一样，MASTER损坏就要需要重新安装
zjsyw 2009-08-31
- 打赏
- 举报
是啊,这个操作怎么会让MASTER出问题呢?在服务没启动的时候,怎么操作MASTER
wwwwb 2009-08-31
- 打赏
- 举报
从提示上看，是
Recovering database 'master'
数据库有问题吧
Recovering database 'master'
数据库有问题吧
zjsyw 2009-08-31
- 打赏
- 举报
错误 日志:
00:00000:00000:2009/08/31 08:23:18.03 kernel Use license file c:\sybase\SYSAM-1_0\licenses\license.dat.
00:00000:00000:2009/08/31 08:23:18.03 kernel Checked out license ASE_SERVER
00:00000:00000:2009/08/31 08:23:18.03 kernel Adaptive Server Enterprise Edition
00:00000:00000:2009/08/31 08:23:18.03 kernel Using config area from primary master device.
00:00000:00000:2009/08/31 08:23:18.04 kernel Warning: Using default file 'c:\sybase\PSSERVER.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2009/08/31 08:23:20.71 kernel Using 100000 file descriptors.
00:00000:00000:2009/08/31 08:23:20.71 kernel Adaptive Server Enterprise/12.5.0.1/EBF 10430 ESD#2/P/NT (IX86)/OS 4.0/rel12501/1/32-bit/OPT/Tue Jul 30 23:45:57 2002
00:00000:00000:2009/08/31 08:23:20.71 kernel Confidential property of Sybase, Inc.
00:00000:00000:2009/08/31 08:23:20.71 kernel Copyright 1987, 2002
00:00000:00000:2009/08/31 08:23:20.71 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2009/08/31 08:23:20.71 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2009/08/31 08:23:20.71 kernel
00:00000:00000:2009/08/31 08:23:20.71 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2009/08/31 08:23:20.71 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2009/08/31 08:23:20.71 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2009/08/31 08:23:20.71 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2009/08/31 08:23:20.71 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2009/08/31 08:23:20.71 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2009/08/31 08:23:20.71 kernel Sybase, Inc. 5000 Hacienda Drive, Dublin, CA 94568, USA
00:00000:00000:2009/08/31 08:23:20.71 kernel Using 'c:\sybase\PSSERVER.cfg' for configuration information.
00:00000:00000:2009/08/31 08:23:20.71 kernel Logging ASE messages in file 'd:\errorlog'.
00:00000:00000:2009/08/31 08:23:20.73 kernel Initializing MSDTC Connection
00:00000:00000:2009/08/31 08:23:22.75 kernel MSDTC Initialization succeeded
00:00000:00000:2009/08/31 08:23:22.75 kernel kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2009/08/31 08:23:22.75 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2009/08/31 08:23:22.75 kernel *** WARNING ******************
00:00000:00000:2009/08/31 08:23:22.75 kernel Operating system may favor the system cache when memory is at a premium.
To disable this warning, set the registry parameter 'LargeSystemCache' to 0 in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management.
00:00000:00000:2009/08/31 08:23:22.75 kernel SQL Server NT process id is 0x704.
00:00000:00000:2009/08/31 08:23:22.75 kernel SQL Server was started as a Service.
00:00000:00000:2009/08/31 08:23:22.75 kernel SSL Plus v3.0.9 security modules loaded successfully.
00:00000:00000:2009/08/31 08:23:22.75 kernel Network and device connection limit is 99992.
00:00000:00000:2009/08/31 08:23:23.59 server Number of blocks left for proc headers: 146384.
00:00000:00000:2009/08/31 08:23:23.81 server Proc header memory allocated 73192 pages for each per engine cache
00:00000:00000:2009/08/31 08:23:24.98 server Memory allocated for the default data cache cachelet 1: 733184 Kb
00:00000:00000:2009/08/31 08:23:25.06 server Size of the 2K memory pool: 733184 Kb
00:00000:00000:2009/08/31 08:23:25.06 kernel Initializing virtual device 0, 'd:\data\master.dat' with dsync 'on'.
00:00000:00000:2009/08/31 08:23:25.06 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2009/08/31 08:23:25.06 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2009/08/31 08:23:25.06 kernel Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2009/08/31 08:23:25.06 kernel engine 0, os pid 384 online
00:00000:00000:2009/08/31 08:23:25.06 server No active traceflags
00:00000:00001:2009/08/31 08:23:25.06 kernel libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5.0.1/EBF 10430 ESD#2/P/NT (IX86)/OS 4.0/rel12501/1794/32-bit/OPT/Tue Jul 30 17:41:42 2002'.
00:00000:00001:2009/08/31 08:23:25.06 kernel libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P-EBF10322/PC Intel/BUILD125-011-1/OPT/Thu May 02 15:33:17 2002'
00:00000:00001:2009/08/31 08:23:25.06 server Opening Master Database ...
00:00000:00001:2009/08/31 08:23:25.10 server Loading SQL Server's default sort order and character set
00:00000:00001:2009/08/31 08:23:25.10 server Loaded default Unilib conversion handle.
00:00000:00001:2009/08/31 08:23:25.10 server Recovering database 'master'.
00:00000:00001:2009/08/31 08:23:25.14 server Error: 806, Severity: 21, State: 1
00:00000:00001:2009/08/31 08:23:25.14 server Could not find virtual page for logical page 1515539 in database 'master'.
00:00000:00001:2009/08/31 08:23:25.14 server Cannot recover the master database, exiting.
00:00000:00001:2009/08/31 08:23:25.14 kernel ueshutdown: exiting
00:00000:00000:2009/08/31 08:23:18.03 kernel Use license file c:\sybase\SYSAM-1_0\licenses\license.dat.
00:00000:00000:2009/08/31 08:23:18.03 kernel Checked out license ASE_SERVER
00:00000:00000:2009/08/31 08:23:18.03 kernel Adaptive Server Enterprise Edition
00:00000:00000:2009/08/31 08:23:18.03 kernel Using config area from primary master device.
00:00000:00000:2009/08/31 08:23:18.04 kernel Warning: Using default file 'c:\sybase\PSSERVER.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2009/08/31 08:23:20.71 kernel Using 100000 file descriptors.
00:00000:00000:2009/08/31 08:23:20.71 kernel Adaptive Server Enterprise/12.5.0.1/EBF 10430 ESD#2/P/NT (IX86)/OS 4.0/rel12501/1/32-bit/OPT/Tue Jul 30 23:45:57 2002
00:00000:00000:2009/08/31 08:23:20.71 kernel Confidential property of Sybase, Inc.
00:00000:00000:2009/08/31 08:23:20.71 kernel Copyright 1987, 2002
00:00000:00000:2009/08/31 08:23:20.71 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2009/08/31 08:23:20.71 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2009/08/31 08:23:20.71 kernel
00:00000:00000:2009/08/31 08:23:20.71 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2009/08/31 08:23:20.71 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2009/08/31 08:23:20.71 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2009/08/31 08:23:20.71 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2009/08/31 08:23:20.71 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2009/08/31 08:23:20.71 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2009/08/31 08:23:20.71 kernel Sybase, Inc. 5000 Hacienda Drive, Dublin, CA 94568, USA
00:00000:00000:2009/08/31 08:23:20.71 kernel Using 'c:\sybase\PSSERVER.cfg' for configuration information.
00:00000:00000:2009/08/31 08:23:20.71 kernel Logging ASE messages in file 'd:\errorlog'.
00:00000:00000:2009/08/31 08:23:20.73 kernel Initializing MSDTC Connection
00:00000:00000:2009/08/31 08:23:22.75 kernel MSDTC Initialization succeeded
00:00000:00000:2009/08/31 08:23:22.75 kernel kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2009/08/31 08:23:22.75 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2009/08/31 08:23:22.75 kernel *** WARNING ******************
00:00000:00000:2009/08/31 08:23:22.75 kernel Operating system may favor the system cache when memory is at a premium.
To disable this warning, set the registry parameter 'LargeSystemCache' to 0 in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management.
00:00000:00000:2009/08/31 08:23:22.75 kernel SQL Server NT process id is 0x704.
00:00000:00000:2009/08/31 08:23:22.75 kernel SQL Server was started as a Service.
00:00000:00000:2009/08/31 08:23:22.75 kernel SSL Plus v3.0.9 security modules loaded successfully.
00:00000:00000:2009/08/31 08:23:22.75 kernel Network and device connection limit is 99992.
00:00000:00000:2009/08/31 08:23:23.59 server Number of blocks left for proc headers: 146384.
00:00000:00000:2009/08/31 08:23:23.81 server Proc header memory allocated 73192 pages for each per engine cache
00:00000:00000:2009/08/31 08:23:24.98 server Memory allocated for the default data cache cachelet 1: 733184 Kb
00:00000:00000:2009/08/31 08:23:25.06 server Size of the 2K memory pool: 733184 Kb
00:00000:00000:2009/08/31 08:23:25.06 kernel Initializing virtual device 0, 'd:\data\master.dat' with dsync 'on'.
00:00000:00000:2009/08/31 08:23:25.06 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2009/08/31 08:23:25.06 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2009/08/31 08:23:25.06 kernel Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2009/08/31 08:23:25.06 kernel engine 0, os pid 384 online
00:00000:00000:2009/08/31 08:23:25.06 server No active traceflags
00:00000:00001:2009/08/31 08:23:25.06 kernel libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5.0.1/EBF 10430 ESD#2/P/NT (IX86)/OS 4.0/rel12501/1794/32-bit/OPT/Tue Jul 30 17:41:42 2002'.
00:00000:00001:2009/08/31 08:23:25.06 kernel libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P-EBF10322/PC Intel/BUILD125-011-1/OPT/Thu May 02 15:33:17 2002'
00:00000:00001:2009/08/31 08:23:25.06 server Opening Master Database ...
00:00000:00001:2009/08/31 08:23:25.10 server Loading SQL Server's default sort order and character set
00:00000:00001:2009/08/31 08:23:25.10 server Loaded default Unilib conversion handle.
00:00000:00001:2009/08/31 08:23:25.10 server Recovering database 'master'.
00:00000:00001:2009/08/31 08:23:25.14 server Error: 806, Severity: 21, State: 1
00:00000:00001:2009/08/31 08:23:25.14 server Could not find virtual page for logical page 1515539 in database 'master'.
00:00000:00001:2009/08/31 08:23:25.14 server Cannot recover the master database, exiting.
00:00000:00001:2009/08/31 08:23:25.14 kernel ueshutdown: exiting
