Linux下informix安装

只有先初始化数据库后，才能用dbaccess 初始化数据库之前，先运行/home/informix/下的.bash_profile 1．创建informix用户和组。 useradd informix 2． informix用户登录，并设置一些环境变量 在~.bashrc里追加如下内容： INFORMIXDIR=/home/informix INFORMIXSERVER=pdc //主机名 INFORMIXTERM=terminfo DBPATH=$INFORMIXDIR TERMCAP=$INFORMIXDIR/etc/termcap PATH=$INFORMIXDIR/bin:$HOME/bin:$PATH ONCONFIG=onconfig.std DB_LOCALE=zh_cn.gb CLIENT_LOCALE=zh_cn.gb DB_LANG=zh_cn.gb DBDATE=MDY4/ export INFORMIXDIR PATH ONCONFIG DB_LANG DB_LOCALE CLIENT_LOCALE DBDATE INFORMIXSERVER SQLEXEC=$INFORMIXDIR/lib/sqlexec 3．source .bashrc使上面生效。 4．tar xvf iif.11.50.UC3DE.Linux-RHEL4.tar 5．切换到root用户下执行ids_install这个脚本，按照提示进行安装。 6．安装完成后进入etc目录，cp onconfig.std onconfig 7．修改sqlhost文件加入：pdc     onsoctcp        192.168.0.145 sqlexec 8．修改/etc/services文件加入内容如下：sqlexec     1526/tcp #informix DBMS 9．初始化数据库：oninit –ivy，提示“INFORMIXSERVER does not match DBSERVERNAME or any of the DBSERVERALIASES.FAILED”错误，这时参看你的主机名和环境变量里设置的是否一样。 报错信息“oninit: Fatal error in shared memory initialization WARNING: server initialization failed, or possibly timed out (if -w was used). Check the message log, online.log, for errors.”这时查看tmp/online.log日志。 解决办法：touch tmp/ touch demo_on.rootdbs; chmod 660 demo_on.rootdbs 再执行：oninit –ivy 10.结束oninit进程：onmode –ky，启动：oninit。 ps –e可以看到oninit进程。netstat -na|grep 1526 11．执行命令：onmonitor Termcap entry too long Too many tc= indirections Program stopped at "tb4_main.4gl", line number 82. FORMS statement error number -1170. The type of your terminal is unknown to the system. 以上错误解决方法：export TERMINFO=/home/informix/etc/typetab export TERMCAP=$INFORMIXDIR/etc/termcap 但是执行onmonitor后不能用键盘右键操作，这时修改.bashrc文件加入： export TERMINFO=/home/informix/etc/typetab 12．创建数据库： Mkdir data cd data touch db1 chmod 660 db1 dbaccess Informix出错Fatal error in shared memory initialization及解决2011-04-13 12:48阅读(70) 分享 在几个虚拟机上安装的Informix的都出现同样的错误： Fatal error in shared memory initialization. 包括安装于VirtualBox下的Arch64, Debian64, 安装于vmware下的Solaris10 x64和Solaris 11 Express x64，其中安装的都是Informix Innovator-C Edition或者Informix developer Edition，具体没考查，多半是前者。 甚至怀疑是宿主机的问题，但由是宿主机启的的程序太式，关闭太麻烦。 怀疑是不是版本问题，查了 http://www.ibm.com/developerworks/data/library/techarticle/dm-0801doe/index.html，似乎不存这个问题，毕竟以前启动过！ 网上搜索，但没解决问题。 于是又在另一个安装于Hyper-V的Arch上面安装，结果是第一次还好，第二次出现同样的问题！ 可是明明以前启动过！考虑是不是未知数没设置正确，也没解决。提示加w参数，即执行 oninit -ivyw 然后在informix目录查看ol_informix.log文件，其提示: DISK INITIALIZATION ABORTED: potential instance overwrite detected. To disable this check, set FULL_DISK_INIT to 1 in your config file and retry. 03:34:52 oninit: Fatal error in shared memory initialization 03:32:52 IBM Informix Dynamic Server Stopped. 03:34:52 mt_shm_remove: WARNING: may not have removed all/correct segments 继续尝试搜索 mt_shm_remove: WARNING: may not have removed all/correct segments 最后还是在IBM informatio center找到答案。 Cause When the operating system tried to remove the shared-memory segments associated with the database server, the last segment did not equal the last segment registered internally. This situation is probably due to the unexpected failure of the database server. Action Remove any segments that were not cleaned up. 按其操作，在onconfig文件中找到FULL_DISK_INIT，将其后的0改为1，再将启动，成功！ 想想，之所以出现同样的问题，最有可能是我没有正常关闭Informix就启动操作系统了。 http://www.informixchina.net/home/space.php?uid=2096&do=blog&id=1352 参考： http://www.google.com.hk/search?hl=zh-CN&safe=strict&biw=1397&bih=497&q=mt_shm_remove%3A+WARNING%3A+may+not+have+removed+all%2Fcorrect+segments&aq=o&aqi=&aql=&oq= http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=/com.ibm.adref.doc/ids_adr_0746.htm http://www.dbforums.com/informix/1117842-mt_shm_remove-warning-may-not-have-removed-all-correct-segments.html http://bbs.chinaunix.net/viewthread.php?tid=262329 http://www.iiug.org/forums/iiug-esp/index.cgi/noframes/read/2389 http://bbs.chinaunix.net/viewthread.php?tid=2298097&rpid=15493632&ordertype=0&page=1#pid15493632 [informix@yuyu ~]$ 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/app/etc/onconfig'...succeeded Creating /INFORMIXTMP/.infxdirs...succeeded Checking config parameters...succeeded Allocating and attaching to shared memory...succeeded Creating resident pool 10582 kbytes...succeeded Allocating 100016 kbytes for buffer pool of 2K page size...succeeded Creating infos file "/home/informix/app/etc/.infos.demo_on"...succeeded Linking conf file "/home/informix/app/etc/.conf.demo_on"...succeeded Initializing rhead structure...succeeded Writing to infos file...succeeded Initialization of Encryption...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 Forking main_loop thread...succeeded Initializing DR structures...succeeded Forking 1 'ipcshm' listener threads...succeeded Starting tracing...succeeded Initializing 8 flushers...succeeded oninit: Fatal error in shared memory initialization WARNING: server initialization failed, or possibly timed out (if -w was used). Check the message log, online.log, for errors. 查看online.log日志 Sun Apr 24 06:24:02 2011 06:24:02  Event alarms enabled.  ALARMPROG = '/home/informix/app/etc/alarmprogram.sh' 06:24:02  Booting Language <c> from module <> 06:24:02  Loading Module <CNULL> 06:24:02  Booting Language <builtin> from module <> 06:24:02  Loading Module <BUILTINNULL> 06:24:08  DR: DRAUTO is 0 (Off) 06:24:08  DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) 06:24:08  IBM Informix Dynamic Server Version 11.70.UC1DE Software Serial Number AAA#B000000 06:24:08  DISK INITIALIZATION ABORTED: potential instance overwrite detected. To disable this check, set FULL_DISK_INIT to 1 in your config file and retry. 06:24:08  oninit: Fatal error in shared memory initialization 06:24:08  IBM Informix Dynamic Server Stopped. 06:24:08  mt_shm_remove: WARNING: may not have removed all/correct segments 配置文件内容onconfig ROOTNAME rootdbs ROOTPATH /home/informix/app/ol_informix1170/dbspaces/online_root ROOTOFFSET 0 ROOTSIZE 200000 MIRROR 0 MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirror MIRROROFFSET 0 PHYSFILE 50000 PLOG_OVERFLOW_PATH  $INFORMIXDIR/tmp PHYSBUFF 128 LOGFILES 6 LOGSIZE 10000 DYNAMIC_LOGS 2 LOGBUFF 64 LTXHWM 70 LTXEHWM 80 MSGPATH /home/informix/app/online.log CONSOLE $INFORMIXDIR/tmp/online.con TBLTBLFIRST 0 TBLTBLNEXT 0 TBLSPACE_STATS 1 DBSPACETEMP  SBSPACETEMP SBSPACENAME SYSSBSPACENAME ONDBSPACEDOWN 2 SERVERNUM 0 DBSERVERNAME demo_on DBSERVERALIASES FULL_DISK_INIT 0 NETTYPE ipcshm,1,50,CPU LISTEN_TIMEOUT 60 MAX_INCOMPLETE_CONNECTIONS 1024 FASTPOLL 1 NS_CACHE host=900,service=900,user=900,group=900 MULTIPROCESSOR 0 VPCLASS cpu,num=1,noage VP_MEMORY_CACHE_KB 0 SINGLE_CPU_VP 0 #VPCLASS aio,num=1 CLEANERS 8 AUTO_AIOVPS 1 DIRECT_IO 0 LOCKS 20000 DEF_TABLE_LOCKMODE page  RESIDENT 0 SHMBASE 0x44000000L  SHMVIRTSIZE 32656 SHMADD 8192 EXTSHMADD 8192 SHMTOTAL 0 SHMVIRT_ALLOCSEG 0,3 SHMNOACCESS CKPTINTVL 300 AUTO_CKPTS 1 RTO_SERVER_RESTART 0 BLOCKTIMEOUT 3600 CONVERSION_GUARD 2 RESTORE_POINT_DIR $INFORMIXDIR/tmp TXTIMEOUT 300 DEADLOCK_TIMEOUT 60 HETERO_COMMIT 0 TAPEDEV /dev/tapedev TAPEBLK 32 TAPESIZE 0 LTAPEDEV /dev/null LTAPEBLK 32 LTAPESIZE 0 BAR_ACT_LOG $INFORMIXDIR/tmp/bar_act.log BAR_DEBUG_LOG $INFORMIXDIR/tmp/bar_dbug.log BAR_DEBUG 0 BAR_MAX_BACKUP 0 BAR_RETRY 1 BAR_NB_XPORT_COUNT 20 BAR_XFER_BUF_SIZE 31 RESTARTABLE_RESTORE ON BAR_PROGRESS_FREQ 0 BAR_BSALIB_PATH BACKUP_FILTER RESTORE_FILTER BAR_PERFORMANCE 0 BAR_CKPTSEC_TIMEOUT 15 ISM_DATA_POOL ISMData ISM_LOG_POOL ISMLogs DD_HASHSIZE 31 DD_HASHMAX  10 DS_HASHSIZE 31 DS_POOLSIZE 127 PC_HASHSIZE 31 PC_POOLSIZE 127 PRELOAD_DLL_FILE STMT_CACHE 0 STMT_CACHE_HITS 0 STMT_CACHE_SIZE 512 STMT_CACHE_NOLIMIT 0 STMT_CACHE_NUMPOOL 1 USEOSTIME 0 STACKSIZE 32 ALLOW_NEWLINE 0 USELASTCOMMITTED NONE FILLFACTOR 90 MAX_FILL_DATA_PAGES 0 BTSCANNER num=1,threshold=5000,rangesize=-1,alice=6,compression=default ONLIDX_MAXMEM 5120 MAX_PDQPRIORITY 100 DS_MAX_QUERIES DS_TOTAL_MEMORY DS_MAX_SCANS 1048576 DS_NONPDQ_QUERY_MEM 128 DATASKIP OPTCOMPIND 2 DIRECTIVES 1 EXT_DIRECTIVES 0 OPT_GOAL -1 IFX_FOLDVIEW 0 AUTO_REPREPARE 1 AUTO_STAT_MODE 1 STATCHANGE 10 RA_PAGES     64 RA_THRESHOLD 16 BATCHEDREAD_TABLE   1 BATCHEDREAD_INDEX   1 BATCHEDREAD_KEYONLY 0 EXPLAIN_STAT 1 #SQLTRACE level=low,ntraces=1000,size=2,mode=global #DBCREATE_PERMISSION informix #DB_LIBRARY_PATH  IFX_EXTEND_ROLE 1 SECURITY_LOCALCONNECTION UNSECURE_ONSTAT ADMIN_USER_MODE_WITH_DBSA ADMIN_MODE_USERS SSL_KEYSTORE_LABEL PLCY_POOLSIZE 127 PLCY_HASHSIZE 31 USRC_POOLSIZE 127 USRC_HASHSIZE 31 STAGEBLOB OPCACHEMAX 0 ENCRYPT_HDR ENCRYPT_SMX ENCRYPT_CDR 0 ENCRYPT_CIPHERS ENCRYPT_MAC ENCRYPT_MACFILE ENCRYPT_SWITCH CDR_EVALTHREADS 1,2 CDR_DSLOCKWAIT 5 CDR_QUEUEMEM 4096 CDR_NIFCOMPRESS 0 CDR_SERIAL 0 CDR_DBSPACE CDR_QHDR_DBSPACE CDR_QDATA_SBSPACE CDR_SUPPRESS_ATSRISWARN CDR_DELAY_PURGE_DTC     0 CDR_LOG_LAG_ACTION ddrblock CDR_LOG_STAGING_MAXSIZE 0 CDR_MAX_DYNAMIC_LOGS 0 DRAUTO                  0 DRINTERVAL              30 DRTIMEOUT               30 HA_ALIAS DRLOSTFOUND             $INFORMIXDIR/etc/dr.lostfound DRIDXAUTO               0 LOG_INDEX_BUILDS SDS_ENABLE SDS_TIMEOUT             20 SDS_TEMPDBS SDS_PAGING UPDATABLE_SECONDARY     0 FAILOVER_CALLBACK FAILOVER_TX_TIMEOUT     0 TEMPTAB_NOLOG           0 DELAY_APPLY             0 STOP_APPLY              0 LOG_STAGING_DIR          ENABLE_SNAPSHOT_COPY    0 SMX_COMPRESS            0 ON_RECVRY_THREADS  1 OFF_RECVRY_THREADS 10 DUMPDIR $INFORMIXDIR/tmp DUMPSHMEM 1 DUMPGCORE 0 DUMPCORE 0 DUMPCNT 1 ALARMPROGRAM $INFORMIXDIR/etc/alarmprogram.sh ALRM_ALL_EVENTS 0 STORAGE_FULL_ALARM 600,3 SYSALARMPROGRAM $INFORMIXDIR/etc/evidence.sh EILSEQ_COMPAT_MODE  0 QSTATS 0 WSTATS 0 USERMAPPING OFF SP_AUTOEXPAND 1 SP_THRESHOLD 0 SP_WAITTIME 30 DEFAULTESCCHAR \ #VPCLASS         MQ,noyield MQSERVER MQCHLLIB MQCHLTAB #VPCLASS        jvp,num=1     #JVPJAVAHOME     $INFORMIXDIR/extend/krakatoa/jre #JVPHOME         $INFORMIXDIR/extend/krakatoa  JVPPROPFILE     $INFORMIXDIR/extend/krakatoa/.jvpprops  JVPLOGFILE      $INFORMIXDIR/tmp/jvp.log   #JDKVERSION      1.5 #JVPJAVALIB      /bin #JVPJAVAVM       jvm #JVPARGS        -verbose:jni #JVPCLASSPATH  $INFORMIXDIR/extend/krakatoa/krakatoa_g.jar:$INFORMIXDIR/extend/krakatoa/jdbc_g.jar JVPCLASSPATH  $INFORMIXDIR/extend/krakatoa/krakatoa.jar:$INFORMIXDIR/extend/krakatoa/jdbc.jar BUFFERPOOL      default,buffers=10000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.500000 BUFFERPOOL      size=2K,buffers=50000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000 AUTO_LRU_TUNING 1 ISK INITIALIZATION ABORTED: potential instance overwrite detected. To disable this check, set FULL_DISK_INIT to 1 in your config file and retry. 在11.70中加入了FULL_DISK_INIT 这个参数，对当前已经初始化的dbspace进行保护，若是需要初始化dbspace，需要更改这个参数为 1 .   多谢指点，将FULL_DISK_INIT参数修改为1，然后初始化oninit -iv就会成功。    但还有个问题，我关闭onmode -ky后，从新初始化时FULL_DISK_INIT又会自动变为0；   再次请教如何将FULL_DISK_INIT参数写死，不用每次启动的时候都去修改？？？ 只要初始化成功了，该参数就自动变为0.      BTW： 以后启动就不需要使用-i 这个命令了，直接使用oninit -v 就行了。 -i 只需要在第一次初始化的时候使用。。