那位高手看看，isql 语句不能用，sybase 1192 down 不下来

SARS1

$ isql -Usa -P -Slzfront
CT-LIBRARY error:
        ct_connect(): network packet layer: internal net library error: Net-Libd protocol driver call to connect two endpoints failed


berrorlog内容：

00:00000:00000:2004/03/21 11:46:32.08 kernel  Using config area from primary master device.
00:00000:00000:2004/03/21 11:46:32.09 kernel  Warning: Using default file '/sybase/lzback.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/03/21 11:46:33.92 kernel  Using 400 file descriptors.
00:00000:00000:2004/03/21 11:46:33.92 kernel  Adaptive Server Enterprise/11.9.2.4/P/SWR 9486(Data General) ROLLUP, SWR 9487(UNIXWARE) ROLLUP/DG AViiON/SCO UnixWare 2.1.3/FBO/Wed Feb 21 22:08:20 2001
00:00000:00000:2004/03/21 11:46:33.93 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2004/03/21 11:46:33.94 kernel  Copyright 1987, 2001
00:00000:00000:2004/03/21 11:46:33.94 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2004/03/21 11:46:33.94 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2004/03/21 11:46:33.98 kernel  
00:00000:00000:2004/03/21 11:46:33.98 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2004/03/21 11:46:33.98 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2004/03/21 11:46:33.99 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2004/03/21 11:46:33.99 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2004/03/21 11:46:34.00 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2004/03/21 11:46:34.01 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2004/03/21 11:46:34.01 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2004/03/21 11:46:34.02 kernel  Using '/sybase/lzback.cfg' for configuration information.
00:00000:00000:2004/03/21 11:46:34.02 kernel  Logging SQL Server messages in file '/sybase/install/berrorlog'.
00:00000:00000:2004/03/21 11:46:34.06 kernel  kdcl_init: connectivity library supports master/query syntax
00:00000:00000:2004/03/21 11:46:34.07 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2004/03/21 11:46:34.08 kernel  SQL Server booted with TCP_NODELAY enabled.
00:00000:00000:2004/03/21 11:46:34.08 kernel  Network and device connection limit is 390.
00:00000:00000:2004/03/21 11:46:34.13 server  Number of proc buffers allocated: 55102.
00:00000:00000:2004/03/21 11:46:34.18 kernel  dioinit: Unable to lock memory for async I/O
00:00000:00000:2004/03/21 11:46:34.33 server  Proc header memory allocated 27551 pages for each per engine cache
00:00000:00000:2004/03/21 11:46:34.33 server  Number of blocks left for proc headers: 55173.
00:00000:00000:2004/03/21 11:46:34.34 server  Memory allocated for the default data cache cache: 415228 Kb
00:00000:00000:2004/03/21 11:46:34.43 server  Size of the 2K memory pool: 415228 Kb
00:00000:00000:2004/03/21 11:46:34.44 kernel  Initializing virtual device 0, '/bmaster/master.dat'
00:00000:00000:2004/03/21 11:46:34.44 kernel  Virtual device 0 started using standard unix i/o.
00:00000:00000:2004/03/21 11:46:34.45 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2004/03/21 11:46:34.45 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/03/21 11:46:34.46 kernel  engine 0, os pid 3083  online
00:00000:00000:2004/03/21 11:46:34.47 server  No active traceflags
00:00000:00001:2004/03/21 11:46:34.47 server  Opening Master Database ...
00:00000:00001:2004/03/21 11:46:34.49 server  Loading SQL Server's default sort order and character set
00:00000:00002:2004/03/21 11:46:34.50 kernel  ninit:0: listener type: master
00:00000:00002:2004/03/21 11:46:34.50 kernel  ninit:0: listener endpoint: /dev/tcp
00:00000:00002:2004/03/21 11:46:34.51 kernel  ninit:0: listener raw address: \x00020fa0c81601340000000000000000
00:00000:00002:2004/03/21 11:46:34.52 kernel  ninit:0: transport provider: T_COTS_ORD
00:00000:00001:2004/03/21 11:46:34.53 server  Recovering database 'master'
00:00000:00001:2004/03/21 11:46:34.72 server  Database 'master' is now online.
00:00000:00001:2004/03/21 11:46:34.72 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2004/03/21 11:46:34.76 server  0 dump conditions detected at boot time
00:00000:00001:2004/03/21 11:46:34.77 server  server is unnamed
00:00000:00001:2004/03/21 11:46:34.78 server  Activating disk 'acctdev'.
00:00000:00001:2004/03/21 11:46:34.78 kernel  Initializing virtual device 22, '/baccount/acctdev.dat'
00:00000:00001:2004/03/21 11:46:34.78 kernel  Virtual device 22 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:34.79 server  Activating disk 'acctlog'.
00:00000:00001:2004/03/21 11:46:34.79 kernel  Initializing virtual device 23, '/baccount/acctlog.dat'
00:00000:00001:2004/03/21 11:46:34.80 kernel  Virtual device 23 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:34.80 server  Activating disk 'acctsecdev'.
00:00000:00001:2004/03/21 11:46:34.81 kernel  Initializing virtual device 24, '/baccount/acctsecdev.dat'
00:00000:00001:2004/03/21 11:46:34.81 kernel  Virtual device 24 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:34.82 server  Activating disk 'acctseclog'.
00:00000:00001:2004/03/21 11:46:34.82 kernel  Initializing virtual device 25, '/baccount/acctseclog.dat'
00:00000:00001:2004/03/21 11:46:34.82 kernel  Virtual device 25 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:34.83 server  Activating disk 'perdev'.
00:00000:00001:2004/03/21 11:46:34.83 kernel  Initializing virtual device 26, '/bperson/perdev.dat'
00:00000:00001:2004/03/21 11:46:34.84 kernel  Virtual device 26 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:34.84 server  Activating disk 'perlog'.
00:00000:00001:2004/03/21 11:46:34.85 kernel  Initializing virtual device 27, '/bperson/perlog.dat'
00:00000:00001:2004/03/21 11:46:34.85 kernel  Virtual device 27 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:34.86 server  Activating disk 'posdev'.
00:00000:00001:2004/03/21 11:46:34.86 kernel  Initializing virtual device 4, '/bpos/posdev.dat'
00:00000:00001:2004/03/21 11:46:34.86 kernel  Virtual device 4 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:34.87 server  Activating disk 'posdev1'.
00:00000:00001:2004/03/21 11:46:34.87 kernel  Initializing virtual device 5, '/bpos/posdev1.dat'
00:00000:00001:2004/03/21 11:46:34.88 kernel  Virtual device 5 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:34.88 server  Activating disk 'posdev10'.
00:00000:00001:2004/03/21 11:46:34.89 kernel  Initializing virtual device 14, '/bpos/posdev10.dat'
00:00000:00001:2004/03/21 11:46:34.89 kernel  Virtual device 14 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:34.90 server  Activating disk 'posdev11'.
00:00000:00001:2004/03/21 11:46:34.90 kernel  Initializing virtual device 15, '/bpos/posdev11.dat'
00:00000:00001:2004/03/21 11:46:34.90 kernel  Virtual device 15 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:34.91 server  Activating disk 'posdev12'.
00:00000:00001:2004/03/21 11:46:34.91 kernel  Initializing virtual device 16, '/bpos/posdev12.dat'
00:00000:00001:2004/03/21 11:46:34.92 kernel  Virtual device 16 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:34.92 server  Activating disk 'posdev13'.
00:00000:00001:2004/03/21 11:46:34.93 kernel  Initializing virtual device 17, '/bpos/posdev13.dat'
00:00000:00001:2004/03/21 11:46:34.93 kernel  Virtual device 17 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:34.94 server  Activating disk 'posdev14'.
00:00000:00001:2004/03/21 11:46:34.94 kernel  Initializing virtual device 18, '/bpos/posdev14.dat'
00:00000:00001:2004/03/21 11:46:34.94 kernel  Virtual device 18 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:34.95 server  Activating disk 'posdev15'.
00:00000:00001:2004/03/21 11:46:34.95 kernel  Initializing virtual device 19, '/bpos/posdev15.dat'
00:00000:00001:2004/03/21 11:46:34.96 kernel  Virtual device 19 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:34.96 server  Activating disk 'posdev16'.
00:00000:00001:2004/03/21 11:46:34.97 kernel  Initializing virtual device 20, '/bpos/posdev16.dat'
00:00000:00001:2004/03/21 11:46:34.97 kernel  Virtual device 20 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:34.98 server  Activating disk 'posdev2'.
00:00000:00001:2004/03/21 11:46:34.98 kernel  Initializing virtual device 6, '/bpos/posdev2.dat'
00:00000:00001:2004/03/21 11:46:34.98 kernel  Virtual device 6 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:34.99 server  Activating disk 'posdev3'.
00:00000:00001:2004/03/21 11:46:34.99 kernel  Initializing virtual device 7, '/bpos/posdev3.dat'
00:00000:00001:2004/03/21 11:46:35.00 kernel  Virtual device 7 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:35.00 server  Activating disk 'posdev4'.
00:00000:00001:2004/03/21 11:46:35.01 kernel  Initializing virtual device 8, '/bpos/posdev4.dat'
00:00000:00001:2004/03/21 11:46:35.01 kernel  Virtual device 8 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:35.02 server  Activating disk 'posdev5'.
00:00000:00001:2004/03/21 11:46:35.02 kernel  Initializing virtual device 9, '/bpos/posdev5.dat'
00:00000:00001:2004/03/21 11:46:35.44 kernel  Virtual device 9 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:35.44 server  Activating disk 'posdev6'.
00:00000:00001:2004/03/21 11:46:35.45 kernel  Initializing virtual device 10, '/bpos/posdev6.dat'
00:00000:00001:2004/03/21 11:46:35.45 kernel  Virtual device 10 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:35.46 server  Activating disk 'posdev7'.
00:00000:00001:2004/03/21 11:46:35.46 kernel  Initializing virtual device 11, '/bpos/posdev7.dat'
00:00000:00001:2004/03/21 11:46:35.47 kernel  Virtual device 11 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:35.47 server  Activating disk 'posdev8'.
00:00000:00001:2004/03/21 11:46:35.47 kernel  Initializing virtual device 12, '/bpos/posdev8.dat'
00:00000:00001:2004/03/21 11:46:35.48 kernel  Virtual device 12 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:35.48 server  Activating disk 'posdev9'.
00:00000:00001:2004/03/21 11:46:35.49 kernel  Initializing virtual device 13, '/bpos/posdev9.dat'
00:00000:00001:2004/03/21 11:46:35.49 kernel  Virtual device 13 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:35.50 server  Activating disk 'poslog'.
00:00000:00001:2004/03/21 11:46:35.50 kernel  Initializing virtual device 21, '/bpos/poslog.dat'
00:00000:00001:2004/03/21 11:46:35.51 kernel  Virtual device 21 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:35.51 server  Activating disk 'sysprocsdev'.
00:00000:00001:2004/03/21 11:46:35.51 kernel  Initializing virtual device 1, '/bmaster/sybsystemprocs.dat'
00:00000:00001:2004/03/21 11:46:35.52 kernel  Virtual device 1 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:35.52 server  Activating disk 'systemdbdev'.
00:00000:00001:2004/03/21 11:46:35.53 kernel  Initializing virtual device 2, '/bmaster/sybsystemdb.dat'
00:00000:00001:2004/03/21 11:46:35.53 kernel  Virtual device 2 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:35.54 server  Activating disk 'tempdbdev'.
00:00000:00001:2004/03/21 11:46:35.54 kernel  Initializing virtual device 3, '/bmaster/tempdb.dat'
00:00000:00001:2004/03/21 11:46:35.55 kernel  Virtual device 3 started using standard unix i/o.
00:00000:00001:2004/03/21 11:46:35.63 server  Recovering database 'model'.
00:00000:00001:2004/03/21 11:46:35.73 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2004/03/21 11:46:35.77 server  Database 'model' is now online.
00:00000:00001:2004/03/21 11:46:35.77 server  Clearing temp db
00:00000:00001:2004/03/21 11:46:36.39 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/03/21 11:46:36.43 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/03/21 11:46:36.47 server  Database 'tempdb' is now online.
00:00000:00001:2004/03/21 11:46:36.47 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/03/21 11:46:36.53 server  Recovering database 'sybsystemdb'.
00:00000:00001:2004/03/21 11:46:36.64 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2004/03/21 11:46:36.68 server  Database 'sybsystemdb' is now online.
00:00000:00001:2004/03/21 11:46:36.72 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2004/03/21 11:46:36.90 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2004/03/21 11:46:36.93 server  Database 'sybsystemprocs' is now online.
00:00000:00001:2004/03/21 11:46:36.98 server  Recovering database 'posadmin'.
00:00000:00001:2004/03/21 11:46:41.43 server  The transaction log in the database 'posadmin' will use I/O size of 2 Kb.
00:00000:00001:2004/03/21 11:46:41.46 server  Database 'posadmin' is now online.
00:00000:00001:2004/03/21 11:46:41.56 server  Recovering database 'account'.
00:00000:00001:2004/03/21 11:46:42.36 server  The transaction log in the database 'account' will use I/O size of 2 Kb.
00:00000:00001:2004/03/21 11:46:42.40 server  Database 'account' is now online.
00:00000:00001:2004/03/21 11:46:42.47 server  Recovering database 'acctsec'.
00:00000:00001:2004/03/21 11:46:43.41 server  The transaction log in the database 'acctsec' will use I/O size of 2 Kb.
00:00000:00001:2004/03/21 11:46:43.45 server  Database 'acctsec' is now online.
00:00000:00001:2004/03/21 11:46:43.52 server  Recovering database 'person'.
00:00000:00001:2004/03/21 11:46:44.13 server  The transaction log in the database 'person' will use I/O size of 2 Kb.
00:00000:00001:2004/03/21 11:46:44.17 server  Database 'person' is now online.
00:00000:00001:2004/03/21 11:46:44.20 server  Recovery complete.
00:00000:00001:2004/03/21 11:46:44.20 server  SQL Server's default sort order is:
00:00000:00001:2004/03/21 11:46:44.21 server          'bin_iso_1' (ID = 50)
00:00000:00001:2004/03/21 11:46:44.21 server  on top of default character set:
00:00000:00001:2004/03/21 11:46:44.21 server          'iso_1' (ID = 1).
00:00000:00001:2004/03/21 11:46:44.21 server  Loaded default Unilib conversion handle.

