求助：informix10在AIX+HACMP下启动异常.txt

lrjcintel

最近公司更换了操作系统，现在安装使用IBMAIX 5.3-08，HACMP 5.4.1.2，informix10，已经装好了两台主机及informix，数据库启动及在HACMP中做双机切换也正常，但安装另外两台主机时，碰到一个奇怪的问题，informix初始化也能成功，但在online.log中有报错，提示：sysmaster不能创建，原因是informix@myhost2_admin不能被信任。

这一点非常奇怪，因为HACMP中配置一个浮动IP，我们安装informix，配置都是针对这个浮动IP来设置的，但不知为什么informix在启动时创建sysmaster时，使用了另外一个主机的管理IP，尽管我们在.rhosts中把这台主机的几个IP都设置了，但还是不能被信任。

下面是 env环境/.profile/  /etc/hosts文件 /ifconfig -a 输出结果 /  .rhosts文件 /  sqlhosts文件 /onconfig配置文件 /online.log
请各位高人帮忙看一下，这是什么问题？


$ pwd
/home/informix
$ env
_=/usr/bin/env
LANG=C
LOGIN=informix
G_BROKEN_FILENAMES=1
PATH=/usr/java14/bin:/usr/java14/jre/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/informix/bin:/usr/bin/X11:/sbin:.:.:/home/informix/bin
LC__FASTMSG=true
INFORMIXSQLHOSTS=/home/informix/etc/sqlhosts
LOGNAME=informix
TERMCAP=/home/informix/etc/termcap
USER=informix
AUTHSTATE=compat
ACCEPTLICENSE=yes
SHELL=/bin/ksh
HOME=/home/informix
INFORMIXDIR=/home/informix
TERM=vt100
ONCONFIG=onconfig.myhost
PWD=/home/informix
TZ=BEIST-8
INFORMIXSERVER=myhostdb
A__z=! LOGNAME
LD_LIBRARY_PATH=/home/informix/lib:/home/informix/lib/esql
$            
$
$
$
$
$
$ cat .profile


PATH=/usr/bin:/etc:/usr/sbin:/usr/ucbHOME/bin:/usr/bin/X11:/sbin:.

export PATH

if [ -s "$MAIL" ]           # This is at Shell startup.  In normal
then echo "$MAILMSG"        # operation, the Shell checks
fi                          # periodically.

export PATH=/usr/java14/bin:/usr/java14/jre/binPATH

export INFORMIXDIR=/home/informix
export INFORMIXSERVER=myhostdb
export ONCONFIG=onconfig.myhost
LD_LIBRARY_PATH=$INFORMIXDIR/libINFORMIXDIR/lib/esql
export LD_LIBRARY_PATH
export ACCEPTLICENSE=yes
export PATH=$PATH:.INFORMIXDIR/bin
export INFORMIXSQLHOSTS=$INFORMIXDIR/etc/sqlhosts
export TERM=vt100
export TERMCAP=$INFORMIXDIR/etc/termcap
$
$

$
$
$
$
$ cat /etc/hosts
# Internet Address      Hostname        # Comments
# 192.9.200.1           net0sample      # ethernet name/address
# 128.100.0.1           token0sample    # token ring name/address
# 10.2.0.2              x25sample       # x.25 name/address
127.0.0.1       loopback localhost myhost2

192.168.2.11 myhost1_svc myhost1
2.2.2.3 myhost1_boot1
3.3.3.3 myhost1_boot2
192.168.2.12 myhost1_admin


192.168.2.13 myhost2_svc  
2.2.2.4 myhost2_boot1
3.3.3.4 myhost2_boot2
192.168.2.14 myhost2_admin
$
$
$
$
$ ifconfig -a
en0: flags=5e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),PSEG,LARGESEND,CHAIN>
        inet 3.3.3.4 netmask 0xffffff00 broadcast 3.3.3.255
        inet 192.168.2.14 netmask 0xffffff00 broadcast 192.168.2.255
         tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
en2: flags=5e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),PSEG,LARGESEND,CHAIN>
        inet 2.2.2.4 netmask 0xffffff00 broadcast 2.2.2.255
        inet 192.168.2.11 netmask 0xffffff00 broadcast 192.168.2.255
         tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
lo0: flags=e08084b<UP,BROADCAST,LOOPBACK,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT>
        inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255
        inet6 ::1/0
         tcp_sendspace 131072 tcp_recvspace 131072 rfc1323 1
$
$
$
$
$
$
$
$
$
$ cat .rhosts
192.168.2.11 informix
192.168.2.12 informix
192.168.2.14 informix
$
$
$
$
$
$ cd etc
$ cat sqlhosts
# ************************************************************************
#
#                                 IBM INC.
#
#                             PROPRIETARY DATA
#
#    Licensed Material - Property Of IBM
#
#    "Restricted Materials of IBM"
#
#    IBM Informix Client SDK
#
#    (c)  Copyright IBM Corporation 2002. All rights reserved.
#
#   Title:      sqlhosts.demo
#   Description:
#               Default sqlhosts file for running demos.
#
#**************************************************************************

