免费注册 查看新帖 |

Chinaunix

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

安装informix时报错,请路过的大哥大姐进来帮忙看下,谢谢! [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2007-07-31 22:40 |只看该作者 |倒序浏览
你好,我在安装solaris 5.8下安装informix 7.3 时出出了以下错误(以下是online.log文件内容):
其中:onconfig 中的:ROOTPATH        /opt/informix/rootdbs rootdbs文件我是直接在/opt/informix/下用touch 命令
创建的一个文件,不知是否可以。麻烦帮忙解答一下,谢谢啦!!!
17:06:23  Informix Dynamic Server Stopped.
17:06:24  mt_shm_remove: WARNING: may not have removed all/correct segments


Tue Jul 31 17:06:37 2007

17:06:37  Event alarms enabled.  ALARMPROG = '/opt/informix/etc/log_full.sh'
17:06:44  DR: DRAUTO is 0 (Off)
17:06:44  Informix Dynamic Server Version 7.31.UD6W5   Software Serial Number AAC#J880135
17:06:44  Assert Failed: chunk failed sanity check

17:06:44  Informix Dynamic Server Version 7.31.UD6W5
17:06:44   Who: Session(1, informix@sct, 0, 353607704)
                Thread(11, main_loop(), 15112018, 1)
                File: rspartn.c Line: 7370
17:06:44   Results: Chunk 1 is being taken OFFLINE.
17:06:44   Action: Restore chunk from archive. If this is a temporary dbspace
        chunk, drop and add the dbspace to enable it.
17:06:45   See Also: /tmp/af.3f3fba4
17:06:45  I/O error, Primary Chunk '/opt/informix/rootdbs' -- Offline (sanity)
17:06:45  Informix Dynamic Server Stopped.
17:06:45  mt_shm_remove: WARNING: may not have removed all/correct segments


Tue Jul 31 17:07:04 2007

17:07:04  Event alarms enabled.  ALARMPROG = '/opt/informix/etc/log_full.sh'
17:07:10  DR: DRAUTO is 0 (Off)
17:07:10  Informix Dynamic Server Version 7.31.UD6W5   Software Serial Number AAC#J880135
17:07:10  The chunk '/opt/informix/rootdbs' must have READ/WRITE permissions for owner and group.

17:07:10  Informix Dynamic Server Stopped.
17:07:10  mt_shm_remove: WARNING: may not have removed all/correct segments


Tue Jul 31 17:10:22 2007

17:10:22  Event alarms enabled.  ALARMPROG = '/opt/informix/etc/log_full.sh'
17:10:29  DR: DRAUTO is 0 (Off)
17:10:29  Informix Dynamic Server Version 7.31.UD6W5   Software Serial Number AAC#J880135
17:10:29  The chunk '/opt/informix/rootdbs' must have READ/WRITE permissions for owner and group.

17:10:29  Informix Dynamic Server Stopped.
17:10:29  mt_shm_remove: WARNING: may not have removed all/correct segments


Tue Jul 31 17:12:45 2007

17:12:45  Event alarms enabled.  ALARMPROG = '/opt/informix/etc/log_full.sh'
17:12:52  DR: DRAUTO is 0 (Off)
17:12:52  Informix Dynamic Server Version 7.31.UD6W5   Software Serial Number AAC#J880135
17:12:52  The chunk '/opt/informix/rootdbs' must have READ/WRITE permissions for owner and group.

17:12:52  Informix Dynamic Server Stopped.
17:12:52  mt_shm_remove: WARNING: may not have removed all/correct segments


Tue Jul 31 17:21:14 2007

17:21:14  Event alarms enabled.  ALARMPROG = '/opt/informix/etc/log_full.sh'
17:21:21  DR: DRAUTO is 0 (Off)
17:21:21  Informix Dynamic Server Version 7.31.UD6W5   Software Serial Number AAC#J880135
17:21:21  The chunk '/opt/informix/rootdbs' must have READ/WRITE permissions for owner and group.

17:21:21  Informix Dynamic Server Stopped.
17:21:21  mt_shm_remove: WARNING: may not have removed all/correct segments


Tue Jul 31 17:38:03 2007

17:38:03  Event alarms enabled.  ALARMPROG = '/opt/informix/etc/log_full.sh'
17:38:10  DR: DRAUTO is 0 (Off)
17:38:10  Informix Dynamic Server Version 7.31.UD6W5   Software Serial Number AAC#J880135
17:46:19  Informix Dynamic Server Initialized -- Complete Disk Initialized.
17:46:19  Checkpoint Completed:  duration was 1 seconds.
17:46:19  Checkpoint loguniq 1, logpos 0xa4

17:46:19  Dataskip is now OFF for all dbspaces
17:46:19  On-Line Mode
17:46:19  Building 'sysmaster' database ...
17:46:23  Dynamically allocated new virtual shared memory segment (size 8192KB)
17:46:31  'sysmaster' database built successfully.
17:46:31  'sysutils' database built successfully.
17:51:49  Checkpoint Completed:  duration was 0 seconds.
17:51:49  Checkpoint loguniq 1, logpos 0x615018

17:56:34  shmget: [EEXIST][17]: key 52564801: shared memory already exists
17:56:34  mt_shm_init: can't create resident segment

17:56:42  shmget: [EEXIST][17]: key 52564801: shared memory already exists
17:56:42  mt_shm_init: can't create resident segment

17:56:48  Checkpoint Completed:  duration was 0 seconds.
17:56:48  Checkpoint loguniq 1, logpos 0x616018

17:59:17  shmget: [EEXIST][17]: key 52564801: shared memory already exists
17:59:17  mt_shm_init: can't create resident segment

论坛徽章:
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
2 [报告]
发表于 2007-08-01 10:07 |只看该作者
請注意這點
The chunk '/opt/informix/rootdbs' must have READ/WRITE permissions for owner and group.
這文件要660的權限,屬主/屬組為informix:informix

相信你已經更改過了~~在17:38分這次初始化中已經成功~~

shmget: [EEXIST][17]: key 52564801: shared memory already exists
可能是你的onconfig裏內存分配存在問題,及前面初始化失敗時內存沒有釋放的原因~~

论坛徽章:
0
3 [报告]
发表于 2007-08-01 12:42 |只看该作者
提示: 作者被禁止或删除 内容自动屏蔽

论坛徽章:
0
4 [报告]
发表于 2007-08-01 22:52 |只看该作者
谢谢各位的解答,我今天早上上班时把服务器重启了一下后oninit -ivy 还是不成功。
明天我再把相关信息贴上来帮我解答下 :)

