安装informix 94后,启动出错.
系统为as 5,ids94.系统提示"oninit: Cannot open chunk '/usr/dbchunks/rootlv01'. errno = 2
oninit: Fatal error in shared memory initialization"
具体如下:
$ oninit -ivy
ONCONFIG /usr/informix/etc/onconfig is not owned by user with id 2000.
Checking group membership to determine server run modesucceeded
Reading configuration file '/usr/informix/etc/onconfig'...succeeded
Creating /INFORMIXTMP/.infxdirs ... succeeded
Creating infos file "/usr/informix/etc/.infos.www3" ... "/usr/informix/etc/.cod
Writing to infos file ... succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 2370 kbytes...succeeded
Creating buffer pool 20002 kbytes...succeeded
Initializing rhead structure...succeeded
Initializing ASF ...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 0 additional cpu vps...succeeded
Onlining 2 IO vps...succeeded
Initialization of Encryption...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Forking 1 'ipcshm' listener threads...succeeded
Starting tracing...succeeded
Initializing 1 flushers...succeeded
oninit: Cannot open chunk '/usr/dbchunks/rootlv01'. errno = 2
oninit: Fatal error in shared memory initialization
online.log
14:48:13IBM Informix Dynamic Server Started.Mon Aug 13 14:48:13 2007
14:48:14Booting Language <c> from module <>
14:48:14Loading Module <CNULL>
14:48:14Booting Language <builtin> from module <>
14:48:14Loading Module <BUILTINNULL>
r AAA#B000000
14:48:19Cannot Open Primary Chunk '/usr/dbchunks/rootlv01', errno = 2
14:48:19IBM Informix Dynamic Server Stopped.
Open Pri
14:48:19mt_shm_remove: WARNING: may not have removed all/correct segments
14:48:42IBM Informix Dynamic Server Started.
14:48:42Event alarms enabled.ALARMPROG = '/usr/informix/etc/alarmprogram.sh'
14:48:42Booting Language <c> from module <>
14:48:42Loading Module <CNULL>
14:48:42Booting Language <builtin> from module <>
14:48:42Loading Module <BUILTINNULL>
r AAA#B000000
14:48:47Cannot Open Primary Chunk '/usr/dbchunks/rootlv01', errno = 2
14:48:47IBM Informix Dynamic Server Stopped.
onconfig
# Root Dbspace ConfigurationROOTNAME rootdbs # Root dbspace name
ROOTPATH /usr/dbchunks/rootlv01
# Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 100000 # 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 20000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 6 # Number of logical log files
LOGSIZE 2000 # Logical log size (Kbytes)
# Diagnostics
MSGPATH /usr/informix/online.log # System message log file path
CONSOLE /dev/console # System console message path
# To automatically backup logical logs, edit alarmprogram.sh and set
# BACKUPLOGS=Y
ALARMPROGRAM /usr/informix/etc/alarmprogram.sh # Alarm program path
TBLSPACE_STATS1 # Maintain tblspace statistics
# System Archive Tape Device
TAPEDEV /dev/null # Tape device path
TAPEBLK 32 # 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 32 # Log tape block size (Kbytes)
LTAPESIZE 10240 # Max amount of data to put on log tape (Kbytes)
# Optical
STAGEBLOB # Informix Dynamic Server staging area
# System Configuration
SERVERNUM 0 # Unique id corresponding to a OnLine instance
DBSERVERNAME www3 # Name of default database server
DBSERVERALIASES # List of alternate dbservernames
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 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 5000 # Maximum number of locks
BUFFERS 10000 # 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)
CLEANERS 1 # Number of buffer cleaner processes
SHMBASE 0x10000000 # Shared memory base address
SHMVIRTSIZE 80000 # initial virtual shared memory segment size
SHMADD 8192 # Size of new shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 3600 # Check point interval (in sec)
LRUS 16 # Number of LRU queues
LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes)
# Dynamic Logging
# DYNAMIC_LOGS:
# 2 : server automatically add a new logical log when necessary. (ON)
# 1 : notify DBA to add new logical logs when necessary. (ON)
# 0 : cannot add logical log on the fly. (OFF)
#
# When dynamic logging is on, we can have higher values for LTXHWM/LTXEHWM,
# because the server can add new logical logs during long transaction rollback.
# However, to limit the number of new logical logs being added, LTXHWM/LTXEHWM
# can be set to smaller values.
#
# If dynamic logging is off, LTXHWM/LTXEHWM need to be set to smaller values
# to avoid long transaction rollback hanging the server due to lack of logical
# log space, i.e. 50/60 or lower.
#
# In case of system configured with CDR the difference between LTXHWM and
# LTXEHWM should be atleast 30% so that we could minimize log overrun issue.
DYNAMIC_LOGS 2
LTXHWM 50
LTXEHWM 100
# System Page Size
# BUFFSIZE - OnLine no longer supports this configuration parameter.
# To determine the page size used by OnLine on your platform
# see the last line of output from the coaaand, 'onstat -b'.
# Recovery Variables
# OFF_RECVRY_THREADS:
# Number of parallel worker threads during fast recovery or an offline restore.
# ON_RECVRY_THREADS:
# Number of parallel worker threads during an online restore.
OFF_RECVRY_THREADS 20 # Default number of offline worker threads
ON_RECVRY_THREADS 1 # Default number of online worker threads
# Data Replication Variables
DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)
DRTIMEOUT 30 # DR network timeout (in sec)
DRLOSTFOUND /usr/informix/etc/dr.lostfound # DR lost+found file path
# CDR Variables
CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT5 # DS lockwait timeout (seconds)
ytes)
x)
CDR_SERIAL 0,0 # Serial Column Sequence
CDR_DBSPACE # dbspace for syscdr database
CDR_QHDR_DBSPACE # CDR queue dbspace (default same as catalog)
CDR_QDATA_SBSPACE # List of CDR queue smart blob spaces
# CDR_MAX_DYNAMIC_LOGS
# -1 => unlimited
#0 => disable dynamic log addition
# >0 => limit the no. of dynamic log additions with the specified value.
# Max dynamic log requests that CDR can make within one server session.
CDR_MAX_DYNAMIC_LOGS 0 # Dynamic log addition disabled by default
# Backup/Restore variables
BAR_ACT_LOG /usr/informix/bar_act.log # ON-Bar Log file - not in /tmp please
BAR_DEBUG_LOG /usr/informix/bar_dbug.log
# ON-Bar Debug Log - not in /tmp please
BAR_MAX_BACKUP0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 10
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 31
RESTARTABLE_RESTORE on
RESTARTABLE_RESTORE on
BAR_PROGRESS_FREQ 0
# Informix Storage Manager variables
ISM_DATA_POOL ISMData
ISM_LOG_POOL ISMLogs
# Read Ahead Variables
RA_PAGES 32 # Number of pages to attempt to read ahead
RA_THRESHOLD 16 # Number of pages left before next group
# DBSPACETEMP:
# OnLine equivalent of DBTEMP for SE. This is the list of dbspaces
# that the OnLine SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the OnLine system is brought online.If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.
DBSPACETEMP tempdbs01,tempdbs02,tempdbs03,tempdbs04 # Default temp dbspaces
# DUMP*:
# The following parameters control the type of diagnostics information which
# is preserved when an unanticipated error condition (assertion failure) occurs
# during OnLine operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.
DUMPDIR /tmp # Preserve diagnostics in this directory
DUMPSHMEM 0 # Dump a copy of shared memory
DUMPGCORE 0 # Dump a core image using 'gcore'
DUMPCORE 0 # Dump a core image (Warning:this aborts OnLine)
DUMPCNT 1 # Number of shared memory or gcore dumps for
# a single user's session
FILLFACTOR 90 # Fill factor for building indexes
# method for OnLine to use when determining current time
S(slow)
# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 80 # Maximum allowed pdqpriority
DS_MAX_QUERIES40 # Maximum number of decision support queries
DS_TOTAL_MEMORY 783614 # Decision support memory (Kbytes)
DS_MAX_SCANS 1048576 # Maximum number of decision support scans
DATASKIP off
# OPTCOMPIND
# 0 => Nested loop joins will be preferred (where
# possible) over sortmerge joins and hash joins.
# 1 => If the transaction isolation mode is not
# "repeatable read", optimizer behaves as in (2)
# below.Otherwise it behaves as in (0) above.
# 2 => Use costs regardless of the transaction isolation
# mode.Nested loop joins are not necessarily
# preferred.Optimizer bases its decision purely
# on costs.
OPTCOMPIND 2 # To hint the optimizer
@
2 = WAIT
OPCACHEMAX 0 # Maximum optical cache size (Kbytes)
# HETERO_COaaIT (Gateway participation in distributed transactions)
# 1 => Heterogeneous Coaait is enabled
# 0 (or any other value) => Heterogeneous Coaait is disabled
HETERO_COaaIT 0
lobs
# go if no sbspace is specified when the smartblob is
# created. It is also used by some datablades as
# the location to put their smartblobs.
x
# Server. This is used primarily for Informix Server
# system statistics collection.
BLOCKTIMEOUT 3600 # Default timeout for system block
SYSALARMPROGRAM /usr/informix/etc/evidence.sh # System Alarm program path
# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
OPT_GOAL -1
but 1)
#
# The following are default settings for enabling Java in the database.
# Replace all occurrences of /usr/informix with the value of $INFORMIXDIR.
#VPCLASS jvp,num=1 # Number of JVPs to start with
JVPJAVAHOME /usr/informix/extend/krakatoa/jre
# JRE installation root directory
JVPHOME /usr/informix/extend/krakatoa # Krakatoa installation directory
JVPPROPFILE /usr/informix/extend/krakatoa/.jvpprops # JVP property file
JVPLOGFILE /usr/informix/jvp.log # JVP log file.
JDKVERSION 1.3 # JDK version supported by this server
# The path to the JRE libraries relative to JVPJAVAHOME
JVPJAVALIB /lib/i386/
# The JRE libraries to use for the Java VM
JVPJAVAVM hpi:server:verify:java:net:zip:jpeg
# use JVPARGS to change Java VM configuration
#To display jni call
#JVPARGS -verbose:jni
# Classpath to use upon Java VM start-up (use _g version for debugging)
/krakatoa/jdbc_g.jar
krakatoa/jdbc.jar
NETTYPE ipcshm,1,8,CPU # Configure poll thread(s) for nettype
NETTYPE soctcp,1,8,NET # Configure poll thread(s) for nettype
profile
INFORMIXDIR=/usr/informixexport INFORMIXDIR
PATH=$PATH:$INFORMIXDIR/bin
export PATH
INFORMIXSERVER=www3
ONCONFIG=onconfig
DBDATE=MDY4*
LD_LIBRARY_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:$LD_LIBRARY_PATH
export INFORMIXDIR INFORMIXSERVER ONCONFIG LD_LIBRARY_PATH
PATH=$PATH:$INFORMIXDIR/bin
如参详过论坛中N多其它贴子,整了许多次参数,但还是不行.
主各位高手帮忙看看:em02: '/usr/dbchunks/rootlv01'这个分配的chunk是不是有问题喔？dd这个chunk到/dev/null看报错不？还有就是ln连接的chunk那边是不是没有设置informix数组喔？看看/dev/rrootlv的权限，应该是660吧，informix的用户和数组
回复 #5 小马儿 的帖子
'/usr/dbchunks/rootlv01'系统没有这个文件的.:wink: '/usr/dbchunks/rootlv01'这个文件没有就创建它吧，然后注意权限#chown informix:informix/usr/dbchunks/rootlv01
#chmod 660/usr/dbchunks/rootlv01
这个名字取的，如果是文件，怎么放在/usr文件系统是和不好！！
如果是裸设备，应该是在/dev/ 下，裸设备名字是rrootlv01 "
hello_unix
天使
"'/usr/dbchunks/rootlv01'这个文件没有就创建它吧，然后注意权限"
"
是onconfig里的"ROOTPATH /usr/dbchunks/rootlv01"指向错了,把它指向相应的已建chunks就行了,我已建在usr/informix/dbs下面.设相应权限后,
数据库已可起了了.
但还是有错误提示:
如下
$ oninit -ivy
Checking group membership to determine server run modesucceeded
Reading configuration file '/usr/informix/etc/onconfig'...succeeded
Creating /INFORMIXTMP/.infxdirs ... succeeded
Creating infos file "/usr/informix/etc/.infos.www3" ... "/usr/informix/etc/.cod
Writing to infos file ... succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 2370 kbytes...succeeded
Creating buffer pool 20002 kbytes...succeeded
Initializing rhead structure...succeeded
Initializing ASF ...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 0 additional cpu vps...succeeded
Onlining 2 IO vps...succeeded
Initialization of Encryption...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Forking 1 'ipcshm' listener threads...succeeded
Starting tracing...succeeded
Initializing 1 flushers...succeeded
Initializing log/checkpoint information...succeeded
Opening primary chunks...succeeded
Opening mirror chunks...succeeded
Initializing dbspaces...succeeded
Validating chunks...succeeded
Creating database partition
Initialize Async Log Flusher...succeeded
Forking btree cleaner...succeeded
Initializing DBSPACETEMP list
Checking database partition index...succeeded
Checking location of physical log...succeeded
Initializing dataskip structure...succeeded
Checking for temporary tables to drop
Forking onmode_mon thread...succeeded
Verbose output complete: mode = 5
$ tail: 无法打开 “+4” 读取数据: 没有那个文件或目录
SENDER IS NULL NO MAIL WILL BE SENT
grep: write error: 断开的管道
online:
Tue Aug 14 10:08:42 2007
10:08:42Booting Language <c> from module <>
10:08:42Loading Module <CNULL>
10:08:42Booting Language <builtin> from module <>
10:08:42Loading Module <BUILTINNULL>
r AAA#B000000
10:08:49IBM Informix Dynamic Server Initialized -- Complete Disk Initialized.
10:08:49Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
in DBSPACETEMP: 'tempdbs01'
10:08:49Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
in DBSPACETEMP: 'tempdbs02'
10:08:49Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
in DBSPACETEMP: 'tempdbs03'
10:08:49Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
in DBSPACETEMP: 'tempdbs04'
10:08:49Checkpoint Completed:duration was 0 seconds.
10:08:49Checkpoint loguniq 1, logpos 0xd0, timestamp: 0x51
10:08:49Maximum server connections 0
10:08:49Dataskip is now OFF for all dbspaces
10:08:49On-Line Mode
10:08:49Building 'sysmaster' database ...
10:08:49Error building 'sysmaster' database.
10:08:49See '/tmp/buildsmi.3001'.
10:08:49Assert Failed: build_smi failed
10:08:49IBM Informix Dynamic Server Version 9.40.UC6
10:08:49 Who: Session(12, informix@aawww003, 0, 0x11846978)
File: rspseudo.c Line: 7947
10:08:49 Results: Cannot build/check 'sysmaster' database
10:08:49stack trace for pid 3001 written to /tmp/af.3f90eb0
10:08:49 See Also: /tmp/af.3f90eb0
但onstat -i显示数据库已ON了
$ onstat -i
IBM Informix Dynamic Server Version 9.40.UC6 -- On-Line -- Up 00:01:32 -- 1s
:em02:
有人知这样的错误提示是有什么不当之处吗?
谢谢各位关注,鸣谢"小马儿 "及"hello_unix "两位的指正.:mrgreen: DBSPACETEMP tempdbs01,tempdbs02,tempdbs03,tempdbs04 # Default temp dbspaces
這些dbs是在初始化後才建立的~~~你剛初始化的時候並沒有建立....
你在oninit -ivy時建表不成功,建議重新初始化一次~~
页:
[1]
2