出错求错,不能连接数据库

mwao

前台不能连接,dbaccess通过TCP模式不能连接数据,通过SHM通连接,日志出错提示:
14:45:09  listener-thread: err = -27001: oserr = 0: errstr = : Read error occur.
出借时线程为110左右,机器为HP ML370  2*3.2CPU 4G内存.出问题是无规律,有时隔一天.有时好几天.
onconfig如下:

SERVERNUM       3               # Unique id corresponding to a Dynamic Server in
stance
DBSERVERNAME     jh10server_shm  # Name of default database server
DBSERVERALIASES  jh10server_tcp  # List of alternate dbservernames
NETTYPE                 ipcshm,1,60,CPU # Configure poll thread(s) for nettype
NETTYPE                 tlitcp,1,200,NET # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60              # Max time to wait of lock in distributed env.
RESIDENT        0               # Forced residency flag (Yes = 1, No = 0)

MULTIPROCESSOR  0               # 0 for single-processor, 1 for multi-processor
NUMCPUVPS       1               # Number of user (cpu) vps
SINGLE_CPU_VP   0               # If non-zero, limit number of cpu vps to one

BUFFERS         400000          # Maximum number of shared buffers
NUMAIOVPS       4               # Number of IO vps
PHYSBUFF        2048            # Physical log buffer size (Kbytes)
LOGBUFF         2048            # Logical log buffer size (Kbytes)
LOGSMAX         20              # Maximum number of logical log files
CLEANERS        2               # Number of buffer cleaner processes
SHMBASE         0x82000000        # Shared memory base address
SHMVIRTSIZE     114688          # initial virtual shared memory segment size
SHMADD          32768           # Size of new shared memory segments (Kbytes)
SHMTOTAL        0               # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL       600             # Check point interval (in sec)
LRUS            4               # Number of LRU queues
LRU_MAX_DIRTY   20              # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY   10              # LRU percent dirty end cleaning limit
LTXHWM          50              # Long transaction high water mark percentage
LTXEHWM         60              # Long transaction high water mark (exclusive)
TXTIMEOUT       0x12c             # Transaction timeout (in sec)
STACKSIZE       64              # Stack size (Kbytes)

wenlq

finderr 里说 库很忙，客户端连接很多。
Probably the connection attempt timed out because the
database server or the network was very busy, too many clients were
attempting to connect to the database server simultaneously, or the
database server was taken off-line during the connection attempt.
If this error is seen only occasionally in the server message log, it
is just a warning. No corrective action is required on the server
side.

If this error occurs frequently on a database server that runs on a
host with multiple processors, you might want to tune the database
server by increasing the number of poll threads and/or listener
threads.
根据这个信息是不是可以把200再加大？

MULTIPROCESSOR  0    你有多个cpu 这个可以为1

ahkai

改过系统的核心参数没？

sam_8286

NETTYPE                 ipcshm,1,60,CPU # Configure poll thread(s) for nettype
NETTYPE                 tlitcp,1,200,NET # Configure poll thread(s) for nettype
可以改为            ipcshm,2,150,CPU
                              tlitcp,2,200,NET