论坛徽章:
0
5 [报告]
发表于 2007-08-02 09:52 |只看该作者
onconfig 配置:

# Root Dbspace Configuration

ROOTNAME        rootdbs         # Root dbspace name
ROOTPATH        /opt/informix/dbs/rootdbs
                                # Path for device containing root dbspace
ROOTOFFSET      50              # Offset of root dbspace into device (Kbytes)
ROOTSIZE        2000000         # Size of root dbspace (Kbytes)

# System Configuration

SERVERNUM       0               # Unique id corresponding to a Dynamic Server instance
DBSERVERNAME    iin_sct     # Name of default database server
DBSERVERALIASES iin_sct_net         # 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
#NETTYPE soctcp,2,8,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       20              # 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           50000          # Maximum number of locks
BUFFERS         100000           # Maximum number of shared buffers
NUMAIOVPS       2               # 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         0x0        # 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       0               # 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)

sqlhosts配置:
#demo_on        onipcshm        on_hostname     on_servername
#demo_se        seipcpip        se_hostname     sqlexec
iin_sct         onipcshm        sct             sqlexec
iin_sct_net     ontlitcp      sct             sqlexec_net
#iin_sct         onipcshm       sct              sqlexec
#iin_sct_net     onsoctcp      sct              sqlexec_net

/etc/services配置:
sqlexec         9001/tcp                        # informix port iin_sct
sqlexec_net     9002/tcp                        # informix port iin_sct_net

如果按以上配置执行oninit -ivy
则出现:<11 /opt/informix/etc >oninit -ivy
Checking group membership to determine server run modesucceeded
Reading configuration file '/opt/informix/etc/onconfig'...succeeded
Creating /INFORMIXTMP/.infxdirs ... succeeded
Creating infos file "/opt/informix/etc/.infos.iin_sct" ... "/opt/informix/etc/.conf.iin_sct" ... succeeded
Writing to infos file ... succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...FAILED
oninit: Fatal error in shared memory creation
如果将onconfig 文件中的值改为:SERVERNUM       2
则出现:<14 /opt/informix/etc >oninit -ivy
Checking group membership to determine server run modesucceeded
Reading configuration file '/opt/informix/etc/onconfig'...succeeded
Creating /INFORMIXTMP/.infxdirs ... succeeded
Creating infos file "/opt/informix/etc/.infos.iin_sct" ... "/opt/informix/etc/.conf.iin_sct" ... succeeded
Writing to infos file ... succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 14450 kbytes...succeeded
Creating buffer pool 200002 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 19 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...succeeded
Starting tracing...succeeded
Initializing 1 flushers...succeeded
Initializing log/checkpoint information...<15 /opt/informix/etc >
再执行:oninit 没有报错,再执行nstat 时出现:
<16 /opt/informix/etc >oninit
<17 /opt/informix/etc >onstat
shared memory not initialized for INFORMIXSERVER 'iin_sct_net'
<18 /opt/informix/etc >
请问这是怎么回事?呵呵,以下是online.log文件内容:

Thu Aug  2 09:05:55 2007

