新手求助

tonybobz

我刚接触UNIX和SYBASE。装好SCO UNIX5。05后。也装好了SYBASE。但配置完SYBASE后却无法启动SYBASE服务。
提示。SERVER ERROR：无法启动服务SYBASE。
请问是为什么？
我是在普通PC上装的。SIS的主板。

jazy

你的sybase是什么版本？

错误代码是什么？到$SYBASE/install/下看看*.log文件

tonybobz

SYBASE/INSTALL/errorlog文件内容如下：
00:03/04/20 21:08:24.87 kernel  Using config area from primary master device.

00:03/04/20 21:08:25.00 kernel  Configuration Error: Configuration file, '/usr/sybase/SYBASE.cfg', does not exist.

00:03/04/20 21:08:25.04 kernel  Warning: A configuration file was not specified and the default file '/usr/sybase/SYBASE.cfg' does not exist. SQL Server creates the default file with the default configuration.

00:03/04/20 21:08:25.55 kernel  Using 110 file descriptors.

00:03/04/20 21:08:25.57 kernel  ulinitspinlock: allocate mutex lock failed

00:03/04/20 21:24:05.18 kernel  Using config area from primary master device.

00:03/04/20 21:24:05.25 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:03/04/20 21:24:05.67 kernel  Using 110 file descriptors.

00:03/04/20 21:24:05.67 kernel  ulinitspinlock: allocate mutex lock failed

00:03/04/20 21:30:05.54 kernel  Using config area from primary master device.

00:03/04/20 21:30:05.69 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:03/04/20 21:30:06.21 kernel  Using 110 file descriptors.

00:03/04/20 21:30:06.23 kernel  ulinitspinlock: allocate mutex lock failed

00:03/04/20 21:33:20.70 kernel  Using config area from primary master device.

00:03/04/20 21:33:20.71 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:03/04/20 21:33:21.12 kernel  Using 110 file descriptors.

00:03/04/20 21:33:21.13 kernel  ulinitspinlock: allocate mutex lock failed

00:03/04/21 21:16:50.16 kernel  Using config area from primary master device.

00:03/04/21 21:16:50.32 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:03/04/21 21:16:50.83 kernel  Using 110 file descriptors.

00:03/04/21 21:16:50.84 kernel  ulinitspinlock: allocate mutex lock failed
backup.log内容如下：
Apr 20 21:21:39 2003: Backup Server/11.0.3/P/SCO/SCO_SV r3.2v5.0.2/2/OPT/Fri Jul 18 20:09:37 PDT 1997

Apr 20 21:21:39 2003: Confidential property of Sybase, Inc.

(c) Copyright Sybase, Inc.  1987, 1997

All rights reserved.


Use, duplication or disclosure by the U.S. Government is subject to

restrictions set forth in FAR subparagraphs 52.227-19(a)-(d) for
civilian agency contracts and DFARS 252.227-7013(c)(1)(ii) for

Department of Defense contracts.  Sybase reserves all unpublished

rights under the copyright laws of the United States.

Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608 USA.

Logging Backup Server messages in file '/usr/sybase/install/backup.log'


Apr 20 21:21:44 2003: Open Server Error: 5704.10.0: Changed client character set setting to 'iso_1'
.

leoyangli

SQL SERVER 11.0.x FOR SCO OPENSERVER 5
　　
  　　　一. 安装 SCO OpenServer 5.0.2 PATCH (OS5.0.4以上无需此步骤)
    OSS437a
    OSS441a
    OSS446a

　　　二. 建立SYBASE帐号(使用scoadmin)

    　　修改shell文件，增加SYBASE DSQUERY PATH 环境变量。

   　1. sh or ksh (.profile):
    SYBASE  =  安装目录
    DSQUERY =  数据库服务器的名字(默认为SYBASE)
    PATH    =  $SYBASE/binSYBASE/installPATH:
    export SYBASE DSQUERY PATH

   或

   　2. csh (.cshrc)
    setenv SYBASE   安装目录
    setenv DSQUERY  数据库服务器的名字
    set    path  =  ($SYBASE/bin $SYBASE/install $path .)     

　　　三. 系统参数调整。

   　1. 共享内存。
    编辑/etc/conf/cf.d/stune
    加入:

    SHMMAX67108864     (=64M内存)
    NFILE11000
    NOFILES1024     

   　2. 激活异步I/O

    将/etc/conf/sdevice.d/aio  文件“N”改为“Y”,
      /etc/conf/sdevice.d/suds 文件“N”改为“Y”

   　3. 编辑/etc/rc2     

    在文件最后加入/etc/suds_ctrl -a <sybase user_group_id No.>;    （注1）
    例：检查SYBASE用户所处组的组号如50(group)，则为suds_ctrl -a 50

   　4. 重建内核

    # /etc/conf/cf.d/link_unix

  　5. 重新启动计算机

    # shutdown -y -g0 -i6

　　　四. 安装SYBASE (注3)

   　1.安装11.0.3

    # mount /dev/cd0 /cdrom
    # su - sybase
    % /cdrom/sybload -D
      Y  (确认安装目录)
      L  (本地安装)
      /cdrom/sybimage  
      输入 CAS#   (34个字母,不区分大小写和空格)
      选择产品序号(按空回车结束)
      Y (确认选择的产品)
    # umount /cdrom

   　2.安装 Y2K EBF

    # mount /dev/cd0 /cdrom
    # su - sybase
    % tar xvf /cdrom/ebfss/ebf7575.tar
    % tar xvf /cdrom/ebfcs/ebf7791.tar
    # umount /cdrom

   　3.配置 SQL Server  

    % $SYBASE/install/sybinit   (注4)

　　注：
　　　　1)以sybase登录，使用id命令可以得到group id或通过 cat /etc/passwd | grep sybase 得到。

　　　　2)若安装SQL Server 过程中boot server时出现下面错误(可检查errorlog文件)：ulinitspinlock:allocate mutex lock failed则是因为在执行suds_ctrl时SYBASE用户组的组号不对，重新执行suds_ctrl即可。

　　　　3)#号为使用root用户进行操作,%号为使用sybase用户操作。

　　　　4)详细步骤请查看安装手册