AIX-informix 初始化问题

这几天进行informix7.X数据库的安装,将安装出现的问题进行总结。

     一般情况下，数据库要求使用informix用户和informix组来安装，这样出现的问题比较少，也容易安装些。

 

1．初始化出现：

Checking group membership to determine server run modesucceeded

Reading configuration file '/opt/informix4/etc/onconfig'...succeeded

Creating /INFORMIXTMP/.infxdirs ... succeeded

Creating infos file "/opt/informix4/etc/.infos.scp4" ... "/opt/informix4/etc/.co

nf.scp4" ... succeeded

Writing to infos file ... succeeded

Checking config parameters...succeeded

Allocating and attaching to shared memory...FAILED

oninit: Fatal error in shared memory creation

online.log出现：

01:45:13  shmget: [EEXIST][17]: key 52a24801: shared memory already exists

01:45:13  mt_shm_init: can't create resident segment

解决：

修改配置文件onconfig中的服务器标识号（默认为0），只要是唯一就可以了，不能过太。在多实例安装中常出现此问题。例如

SERVERNUM       49          # Unique id corresponding to a Dynamic Server instance

 

2，初始化最后出现

Unable to open input file 's'

Unable to open input file 'c'

Online.log中为：

Dataskip is now OFF for all dbspaces

01:47:33  On-Line Mode

01:47:33  Building 'sysmaster' database ...

01:47:33  Assert Failed: build_smi failed

01:47:33  Informix Dynamic Server Version 7.31.UD6W4

01:47:33   Who: Session(12, informix@ibmocs, 0, 1074267956)

                Thread(21, build_smi, 40059904, 1)

                File: rspseudo.c Line: 7603

01:47:33   Results: Cannot build/check 'sysmaster' database

01:47:35   See Also: /tmp/af.3fd20b5, shmem.3fd20b5.0

01:47:35  Error 1 occurred executing /bin/sh /bin/sh -c /opt/informix4/etc/log_f

ull.sh 3 7 "Dynamic Server Initialization failure." "build_smi failed" /tmp/af.3

fd20b5

 

解决：

解决了这个问题，但不知问题所在。使用informix用户安装不应出现这个问题。用同组中的其它用户也可以安装成功的,只是有一步要注意,都不知为什么.

最好看看你的根目录下面有没有INFORMIXTMP目录。并且看看informix 用户有没有权限。

看看是不是你的数据库没有空间了，或者逻辑日志满了，或者你的导入文件本身存在问题等等。

 

3．提示信息到nitializing 1 flushers...succeeded就结束了。

 

Online.log中的内容：

1:59:28  Event alarms enabled.  ALARMPROG = '/opt/informix4/etc/log_full.sh'

01:59:33  DR: DRAUTO is 0 (Off)

01:59:33  AIX MP latch code enabled

01:59:33  Requested shared memory segment size rounded from 588KB to 592KB

01:59:33  Informix Dynamic Server Version 7.31.UD6W4   Software Serial Number AC

P#J267193

01:59:33  listener-thread: err = -25572: oserr = 67: errstr = : Network driver c

annot bind a name to the port.

 System error = 67.

01:59:33  Attempting to bring listener thread down.

 

01:59:33  Server stopped.

 

01:59:33  Informix Dynamic Server Stopped.

01:59:33  mt_shm_remove: WARNING: may not have removed all/correct segments

 

解决：

端口问题。

看sqlhosts是否正确，与/etc/services中的商品是否对应。

 

还要好多问题,当时没有总结....