sybase shutdown 的问题

jazy

你这个问题还真没见过！


你在什么系统上装什么版本的sybase?

jazy

不知道是否是版本的原因还是你没装全！

你第一次shutdown是怎么操作的？

检查一下你的数据库的日志文件，看是否有什么错误信息。

jazy

Bavkup Server/11.9.3/32bit/P/ Sun-svr4/os 5.7/opt//1107/Sun Dec
6 14:40:09 1998
Confidential propetry of sybase,Inc
COPYRIGHT 1987,1998
SYBASE,INC. All rights reserved
Unpublished rights reserver under U.S. Copyright Law

This software contains confidential and trade secret information of sybase,Inc.
use duplication or disclosure of the software and documentation by the U.S. Goverment and sybase ,inc. or other written
agreement specifying the Goverment's rights to use the software and any applicable FAR provisions ,for example,FAR 52.227-19
Sybase.Inc. 6475 christie Avenue. Emeryville.CA 94608.USA

上面这些信息只是运行提示信息，没什么不对的！

关键你要看看你当前的服务是否都正常起来了

showserver命令可以查看！

jazy

那你查看你日志的最后部分，并贴上来，并检查你的interfaces文件中是否有你配置的server的信息

我想只要你配置这些服务，在启动时会有相关信息的

jazy

那你也得贴上来啊

要不怎么知道问题所在阿

jazy

看来是你的字符集有问题了：
Error: 2409

Cannot find the requested character set in Syscharsets: name = '%.*s'.
Explanation
Information about the character sets that are defined for use by SQL Server is stored in syscharsets . Error 2409 occurs when SQL Server cannot find a character set needed for character set conversion.

Error 2409 can occur in the following situations:

When a client requests a connection, SQL Server checks whether it can convert from the client's character set to its own character set. If SQL Server cannot do the requested conversion because a character set is not found, Error 2409 is raised.

If you use the set char_convert command to start conversion between the SQL Server character set and a different character set and the character set you specify does not exist in syscharsets , Error 2409 is raised.

Action
Make sure all necessary character sets are loaded, including the client's character set (as shown in the error message output):

1>; use master  2>; go
1>; select csid, id, name from syscharsets  
2>; go
  csid id  name                              ---- --- ------------------------------      0   0 ascii_8                             
0   1 iso_1                                
1  50 bin_iso_1  

If you are missing needed character sets, follow the directions in the SQL Server Installation Guide for your platform to load them. You will be directed to use one of the following utilities:

sybinit for SQL Server releases 10.0 and later

sybconfig for SQL Server release 4.9.x

sybinstall for SQL Server releases prior to 4.9.x

Standalone Utilities
By default, for standalone utilities, the character set used for the client is the default for the platform. This may not be the correct character set. If the 2409 error is occurring while you are using isql , bcp , or defncopy , use the -J (UNIX and PC) or / clientcharset (OpenVMS) command-line option to specify the client character set.

Open Client Applications
For Open Client applications such as DB-Library, you can specify the character set for the client through the login packet. Refer to the Reference Manual for the application and the Open Client/Server Supplement for your platform for details.

Additional Information
Refer to the System Administration Guide for details about character set conversion.

你在连接时使用 -J选项试试看！

jazy

我建议你重装一次，在选择字符集时，选择iso_1！！

jazy

老师不敢当！

大家互相讨论，建议你使用图形界面进行安装，这样就避免直接手工修改配置文件！

jazy

看看下面的例子：
sqlsrv.default_language: USE_DEFAULT  
sqlsrv.language_install_list: USE_DEFAULT  
sqlsrv.language_remove_list: USE_DEFAULT sqlsrv.default_characterset: iso_1  
sqlsrv.characterset_install_list: USE_DEFAULT  
sqlsrv.characterset_remove_list: USE_DEFAULT  
sqlsrv.sort_order: bin_iso_1  

关键是
sqlsrv.default_characterset: iso_1  
sqlsrv.sort_order: bin_iso_1  

会影响到你的字符集和排序方式！