关闭sybase数据库出现问题，请问如何解决

SunnyXYJ

各位老大，关闭数据时，出现问题:
1> shutdown RETAD
2> go
Msg 7211, Level 18, State 1:
Server 'RETAD', Line 1:
Can't open a connection to site 'RETAD' because 'set up channel' message was not acknowledged.

即使是重新启动后，立即关闭也是这样。

请问，如何解决？

谢谢！

chuxu

你是关闭一个本地的数据库还是远程的？

SunnyXYJ

谢谢 chuxu   的答复。

新装的数据库，关闭的也是本地的。
我的server_name 为RETAD
是通过telnet的模式登录到服务器上关的。

通过
./startserver -f RUN_RETAD
./startserver -f RUN_RETAD_BS
启动数据库，然后立即用
isql -Usa -SRETAS -P
isql> shutdown SYB_BACKUP
可以关闭BACKUP SERVER，
1> shutdown SYB_BACKUP
2> go
Backup Server: 3.48.1.1: The Backup Server will go down immediately.
Terminating sessions.
1> 00:00000:00014:2008/08/13 15:31:36.24 kernel  Cannot read, host process disconnected: SYB_BACKUP  spid: 14

但是关闭数据库服务时出先问题
2> shutdown RETAD
3> go
00:00000:00015:2008/08/13 15:32:46.83 kernel  Cannot read, host process disconnected: RETAD  spid: 15
Msg 7211, Level 18, State 1:
Server 'RETAD', Line 2:
Can't open a connection to site 'RETAD' because 'set up channel' message was not
acknowledged.

但是可以直接通过
isql> shutdown
关闭数据库
1> shutdown
2> go
00:00000:00017:2008/08/13 16:03:48.93 kernel  XP Server is not running.
Server SHUTDOWN by request.
The SQL Server is terminating this process.
00:00000:00017:2008/08/13 16:03:48.94 server  SQL Server shutdown by request.
00:00000:00017:2008/08/13 16:03:48.94 kernel  ueshutdown: exiting
CT-LIBRARY error:
        ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect

但是老给出CT-LIBRARY error错误信息，我不知道这是否正常关闭。


bash-2.03$ isql -Usa -SRETAD -Psybase
1> select srvid, srvname from sysservers
2> go
srvid  srvname                        
------ ------------------------------
      0 RETAD                          
      1 SYB_BACKUP                     
      2 RETAD_XP                       

(3 rows affected)
1> select suid, name from syslogins
2> go
suid        name                           
----------- ------------------------------
           1 sa                             
           2 probe                          

(2 rows affected)
1> select remoteserverid, remoteusername, suid
2> from sysremotelogins
3> go
remoteserverid remoteusername                 suid        
-------------- ------------------------------ -----------

(0 rows affected)

SunnyXYJ

另外我启动数据库的时候的log是这样的，不知道哪个信息是表明数据库是正常启动的？