#demo_on        onipcshm        on_hostname     on_servername
#demo_se        seipcpip        se_hostname     sqlexec
myhostdb           onsoctcp        192.168.2.11    7777
$
$
$
$
$
$
$ cat onconfig.myhost
#**************************************************************************
#
#  Licensed Material - Property Of IBM
#
#  "Restricted Materials of IBM"
#
#  IBM Informix Dynamic Server
#  (c) Copyright IBM Corporation 1996, 2006 All rights reserved.
#
#  Title:       onconfig.std
#  Description: IBM Informix Dynamic Server Configuration Parameters
#
#**************************************************************************


# System Configuration

SERVERNUM       0               # Unique id corresponding to a OnLine instance
DBSERVERNAME    myhostdb           # Name of default database server
DBSERVERALIASES                 # List of alternate dbservernames
NETTYPE         soctcp,4,100,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  1               # 0 for single-processor, 1 for multi-processor
NUMCPUVPS       8               # Number of user (cpu) vps
SINGLE_CPU_VP   0               # If non-zero, limit number of cpu vps to one


# Data Replication Variables
# DRAUTO: 0 manual, 1 retain type, 2 reverse type
DRAUTO          0               # DR automatic switchover
DRINTERVAL      30              # DR max time between DR buffer flushes (in sec)
DRTIMEOUT       30              # DR network timeout (in sec)
DRLOSTFOUND     /home/informix/etc/dr.lostfound # DR lost+found file path
DRIDXAUTO       0               # DR automatic index repair. 0=off, 1=on

$
$
$
$
$ cd
$ pwd
/home/informix
$ ls
CSDK              dbssodir          help              lib               tmp
ICONNECT          demo              ids_license       msg               uninstall_conn
SERVER            doc               ifm_install.tar   release           uninstall_ids
aaodir            etc               incl              smit.log
bin               extend            installesql       smit.script
chunklink         forms             ism               smit.transaction
conn_license      gls               jvp.log           snmp
$ oninit -iv

This action will initialize IBM Informix Dynamic Server;
any existing IBM Informix Dynamic Server databases will NOT be accessible -
Do you wish to continue (y/n)? y
Checking group membership to determine server run mode...succeeded
Reading configuration file '/home/informix/etc/onconfig.myhost'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Creating infos file "/home/informix/etc/.infos.myhostdb"...succeeded
Linking conf file "/home/informix/etc/.conf.myhostdb"...succeeded
Writing to infos file...succeeded
Checking config parameters...succeeded
WARNING : If you intend to use J/Foundation or GLS for Unicode feature(GLU) with this Server instance, please make sure that your SHMBASE value specifies in onconfig is 0x700000010000000 or above. Otherwise you will have problems while attaching or dynamically adding virtual shared memory segments. Please refer to Server machine notes for more information.
Allocating and attaching to shared memory...succeeded
Creating resident pool 882468 kbytes...succeeded
Allocating 4000016 kbytes for buffer pool of 4K page size...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 7 additional cpu vps...succeeded
Onlining 8 IO vps...succeeded
Initialization of Encryption...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' 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...succeeded
Initialize Async Log Flusher...succeeded
Forking btree cleaner...succeeded
Initializing DBSPACETEMP list...succeeded
Checking database partition index...succeeded
Checking location of physical log...succeeded
Initializing dataskip structure...succeeded
Checking for temporary tables to drop...succeeded
Forking onmode_mon thread...succeeded
Verbose output complete: mode = 5
$
$
$
$
$ onstat -

IBM Informix Dynamic Server Version 10.00.FC8     -- On-Line -- Up 00:00:16 -- 5083088 Kbytes

$
$
$
$ cat online.log
10:35:10  IBM Informix Dynamic Server Started.
10:35:10  WARNING: If you intend to use J/Foundation or GLS for Unicode feature(GLU) with this Server instance, please make sure that your SHMBASE value specifies in onconfig is 0x700000010000000 or above. Otherwise you will have problems while attaching or dynamimically adding virtual shared memory segments. Please refer to Server machine notes for more information.


Sun Sep 28 10:35:11 2008

10:35:11  Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure permissions
10:35:11  Event alarms enabled.  ALARMPROG = '/home/informix/etc/alarmprogram.sh'
10:35:12  Booting Language <c> from module <>
10:35:12  Loading Module <CNULL>
10:35:12  Booting Language <builtin> from module <>
10:35:12  Loading Module <BUILTINNULL>
10:35:17  DR: DRAUTO is 0 (Off)
10:35:17  AIX MP latch code enabled
10:35:17  IBM Informix Dynamic Server Version 10.00.FC8     Software Serial Number AAA#B000000
10:35:23  IBM Informix Dynamic Server Initialized -- Complete Disk Initialized.
10:35:23  Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
                   in DBSPACETEMP: 'tempdbs'
