安装informix时报错,请路过的大哥大姐进来帮忙看下,谢谢!
你好,我在安装solaris 5.8下安装informix 7.3 时出出了以下错误(以下是online.log文件内容):其中:onconfig 中的:ROOTPATH /opt/informix/rootdbs rootdbs文件我是直接在/opt/informix/下用touch 命令
创建的一个文件,不知是否可以。麻烦帮忙解答一下,谢谢啦!!!
17:06:23Informix Dynamic Server Stopped.
17:06:24mt_shm_remove: WARNING: may not have removed all/correct segments
Tue Jul 31 17:06:37 2007
17:06:37Event alarms enabled.ALARMPROG = '/opt/informix/etc/log_full.sh'
17:06:44DR: DRAUTO is 0 (Off)
17:06:44Informix Dynamic Server Version 7.31.UD6W5 Software Serial Number AAC#J880135
17:06:44Assert Failed: chunk failed sanity check
17:06:44Informix 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:45I/O error, Primary Chunk '/opt/informix/rootdbs' -- Offline (sanity)
17:06:45Informix Dynamic Server Stopped.
17:06:45mt_shm_remove: WARNING: may not have removed all/correct segments
Tue Jul 31 17:07:04 2007
17:07:04Event alarms enabled.ALARMPROG = '/opt/informix/etc/log_full.sh'
17:07:10DR: DRAUTO is 0 (Off)
17:07:10Informix Dynamic Server Version 7.31.UD6W5 Software Serial Number AAC#J880135
17:07:10The chunk '/opt/informix/rootdbs' must have READ/WRITE permissions for owner and group.
17:07:10Informix Dynamic Server Stopped.
17:07:10mt_shm_remove: WARNING: may not have removed all/correct segments
Tue Jul 31 17:10:22 2007
17:10:22Event alarms enabled.ALARMPROG = '/opt/informix/etc/log_full.sh'
17:10:29DR: DRAUTO is 0 (Off)
17:10:29Informix Dynamic Server Version 7.31.UD6W5 Software Serial Number AAC#J880135
17:10:29The chunk '/opt/informix/rootdbs' must have READ/WRITE permissions for owner and group.
17:10:29Informix Dynamic Server Stopped.
17:10:29mt_shm_remove: WARNING: may not have removed all/correct segments
Tue Jul 31 17:12:45 2007
17:12:45Event alarms enabled.ALARMPROG = '/opt/informix/etc/log_full.sh'
17:12:52DR: DRAUTO is 0 (Off)
17:12:52Informix Dynamic Server Version 7.31.UD6W5 Software Serial Number AAC#J880135
17:12:52The chunk '/opt/informix/rootdbs' must have READ/WRITE permissions for owner and group.
17:12:52Informix Dynamic Server Stopped.
17:12:52mt_shm_remove: WARNING: may not have removed all/correct segments
Tue Jul 31 17:21:14 2007
17:21:14Event alarms enabled.ALARMPROG = '/opt/informix/etc/log_full.sh'
17:21:21DR: DRAUTO is 0 (Off)
17:21:21Informix Dynamic Server Version 7.31.UD6W5 Software Serial Number AAC#J880135
17:21:21The chunk '/opt/informix/rootdbs' must have READ/WRITE permissions for owner and group.
17:21:21Informix Dynamic Server Stopped.
17:21:21mt_shm_remove: WARNING: may not have removed all/correct segments
Tue Jul 31 17:38:03 2007
17:38:03Event alarms enabled.ALARMPROG = '/opt/informix/etc/log_full.sh'
17:38:10DR: DRAUTO is 0 (Off)
17:38:10Informix Dynamic Server Version 7.31.UD6W5 Software Serial Number AAC#J880135
17:46:19Informix Dynamic Server Initialized -- Complete Disk Initialized.
17:46:19Checkpoint Completed:duration was 1 seconds.
17:46:19Checkpoint loguniq 1, logpos 0xa4
17:46:19Dataskip is now OFF for all dbspaces
17:46:19On-Line Mode
17:46:19Building 'sysmaster' database ...
17:46:23Dynamically allocated new virtual shared memory segment (size 8192KB)
17:46:31'sysmaster' database built successfully.
17:46:31'sysutils' database built successfully.
17:51:49Checkpoint Completed:duration was 0 seconds.
17:51:49Checkpoint loguniq 1, logpos 0x615018
17:56:34shmget: : key 52564801: shared memory already exists
17:56:34mt_shm_init: can't create resident segment
17:56:42shmget: : key 52564801: shared memory already exists
17:56:42mt_shm_init: can't create resident segment
17:56:48Checkpoint Completed:duration was 0 seconds.
17:56:48Checkpoint loguniq 1, logpos 0x616018
17:59:17shmget: : key 52564801: shared memory already exists
17:59:17mt_shm_init: can't create resident segment 請注意這點
The chunk '/opt/informix/rootdbs' must have READ/WRITE permissions for owner and group.
這文件要660的權限,屬主/屬組為informix:informix
相信你已經更改過了~~在17:38分這次初始化中已經成功~~
shmget: : key 52564801: shared memory already exists
可能是你的onconfig裏內存分配存在問題,及前面初始化失敗時內存沒有釋放的原因~~ 谢谢各位的解答,我今天早上上班时把服务器重启了一下后oninit -ivy 还是不成功。
明天我再把相关信息贴上来帮我解答下 :) 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)
MULTIPROCESSOR0 # 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 没有报错,再执行:onstat 时出现:
<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 Aug2 09:05:55 2007
09:05:55Event alarms enabled.ALARMPROG = '/opt/informix/etc/log_full.sh'
09:06:02DR: DRAUTO is 0 (Off)
09:06:02Informix Dynamic Server Version 7.31.UD6W5 Software Serial Number AAC#J880135
09:06:02Informix Dynamic Server Initialized -- Shared Memory Initialized.
09:06:02Physical Recovery Started.
09:06:02Physical Recovery Complete: 0 Pages Restored.
09:06:02Logical Recovery Started.
09:06:02listener-thread: err = -25572: oserr = 0: errstr = : Network driver cannot bind a name to the port.
09:06:02Attempting to bring listener thread down.
09:06:02Server stopped.
09:06:02Informix Dynamic Server Stopped.
09:06:02mt_shm_remove: WARNING: may not have removed all/correct segments
09:07:28shmget: : key 52564801: shared memory already exists
09:07:28mt_shm_init: can't create resident segment
Thu Aug2 09:10:38 2007
09:10:38Event alarms enabled.ALARMPROG = '/opt/informix/etc/log_full.sh'
09:10:45DR: DRAUTO is 0 (Off)
09:10:45Informix Dynamic Server Version 7.31.UD6W5 Software Serial Number AAC#J880135
09:10:45Informix Dynamic Server Initialized -- Shared Memory Initialized.
09:10:45Physical Recovery Started.
09:10:45Physical Recovery Complete: 0 Pages Restored.
09:10:45Logical Recovery Started.
09:10:48Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
09:10:49Onconfig parameter DBSERVERNAME modified from iin_sct_net to iin_sct.
09:10:49Onconfig parameter LOCKS modified from 100000 to 50000.
09:10:49Onconfig parameter BUFFERS modified from 60000 to 100000.
09:10:49Onconfig parameter SHMBASE modified from -2147483648 to 0.
09:10:49Dataskip is now OFF for all dbspaces
09:10:49On-Line Mode
09:10:49Building 'sysmaster' database ...
09:10:49Checkpoint Completed:duration was 0 seconds.
09:10:49Checkpoint loguniq 1, logpos 0x6018
09:10:50Error building 'sysmaster' database.
09:10:50See '/tmp/buildsmi.290'.
09:11:18Checkpoint Completed:duration was 0 seconds.
09:11:18Checkpoint loguniq 1, logpos 0x7018
09:49:03shmget: : key 52564801: shared memory already exists
09:49:03mt_shm_init: can't create resident segment
Thu Aug2 09:50:54 2007
09:50:54Event alarms enabled.ALARMPROG = '/opt/informix/etc/log_full.sh'
09:51:01DR: DRAUTO is 0 (Off)
09:51:01Informix Dynamic Server Version 7.31.UD6W5 Software Serial Number AAC#J880135
09:51:01listener-thread: err = -25572: oserr = 0: errstr = : Network driver cannot bind a name to the port.
09:51:01Attempting to bring listener thread down.
09:51:01Server stopped.
09:51:01Informix Dynamic Server Stopped.
09:51:01mt_shm_remove: WARNING: may not have removed all/correct segments
Thu Aug2 09:51:36 2007
09:51:36Event alarms enabled.ALARMPROG = '/opt/informix/etc/log_full.sh'
09:51:44DR: DRAUTO is 0 (Off)
09:51:44Informix Dynamic Server Version 7.31.UD6W5 Software Serial Number AAC#J880135
09:51:44Informix Dynamic Server Initialized -- Shared Memory Initialized.
09:51:44Physical Recovery Started.
09:51:44Physical Recovery Complete: 0 Pages Restored.
09:51:44Logical Recovery Started.
09:51:44listener-thread: err = -25572: oserr = 0: errstr = : Network driver cannot bind a name to the port.
09:51:44Attempting to bring listener thread down.
09:51:44Server stopped.
09:51:44Informix Dynamic Server Stopped.
09:51:44mt_shm_remove: WARNING: may not have removed all/correct segments 改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用户占用了内存段。 按照“ (暗夜星空)”的方法已解决了问题,谢谢各位的回贴解答!~~~
页:
[1]