09:05:55  Event alarms enabled.  ALARMPROG = '/opt/informix/etc/log_full.sh'
09:06:02  DR: DRAUTO is 0 (Off)
09:06:02  Informix Dynamic Server Version 7.31.UD6W5   Software Serial Number AAC#J880135
09:06:02  Informix Dynamic Server Initialized -- Shared Memory Initialized.
09:06:02  Physical Recovery Started.
09:06:02  Physical Recovery Complete: 0 Pages Restored.
09:06:02  Logical Recovery Started.
09:06:02  listener-thread: err = -25572: oserr = 0: errstr = : Network driver cannot bind a name to the port.

09:06:02  Attempting to bring listener thread down.

09:06:02  Server stopped.

09:06:02  Informix Dynamic Server Stopped.
09:06:02  mt_shm_remove: WARNING: may not have removed all/correct segments

09:07:28  shmget: [EEXIST][17]: key 52564801: shared memory already exists
09:07:28  mt_shm_init: can't create resident segment


Thu Aug  2 09:10:38 2007

09:10:38  Event alarms enabled.  ALARMPROG = '/opt/informix/etc/log_full.sh'
09:10:45  DR: DRAUTO is 0 (Off)
09:10:45  Informix Dynamic Server Version 7.31.UD6W5   Software Serial Number AAC#J880135
09:10:45  Informix Dynamic Server Initialized -- Shared Memory Initialized.
09:10:45  Physical Recovery Started.
09:10:45  Physical Recovery Complete: 0 Pages Restored.
09:10:45  Logical Recovery Started.
09:10:48  Logical Recovery Complete.
        0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

09:10:49  Onconfig parameter DBSERVERNAME modified from iin_sct_net to iin_sct.
09:10:49  Onconfig parameter LOCKS modified from 100000 to 50000.
09:10:49  Onconfig parameter BUFFERS modified from 60000 to 100000.
09:10:49  Onconfig parameter SHMBASE modified from -2147483648 to 0.
09:10:49  Dataskip is now OFF for all dbspaces
09:10:49  On-Line Mode
09:10:49  Building 'sysmaster' database ...
09:10:49  Checkpoint Completed:  duration was 0 seconds.
09:10:49  Checkpoint loguniq 1, logpos 0x6018

09:10:50  Error building 'sysmaster' database.
09:10:50  See '/tmp/buildsmi.290'.
09:11:18  Checkpoint Completed:  duration was 0 seconds.
09:11:18  Checkpoint loguniq 1, logpos 0x7018

09:49:03  shmget: [EEXIST][17]: key 52564801: shared memory already exists
09:49:03  mt_shm_init: can't create resident segment


Thu Aug  2 09:50:54 2007

09:50:54  Event alarms enabled.  ALARMPROG = '/opt/informix/etc/log_full.sh'
09:51:01  DR: DRAUTO is 0 (Off)
09:51:01  Informix Dynamic Server Version 7.31.UD6W5   Software Serial Number AAC#J880135
09:51:01  listener-thread: err = -25572: oserr = 0: errstr = : Network driver cannot bind a name to the port.

09:51:01  Attempting to bring listener thread down.

09:51:01  Server stopped.

09:51:01  Informix Dynamic Server Stopped.
09:51:01  mt_shm_remove: WARNING: may not have removed all/correct segments


Thu Aug  2 09:51:36 2007

09:51:36  Event alarms enabled.  ALARMPROG = '/opt/informix/etc/log_full.sh'
09:51:44  DR: DRAUTO is 0 (Off)
09:51:44  Informix Dynamic Server Version 7.31.UD6W5   Software Serial Number AAC#J880135
09:51:44  Informix Dynamic Server Initialized -- Shared Memory Initialized.
09:51:44  Physical Recovery Started.
09:51:44  Physical Recovery Complete: 0 Pages Restored.
09:51:44  Logical Recovery Started.
09:51:44  listener-thread: err = -25572: oserr = 0: errstr = : Network driver cannot bind a name to the port.

09:51:44  Attempting to bring listener thread down.

09:51:44  Server stopped.

09:51:44  Informix Dynamic Server Stopped.
09:51:44  mt_shm_remove: WARNING: may not have removed all/correct segments

论坛徽章:
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
6 [报告]
发表于 2007-08-02 13:57 |只看该作者
改onconfig文件到保守一些的参数再做一次。。
NETTYPE          # Configure poll thread(s) for nettype ->暂时不设
#NETTYPE         tlitcp,1,20,NET # Configure poll thread(s) for nettype

NUMCPUVPS       1              # Number of user (cpu) vps ->暂时改为1

BUFFERS         10000           # Maximum number of shared buffers  ->暂时减小10倍为10000


CKPTINTVL       3600               # Check point interval (in sec)   ->这个设置成3600先。



oninit -ivy前请先用ipcs检查下是否有informix用户占用了内存段。

论坛徽章:
0
7 [报告]
发表于 2007-08-02 20:29 |只看该作者
按照“ (暗夜星空)”的方法已解决了问题,谢谢各位的回贴解答!~~~
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP