数据库双机问题求助

jtyhyl

tru64 sybase12.0 双机热备服务器
主机突然启动不起来了，把主机关掉，用原来的备机进行启动作为数据库服务器启动正常，使用也正常，盘柜没问题，问主机为什么不能启动，且日志只有几行，大家帮忙看一下，到底是什么错，错在哪里？
附日志：
00:00000:00000:2005/01/04 08:30:44.16 kernel Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2005/01/04 08:30:44.44 kernel Using config area from primary master device.
00:00000:00000:2005/01/04 08:30:44.47 kernel Warning: Using default file '/usr/sybase/sybase.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2005/01/04 08:30:44.53 kernel Kernel memory at address 8388608 (0x0000000000800000), size is 1668857856 bytes
00:00000:00000:2005/01/04 08:30:44.54 kernel Using 4096 file descriptors.
00:00000:00000:2005/01/04 08:30:44.57 kernel Adaptive Server Enterprise/12.0.0.1/P/SWR 9270 ESD 3/Digital UNIX/OSF1 V4.0D/1629/64bit/OPT/Wed Sep 6 17:57:36 2000
00:00000:00000:2005/01/04 08:30:44.57 kernel Confidential property of Sybase, Inc.
00:00000:00000:2005/01/04 08:30:44.57 kernel Copyright 1987, 2000
00:00000:00000:2005/01/04 08:30:44.57 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2005/01/04 08:30:44.57 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2005/01/04 08:30:44.57 kernel
00:00000:00000:2005/01/04 08:30:44.57 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2005/01/04 08:30:44.57 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2005/01/04 08:30:44.57 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2005/01/04 08:30:44.57 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2005/01/04 08:30:44.57 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2005/01/04 08:30:44.57 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2005/01/04 08:30:44.57 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2005/01/04 08:30:44.57 kernel Using '/usr/sybase/sybase.cfg' for configuration information.
00:00000:00000:2005/01/04 08:30:44.57 kernel Logging ASE messages in file '/usr/sybase/ASE-12_0/install/sybase.log'.
00:00000:00000:2005/01/04 08:30:44.99 kernel kdcl_init: connectivity library does not support master/query syntax

ZealeS

licence的服务有没有启来？

1017of

对比一下两边的软件完全一样吗？

jtyhyl

两边是一样的，做的双机热备

jia_jyan

00:00000:00000:2005/01/04 08:30:44.16 kernel Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2005/01/04 08:30:44.44 kernel Using config area from primary master device.
00:00000:00000:2005/01/04 08:30:44.47 kernel Warning: Using default file '/usr/sybase/sybase.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.


从第一条报错可以看到 你的 license 文件找不到，或者不正确。
从第二条报错可以看到你的 '/usr/sybase/sybase.cfg' 没找到，是不是谁误删了你主机上 sybase 目录下的一些文件，你可以比照一下主从机的sybase 目录下面的文件。或者 比照一下 主从机的 /etc/rc2.d 下 启动 sybase 服务进程的 文件

jtyhyl

license文件是哪个？主机上确实有sybase.cfg文件，为什么会读不出来呢？tru64系统，sybase12.0

jasonshan

原帖由 "jia_jyan" 发表：
从第一条报错可以看到 你的 license 文件找不到，或者不正确。
从第二条报错可以看到你的 '/usr/sybase/sybase.cfg' 没找到，..........

这两条报错信息都是warning，不影响正常使用的，不是产生错误的原因
我怀疑和master设备或者是interface文件有关

jtyhyl