bash-2.03$ ./startserver -f RUN_RETAD               
kernel  Use license file /opt/sybase/db/SYSAM-1_0/licenses/license.dat.
kernel  Checked out license ASE_SERVER
kernel  Adaptive Server Enterprise Edition
kernel  Using config area from primary master device.
kernel  Using 1024 file descriptors.
kernel  Adaptive Server Enterprise/12.5.1/EBF 11420/P/Sun_svr4/OS 5.8/ase1251/1823/64-bit/FBO/Wed Sep 17 09:05:24 2003
kernel  Confidential property of Sybase, Inc.
kernel  Copyright 1987, 2003
kernel  Sybase, Inc.  All rights reserved.
kernel  Unpublished rights reserved under U.S. copyright laws.
kernel  
kernel  This software contains confidential and trade secret information of Sybase,
kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
kernel  agreement  specifying  the  Government's rights to use the software and any
kernel  applicable FAR provisions, for example, FAR 52.227-19.
kernel  Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
kernel  Using '/opt/sybase/db/ASE-12_5/RETAD.cfg' for configuration information.
kernel  Logging ASE messages in file '/opt/sybase/db/ASE-12_5/install/RETAD.log'.
kernel  SQL Server booted with TCP_NODELAY enabled.
kernel  SSL Plus v3.1.5 security modules loaded successfully.
kernel  Network and device connection limit is 1014.
server  Number of blocks left for proc headers: 3192.
server  Proc header memory allocated 1596 pages for each per engine cache
server  Size of the 2K memory pool: 8192 Kb
server  Memory allocated for the default data cache cachelet 1: 8192 Kb
kernel  Enabling Sun Kernel asynchronous disk I/O strategy.
kernel  Initializing virtual device 0, '/opt/sybase/db/data/master.dat' with dsync 'on'.
kernel  Virtual device 0 started using asynchronous i/o.
kernel  Worker Thread Manager is not enabled for use in SQL Server.
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.
kernel  engine 0, os pid 2720  online
server  No active traceflags
kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5.1/EBF 11420/P/Sun_svr4/OS 5.8/ase1251/1823/64-bit/FBO/Wed Sep 17 09:05:24 2003'.
kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5.1 ASE Edition/P-EBF11358; SSConfig VIRELTYPE/DRV.12.5.1/SPARC/Solaris 2.8/BUILD1251-004/64bit/OPT/Mon Aug 11 10:03:39 2003'
server  Opening Master Database ...
kernel  Unix interval timer enabled for sysclk interrupts.
server  Loading SQL Server's default sort order and character set
server  Loaded default Unilib conversion handle.
server  Recovering database 'master'.
server  Started estimating recovery log boundaries for database 'master'.
server  Completed estimating recovery log boundaries for database 'master'.
server  Started ANALYSIS pass for database 'master'.
server  Completed ANALYSIS pass for database 'master'.
server  Started REDO pass for database 'master'. The total number of log records to process is 1.
server  Completed REDO pass for database 'master'.
server  Recovery of database 'master' will undo incomplete nested top actions.
server  Started recovery checkpoint for database 'master'.
server  Completed recovery checkpoint for database 'master'.
server  Started filling free space info for database 'master'.
server  Completed filling free space info for database 'master'.
server  Started cleaning up the default data cache for database 'master'.
server  Completed cleaning up the default data cache for database 'master'.
server  Checking external objects.
server  Database 'master' is now online.
server  The transaction log in the database 'master' will use I/O size of 2 Kb.
server  Warning: ASE_HA has no valid license and therefore is not initialized.
server  server name is 'RETAD'
server  Activating disk 'sysprocsdev' of size 122880 KB.
kernel  Initializing virtual device 1, '/opt/sybase/db/data/sysprocs.dat' with dsync 'on'.
kernel  Virtual device 1 started using asynchronous i/o.
server  Recovering database 'sybsystemdb'.
server  Started estimating recovery log boundaries for database 'sybsystemdb'.
server  Completed estimating recovery log boundaries for database 'sybsystemdb'.
server  Started ANALYSIS pass for database 'sybsystemdb'.
server  Completed ANALYSIS pass for database 'sybsystemdb'.
server  Started REDO pass for database 'sybsystemdb'. The total number of log records to process is 1.
server  Completed REDO pass for database 'sybsystemdb'.
server  Recovery of database 'sybsystemdb' will undo incomplete nested top actions.
server  Started recovery checkpoint for database 'sybsystemdb'.
server  Completed recovery checkpoint for database 'sybsystemdb'.
server  Started filling free space info for database 'sybsystemdb'.
server  Completed filling free space info for database 'sybsystemdb'.
server  Started cleaning up the default data cache for database 'sybsystemdb'.
server  Completed cleaning up the default data cache for database 'sybsystemdb'.
server  Boot Count: 7
server  Checking external objects.
server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
server  Database 'sybsystemdb' is now online.
server  Recovering database 'model'.
server  Started estimating recovery log boundaries for database 'model'.
server  Completed estimating recovery log boundaries for database 'model'.
server  Started ANALYSIS pass for database 'model'.
server  Completed ANALYSIS pass for database 'model'.
server  Started REDO pass for database 'model'. The total number of log records to process is 1.
server  Completed REDO pass for database 'model'.
server  Recovery of database 'model' will undo incomplete nested top actions.
server  Started recovery checkpoint for database 'model'.
server  Completed recovery checkpoint for database 'model'.
server  Started filling free space info for database 'model'.
server  Completed filling free space info for database 'model'.
server  Started cleaning up the default data cache for database 'model'.
server  Completed cleaning up the default data cache for database 'model'.
server  Checking external objects.
server  The transaction log in the database 'model' will use I/O size of 2 Kb.
server  Database 'model' is now online.
server  The logical pagesize of the server is 2 Kb.
server  0 dump conditions detected at boot time
server  Resident Node id: ec19ca044ac5
server  Transaction coordinator initialized.
server  Clearing temp db
server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
server  Database 'tempdb' is now online.
server  Recovering database 'sybsystemprocs'.
server  Started estimating recovery log boundaries for database 'sybsystemprocs'.
server  Completed estimating recovery log boundaries for database 'sybsystemprocs'.
server  Started ANALYSIS pass for database 'sybsystemprocs'.
server  Completed ANALYSIS pass for database 'sybsystemprocs'.
server  Started REDO pass for database 'sybsystemprocs'. The total number of log records to process is 1.
server  Completed REDO pass for database 'sybsystemprocs'.
server  Recovery of database 'sybsystemprocs' will undo incomplete nested top actions.
server  Started recovery checkpoint for database 'sybsystemprocs'.
server  Completed recovery checkpoint for database 'sybsystemprocs'.
server  Started filling free space info for database 'sybsystemprocs'.
server  Completed filling free space info for database 'sybsystemprocs'.
server  Started cleaning up the default data cache for database 'sybsystemprocs'.
server  Completed cleaning up the default data cache for database 'sybsystemprocs'.
server  Checking external objects.
server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
server  Database 'sybsystemprocs' is now online.
kernel  network name pretad02, type tcp, port 5000, filter NONE
server  Recovery complete.
server  SQL Server's default unicode sort order is 'binary'.
server  SQL Server's default sort order is:
server    'bin_iso_1' (ID = 50)
server  on top of default character set:
server    'iso_1' (ID = 1).
server  Master device size: 30 megabytes, or 15360 virtual pages. (A virtual page is 2048 bytes.)
kernel  nconnect: connect, Connection refused

chuxu

关闭本地数据库的时候直接shutdown就可以了，不需要写Server名

chuxu

00:00000:00017:2008/08/13 16:03:48.93 kernel  XP Server is not running.
Server SHUTDOWN by request.
The SQL Server is terminating this process.
00:00000:00017:2008/08/13 16:03:48.94 server  SQL Server shutdown by request.
00:00000:00017:2008/08/13 16:03:48.94 kernel  ueshutdown: exiting
CT-LIBRARY error:
        ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect
这个提示是正常的。表示数据库是按请求被关闭

银面具

回答的很不错
支持一个~~

wangledahai

问个白痴问题 在ISQL里面 关闭服务 再想启动服务怎么办？

chuxu

在OS下，startserver

mzd73

在操作系统shell下运行startserver -f RUN_sybase即可