SARS1

兄弟急啊，在线等待。！！！

1017of

检查inetrfaces文件中是否有lzfront项，以及其中的主机名与端口是否正确！

SARS1

interfaces

lzback
        master tli tcp /dev/tcp \x00020fa0c81601340000000000000000
        query tli tcp /dev/tcp \x00020fa0c81601340000000000000000


lzfront
        master tli tcp /dev/tcp \x00020bb8c81601330000000000000000
        query tli tcp /dev/tcp \x00020bb8c81601330000000000000000


SYB_BACKUP
        master tli tcp /dev/tcp \x00020dacc81601340000000000000000
        query tli tcp /dev/tcp \x00020dacc81601340000000000000000

SARS1

楼上的兄弟，在哪个文件看端口，看哪些参数？/

SARS1

高手快看看啊

zhhui2000

网终正常吗，SERVER在本地吗？监听的是本地（localhost)端口还是局域地址？

zhangyh123

你的 ip 地址 是 200    22   1 51     
端口是 3016     吗

你什么运行平台 ？
netstat -n -a 看看
转换为 ip 与端口的说明：


lzfront
master tli tcp /dev/tcp \x00020bb8c81601330000000000000000
x0002  
0bb8  端口  不过一般在 4100 或者更高
c8 ip 第一个
16 ip 第二个
01 ip 第三个
33  ip 第四个
其他一样看


query tli tcp /dev/tcp \x00020bb8c81601330000000000000000

SARS1

谢谢两位