interface文件内容主机与备机都是一样的，master设备都是采用的同一个裸设备，应该也是一样的吧，我是这样想的，不知道还有没有其它方面的原因，上面的日志是主机启动时的日志，只有那么多，往下就没有了，连master设备都没有初始化到，不知何故。
正常的日志应该是下面的
00:00000:00000:2004/10/24 02:47:42.36 kernel  Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2004/10/24 02:47:42.64 kernel  Using config area from primary master device.
00:00000:00000:2004/10/24 02:47:42.67 kernel  Warning: Using default file '/usr/sybase/sybase.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2004/10/24 02:47:42.72 kernel  Kernel memory at address 8388608 (0x0000000000800000), size is 1668857856 bytes
00:00000:00000:2004/10/24 02:47:42.73 kernel  Using 4096 file descriptors.
00:00000:00000:2004/10/24 02:47:42.76 kernel  Adaptive Server Enterprise/12.0.0.1/P/SWR 9270 ESD 3/Digital UNIX/OSF1 V4.0D/1629/64bit/OPT/Wed Sep  6 17:57:36 2000
00:00000:00000:2004/10/24 02:47:42.76 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2004/10/24 02:47:42.76 kernel  Copyright 1987, 2000
00:00000:00000:2004/10/24 02:47:42.76 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2004/10/24 02:47:42.76 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2004/10/24 02:47:42.76 kernel  
00:00000:00000:2004/10/24 02:47:42.76 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2004/10/24 02:47:42.76 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2004/10/24 02:47:42.76 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2004/10/24 02:47:42.76 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2004/10/24 02:47:42.76 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2004/10/24 02:47:42.76 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2004/10/24 02:47:42.76 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2004/10/24 02:47:42.76 kernel  Using '/usr/sybase/sybase.cfg' for configuration information.
00:00000:00000:2004/10/24 02:47:42.76 kernel  Logging ASE messages in file '/usr/sybase/ASE-12_0/install/sybase.log'.
00:00000:00000:2004/10/24 02:47:43.18 kernel  kdcl_init: connectivity library does not support master/query syntax
00:00000:00000:2004/10/24 02:47:43.20 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2004/10/24 02:47:43.23 kernel  Network and device connection limit is 4086.
00:00000:00000:2004/10/24 02:47:43.62 server  Number of proc buffers allocated: 145496.
00:00000:00000:2004/10/24 02:47:48.36 server  Number of blocks left for proc headers: 145416.
00:00000:00000:2004/10/24 02:47:48.45 server  Proc header memory allocated 36354 pages for each per engine cache
00:00000:00000:2004/10/24 02:47:48.45 server   Memory allocated for the default data cache cachelet 1: 1052962 Kb
00:00000:00000:2004/10/24 02:47:48.63 server  Size of the 2K memory pool: 1052962 Kb
00:00000:00000:2004/10/24 02:47:48.65 kernel  Initializing virtual device 0, '/dev/rrz80b' with dsync 'on'.
00:00000:00000:2004/10/24 02:47:48.66 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2004/10/24 02:47:48.68 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:2004/10/24 02:47:48.68 kernel  engine 0, os pid 2145  online
00:00000:00000:2004/10/24 02:47:48.72 server  No active traceflags
00:00000:00001:2004/10/24 02:47:48.92 kernel  Component Integration Services loaded; version 'Component Integration Services/12.0.0.1/P/SWR 9270 ESD 3/Digital UNIX/OSF1 V4.0D/1629/64bit/OPT/Wed Sep  6 13:19:11 2000'.
00:00000:00001:2004/10/24 02:47:48.92 kernel  Component Integration Services: using 'Sybase Client-Library/12.0/P/DIGITAL UNIX/4.0 D/1/OPT/Mon Oct  4 14:51:30 1999'
00:00000:00001:2004/10/24 02:47:48.93 server  Opening Master Database ...
00:00000:00001:2004/10/24 02:47:49.33 server  Loading SQL Server's default sort order and character set
00:00000:00001:2004/10/24 02:47:49.34 server  Loaded default Unilib conversion handle.
00:00000:00002:2004/10/24 02:47:49.35 kernel  network name sybase, type ether, port 5000
00:00000:00001:2004/10/24 02:47:49.39 server  Recovering database 'master'
00:00000:00001:2004/10/24 02:47:49.64 server  Redo pass of recovery has processed 13 committed and 1 aborted transactions.
00:00000:00001:2004/10/24 02:47:50.33 server  Checking external objects.
00:00000:00001:2004/10/24 02:47:50.46 server  Database 'master' is now online.

REDMOB

我也怀疑是master设备和interface文件的配置，看看吧

jasonshan

双机热备的系统应该是一个磁盘阵列同时供两台主机使用，在任何时候只能有一台主机可以访问，所以当你B启动情况下是无论如何不可能启动A的