10:35:23  Checkpoint Completed:  duration was 0 seconds.
10:35:23  Checkpoint loguniq 1, logpos 0xf8, timestamp: 0x51

10:35:23  Maximum server connections 0
10:35:23  Dataskip is now OFF for all dbspaces
10:35:23  On-Line Mode
10:35:23  Building 'sysmaster' database ...
10:35:23  listener-thread: err = -956: oserr = 0: errstr = informix@myhost2_admin: Client host or user informix@myhost2_admin is not trusted by the server.

10:35:24  listener-thread: err = -956: oserr = 0: errstr = informix@myhost2_admin: Client host or user informix@myhost2_admin is not trusted by the server.

10:35:24  listener-thread: err = -956: oserr = 0: errstr = informix@myhost2_admin: Client host or user informix@myhost2_admin is not trusted by the server.

10:35:24  listener-thread: err = -956: oserr = 0: errstr = informix@myhost2_admin: Client host or user informix@myhost2_admin is not trusted by the server.


----中间有很多行----

10:35:24  listener-thread: err = -956: oserr = 0: errstr = informix@myhost2_admin: Client host or user informix@myhost2_admin is not trusted by the server.

10:35:24  listener-thread: err = -956: oserr = 0: errstr = informix@myhost2_admin: Client host or user informix@myhost2_admin is not trusted by the server.

10:35:24  listener-thread: err = -956: oserr = 0: errstr = informix@myhost2_admin: Client host or user informix@myhost2_admin is not trusted by the server.

10:35:24  listener-thread: err = -956: oserr = 0: errstr = informix@myhost2_admin: Client host or user informix@myhost2_admin is not trusted by the server.

10:35:24  listener-thread: err = -956: oserr = 0: errstr = informix@myhost2_admin: Client host or user informix@myhost2_admin is not trusted by the server.

13:35:48  Error building 'sysmaster' database.
13:35:48  See '/tmp/buildsmi.229818'.
13:35:54  listener-thread: err = -956: oserr = 0: errstr = informix@myhost1_admin: Client host or user
informix@myhost1_admin is not trusted by the server.

13:36:13  Checkpoint Completed:  duration was 0 seconds.
13:36:13  Checkpoint loguniq 1, logpos 0x1018, timestamp: 0x3b5

liaosnet

启用数据库使用启动IP，而不是使用浮动IP~~

BTW：在oninit -ivy 时,onconfig文件里的phydbs,tempdbs,logdbs都是没有配置的。。从online.log里可以看到你配置了tempdbs，这个实际还是不存在的。。

lrjcintel

因为这台主机是做为数据库服务器，双机，需要基于浮动IP启动数据库，这样双机切换时，数据库也跟着浮动IP切换，这样不会影响client端的使用。

onconfig配置文件，我只是把可能相关的参数贴了过来，没有全部贴上.  tempdbs是稍后要增加一个dbspace。

liaosnet

原帖由 lrjcintel 于 2008-9-28 20:40 发表
因为这台主机是做为数据库服务器，双机，需要基于浮动IP启动数据库，这样双机切换时，数据库也跟着浮动IP切换，这样不会影响client端的使用。

onconfig配置文件，我只是把可能相关的参数贴了过来，没有全部贴 ...

我想你得学下什么是双机~~数据库要用实际IP~
启双机是在启动数据库才启动的,而浮动IP是双机启的..你怎么能做到先浮动IP,后启数据库呢?~~?这里存在逻辑问题..

lrjcintel

谢谢楼上热心答复，不过我们对于双机和数据库的启动在理解上可能有偏差。但我理解你的意思是说，informix在启动时，其实还是基于物理IP在启动？这一块的东西我确实不是很清楚。

简单举例：A机有个10.10.10.1的私有IP，同时有一个192.168.1.11的双机浮动IP，如果在sqlhosts配置 10.10.10.1的私有IP(或是配置主机名，但在/etc/hosts中解析出的主机名对应的IP是10.10.10.1)，则通过192.168.1.X网段是无法访问数据库应用。我说的数据库要启动在浮动IP上，是指的这个。

PS：现在该问题已经解决了，正常情况informix安装时应该不需要配置.rhosts或/etc/hosts.equiv文件，但不知为什么这台主机，在informix中配置了.rhosts信任关系，仍不能在本机正常连接本机数据库，必须在/etc/hosts.equiv中配置了信任关系后，数据库才能正常访问。

现在开始研究这个问题是系统方面的问题？还是informix数据库的问题。但感觉是系统方面的问题居多。

[ 本帖最后由 lrjcintel 于 2008-9-30 15:03 编辑 ]