免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 13027 | 回复: 9
打印 上一主题 下一主题

shared memory not initialized for INFORMIXSERVER 'online'寻求解决方法!!! [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2011-09-30 10:36 |只看该作者 |倒序浏览
$ oninit -ivy

This action will initialize Informix Dynamic Server;
any existing Informix Dynamic Server databases will NOT be accessible -
Do you wish to continue (y/n)? y
Checking group membership to determine server run modesucceeded
Reading configuration file '/usr/informix/etc/onconfig.dev'...succeeded
Creating /INFORMIXTMP/.infxdirs ... succeeded
Creating infos file "/usr/informix/etc/.infos.online" ... "/usr/informix/etc/.co
nf.online" ... succeeded
Writing to infos file ... succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 400 kbytes...succeeded
Creating buffer pool 402 kbytes...succeeded
Initializing rhead structure...succeeded
Initializing ASF ...succeeded
Initializing Dictionary Cache and Stored Procedure Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 0 additional cpu vps...succeeded
Onlining 2 IO vps...succeeded
Forking main_loop thread...succeeded
Initialzing DR structures...succeeded
Forking 1 'ipcshm' listener threads...succeeded
Forking 1 'tlitcp' listener threads...$

$ onstat
shared memory not initialized for INFORMIXSERVER 'online'

下面我把sqlhosts、onconfig.dev、services和hosts内容贴出来,哪个好心人帮我看看,到底是哪里出错了。我折腾了好久都没有看出什么错来,谢谢哈!

论坛徽章:
0
2 [报告]
发表于 2011-09-30 10:37 |只看该作者
/usr/Informix/etc/sqlhosts
online        onipcshm       scosysv        sqlexec
online_tcp    ontlitcp       online         online_service

/usr/Informix/etc/onconfig.dev部分内容
ROOTNAME        rootdbs         # Root dbspace name
ROOTPATH        /usr/informix/chunk/chunk1
                                # Path for device containing root dbspace
ROOTOFFSET      0               # Offset of root dbspace into device (Kbytes)
ROOTSIZE        2000000         # Size of root dbspace (Kbytes)

# Disk Mirroring Configuration Parameters

MIRROR          0               # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH                      # Path for device containing mirrored root
MIRROROFFSET    0               # Offset into mirrored device (Kbytes)

# Physical Log Configuration

PHYSDBS         rootdbs         # Location (dbspace) of physical log
PHYSFILE        1000            # Physical log file size (Kbytes)

# Logical Log Configuration

LOGFILES        6               # Number of logical log files
LOGSIZE         500             # Logical log size (Kbytes)

# Diagnostics

MSGPATH         /usr/informix/online.log # System message log file path
CONSOLE         /dev/console    # System console message path
ALARMPROGRAM    /usr/informix/etc/log_full.sh # Alarm program path
SYSALARMPROGRAM /usr/informix/etc/evidence.sh # System Alarm program path
TBLSPACE_STATS  1               

# System Archive Tape Device

TAPEDEV         /dev/null       # Tape device path       
TAPEBLK         16              # Tape block size (Kbytes)
TAPESIZE        10240           # Maximum amount of data to put on tape (Kbytes)

# Log Archive Tape Device

LTAPEDEV        /dev/null       # Log tape device path
LTAPEBLK        16              # Log tape block size (Kbytes)
LTAPESIZE       10240           # Max amount of data to put on log tape (Kbytes)

# Optical

STAGEBLOB                       # Informix Dynamic Server/Optical staging area

# System Configuration

SERVERNUM       0               # Unique id corresponding to a Dynamic Server instance
DBSERVERNAME    online          # Name of default database server
DBSERVERALIASES online_tcp      # List of alternate dbservernames
NETTYPE         ipcshm,1,20,CPU # Configure poll thread(s) for nettype
NETTYPE         tlitcp,1,20,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

NOAGE           0               # Process aging
AFF_SPROC       0               # Affinity start processor
AFF_NPROCS      0               # Affinity number of processors

# Shared Memory Parameters

LOCKS           2000            # Maximum number of locks
BUFFERS         200             # Maximum number of shared buffers
NUMAIOVPS                       # Number of IO vps
PHYSBUFF        32              # Physical log buffer size (Kbytes)
LOGBUFF         32              # Logical log buffer size (Kbytes)
LOGSMAX         6               # Maximum number of logical log files
CLEANERS        1               # Number of buffer cleaner processes
SHMBASE         0x10000000        # Shared memory base address
SHMVIRTSIZE     8000            # initial virtual shared memory segment size
SHMADD          8192            # Size of new shared memory segments (Kbytes)
SHMTOTAL        0               # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL       300             # Check point interval (in sec)
LRUS            8               # Number of LRU queues
LRU_MAX_DIRTY   60              # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY   50              # 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       32              # Stack size (Kbytes)

/etc/services添加了下面一行
online_service  8000/tcp

/etc/hosts
SCCS IDENTIFICATION
127.0.0.1       scosysv
172.18.4.132    scosysv

论坛徽章:
0
3 [报告]
发表于 2011-09-30 12:36 |只看该作者
都没有人要回答吗

论坛徽章:
0
4 [报告]
发表于 2011-09-30 13:45 |只看该作者
回复 3# 冉然5_1


        再看看online.log?感觉是TCP/IP配置问题。
SQLHOST配置里:
online_tcp    ontlitcp       online         online_service
改为
online_tcp    onsoctcp       scosysv         online_service

论坛徽章:
0
5 [报告]
发表于 2011-09-30 13:50 |只看该作者
06:51:19  Requested shared memory segment size rounded from 8000KB to 8192KB

Fri Sep 30 06:51:21 2011

06:51:21  Event alarms enabled.  ALARMPROG = '/usr/informix/etc/log_full.sh'
06:51:27  DR: DRAUTO is 0 (Off)
06:51:27  Requested shared memory segment size rounded from 280KB to 4096KB
06:51:28  listener-thread: err = -930: oserr = 0: errstr = online: Cannot connec
t to database server (online).

06:51:28  Attempting to bring listener thread down.

06:51:28  Server stopped.

论坛徽章:
0
6 [报告]
发表于 2011-09-30 13:54 |只看该作者
如果改成online_tcp    onsoctcp       scosysv         online_service
初始化会报错
$ oninit -ivy
Checking group membership to determine server run modesucceeded
Reading configuration file '/usr/informix/etc/onconfig.dev'...succeeded
Creating /INFORMIXTMP/.infxdirs ... succeeded
Creating infos file "/usr/informix/etc/.infos.online" ... "/usr/informix/etc/.co
nf.online" ... succeeded
Writing to infos file ... succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 400 kbytes...succeeded
Creating buffer pool 402 kbytes...succeeded
Initializing rhead structure...succeeded
Initializing ASF ...oninit: Fatal error in initializing ASF with 'ASF_INIT_DATA'
flags; asfcode = '25507'.
FAILED

论坛徽章:
0
7 [报告]
发表于 2011-09-30 14:30 |只看该作者
回复 4# 3sane


    改成online_tcp  ontlitcp scosysv online_service后虽然还是有报错,可是后来莫名其妙的可以了,非常感谢你!

论坛徽章:
0
8 [报告]
发表于 2011-09-30 16:08 |只看该作者
系统版本?数据库版本?
把日志完整贴下吧

论坛徽章:
11
金牛座
日期:2015-03-19 16:56:22数据库技术版块每日发帖之星
日期:2016-08-02 06:20:00数据库技术版块每日发帖之星
日期:2016-04-24 06:20:00数据库技术版块每日发帖之星
日期:2016-04-13 06:20:00IT运维版块每日发帖之星
日期:2016-04-13 06:20:00数据库技术版块每日发帖之星
日期:2016-02-03 06:20:00数据库技术版块每日发帖之星
日期:2015-08-06 06:20:00季节之章:春
日期:2015-03-27 15:54:57羊年新春福章
日期:2015-03-27 15:54:37戌狗
日期:2015-03-19 16:56:41数据库技术版块每日发帖之星
日期:2016-08-18 06:20:00
9 [报告]
发表于 2011-09-30 17:03 |只看该作者
回复 1# 冉然5_1


    you must tell us: os, ids version, and online.log ~

论坛徽章:
1
数据库技术版块每日发帖之星
日期:2015-12-09 06:20:00
10 [报告]
发表于 2011-10-05 01:07 |只看该作者
兄弟,sqlhosts错了
按列
第一列(informix servername )  第二列(客户端tcp协议)  第三列(主机名) 第四列(端口号或者端口名)
你的第三列配置错了
应该是scosysv
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP