• 【informix】解决启动报错大全，以及解决办法

    目录

    一、启动命令

    二、报错1（堆栈益处）

    报错内容

    解决1

    三、报错2（权限不对）

    报错内容

    查看日志

    解决2

    四、报错3（逻辑日志满了）

    报错内容

    解决3

    1、查看逻辑日志

    2、创建备份逻辑日志文件

    3、修改备份文件路径

    4、执行自动备份

    五、报错4（err = -951）

    报错内容

    解决4

    六、重启

    一、启动命令

    oninit -ivy

    查看日志：onstat -m（此语句只显示20行日志要查看完整日志在tmp下）

    二、报错1（堆栈益处）

    报错内容

    [informix@localhost informix]$ oninit -ivy

    bad INFORMIXSERVER[informix@localhost informix]$ cd data/

    shared memory not initialized for INFORMIXSERVER ''

    解决1

    1、修改 "~/.bash_profile"文件，加入如下环境变量

    vi . bash_profile

    export INFORMIXDIR=/opt/IBM/Informix_Software_Bundle

    export INFORMIXSQLHOSTS=$INFORMIXDIR/etc/sqlhosts

    export ONCONFIG=onconfig.tramsserver

    export INFORMIXSERVER=tramsserver

    export PATH=$INFORMIXDIR/bin:.:$PATH

    2、保存后执行

    source .bash_profile

    三、报错2（权限不对）

    报错内容

    1. [informix@localhost ~]$ oninit -v
    2.  
    3. attn: Ignoring unknown or deprecated config parameter (PHYSDBS)
    4.  
    5. Reading configuration file '/opt/informix//etc/onconfig.tramsserver'...succeeded
    6.  
    7. Allocating and attaching to shared memory...succeeded
    8.  
    9. Creating resident pool 4310 kbytes...succeeded
    10.  
    11. Creating infos file "/opt/informix//etc/.infos.tramsserver"...succeeded
    12.  
    13. Linking conf file "/opt/informix//etc/.conf.tramsserver"...succeeded
    14.  
    15. Initializing rhead structure...rhlock_t 16384 (512K)... rlock_t (2656K)... Writing to infos file...succeeded
    16.  
    17. Initialization of Encryption...succeeded
    18.  
    19. Initializing ASF...succeeded
    20.  
    21. Initializing Dictionary Cache and SPL Routine Cache...succeeded
    22.  
    23. Initializing encryption-at-rest if necessary...succeeded
    24.  
    25. Bringing up ADM VP...succeeded
    26.  
    27. Creating VP classes...succeeded
    28.  
    29. Forking main_loop thread...succeeded
    30.  
    31. Initializing DR structures...succeeded
    32.  
    33. Forking 1 'soctcp' listener threads...succeeded
    34.  
    35. Starting tracing...succeeded
    36.  
    37. Initializing 8 flushers...succeeded
    38.  
    39. Initializing SDS Server network connections...succeeded
    40.  
    41. Initializing log/checkpoint information...succeeded
    42.  
    43. Initializing dbspaces...succeeded
    44.  
    45. Opening primary chunks...FAILED
    46.  
    47. oninit: Fatal error in shared memory initialization
    48.  
    49.  
    50.  
    51. WARNING: server initialization failed or timed out.
    52.  
    53. Check the message log, online.log, for errors.

    查看日志

    23:59:37 The chunk '/opt/informix/data/rootdbs' must have READ/WRITE permissions for owner (600).

    23:59:37 oninit: Fatal error in shared memory initialization

    解决2

    [informix@localhost data]$ cd /opt/informix/data/

    [informix@localhost data]$ chmod 600 rootdbs

    四、报错3（逻辑日志满了）

    报错内容

    Initializing DBSPACETEMP list...succeeded
     

    解决3

    1、查看逻辑日志

    1. [informix@localhost ~]$ onstat -l
    2.  
    3. IBM Informix Dynamic Server Version 12.10.FC9DE -- Fast Recovery -- Up 00:16:18 -- 148084 Kbytes
    4.  
    5. Physical Logging
    6.  
    7. Buffer bufused bufsize numpages numwrits pages/io
    8.  
    9. P-2 0 64 0 0 0.00
    10.  
    11. phybegin physize phypos phyused %used
    12.  
    13. 1:263 25000 7819 0 0.00
    14.  
    15.  
    16.  
    17. Logical Logging
    18.  
    19. Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
    20.  
    21. L-2 0 32 1 1 1 1.0 1.0
    22.  
    23. Subsystem numrecs Log Space used
    24.  
    25. OLDRSAM 1 44
    26.  
    27.  
    28.  
    29. Buffer Waiting
    30.  
    31. Buffer ioproc flags
    32.  
    33. L-2 0 0x21 0
    34.  
    35.  
    36.  
    37. address number flags uniqid begin size used %used
    38.  
    39. 44d04f88 1 U------ 1 1:25263 5000 5000 100.00
    40.  
    41. 44afef68 2 U------ 2 1:30263 5000 5000 100.00
    42.  
    43. 44bb8f40 3 U------ 3 1:35263 5000 5000 100.00
    44.  
    45. 44bb8fa8 4 U------ 4 1:40263 5000 5000 100.00
    46.  
    47. 44ce8c50 5 U------ 5 1:45263 5000 5000 100.00
    48.  
    49. 44ce8cb8 6 U---C-L 6 1:50263 5000 4999 99.98
    50.  
    51. 6 active, 6 total

    2、创建备份逻辑日志文件

    [informix@localhost informix]$ mkdir Logicallog_bak

    [informix@localhost informix]$ cd Logicallog_bak/

    [informix@localhost Logicallog_bak]$ touch 20220801

    [informix@localhost Logicallog_bak]$ ll

    总用量 0

    -rw-rw-r-- 1 informix informix 0 8月 2 00:54 20220801

    [informix@localhost Logicallog_bak]$ chmod 600 20220801

    [informix@localhost Logicallog_bak]$

    3、修改备份文件路径

    cd /opt/informix/etc

    vim onconfig.tramsserver

    LTAPEDEV /opt/informix/Logicallog_bak/20220801

    或者LTAPEDEV /dev/null

    4、执行自动备份

    [informix@localhost Logicallog_bak]$ ontape -a

    Performing automatic backup of logical logs.

    Please mount tape 1 on /opt/informix/Logicallog_bak/20220801 and press Return to continue ...

    Logbackup failed - No log backup allowed during recovery.

    This tape contains no log data

    Program over.

    五、报错4（err = -951）

    报错内容

    5:17:03 Get Shadow Password for user [informix] failed! 
    15:17:03 Check for password aging/account lock-out. 
    15:17:03 listener-thread: err = -951: oserr = 0: errstr = informix@Fedora6: Incorrect password or user informix@Fedora6 is not kno. 

    解决4

    /etc/shadow权限太死，修改/etc/shadow其它用户可读，但这个不是最终的解决办法！ 
    最终的原因是自己执行了chown -R informix:informix /home/informix 把里面的一些文件权限改变了。 
    解决办法：重装！！！

    六、重启

    1. [informix@localhost data]$ oninit -vy
    2. attn: Ignoring unknown or deprecated config parameter (PHYSDBS)
    3. Reading configuration file '/opt/informix//etc/onconfig.tramsserver'...succeeded
    4. Allocating and attaching to shared memory...succeeded
    5. Creating resident pool 4310 kbytes...succeeded
    6. Creating infos file "/opt/informix//etc/.infos.tramsserver"...succeeded
    7. Linking conf file "/opt/informix//etc/.conf.tramsserver"...succeeded
    8. Initializing rhead structure...rhlock_t 16384 (512K)... rlock_t (2656K)... Writing to infos file...succeeded
    9. Initialization of Encryption...succeeded
    10. Initializing ASF...succeeded
    11. Initializing Dictionary Cache and SPL Routine Cache...succeeded
    12. Initializing encryption-at-rest if necessary...succeeded
    13. Bringing up ADM VP...succeeded
    14. Creating VP classes...succeeded
    15. Forking main_loop thread...succeeded
    16. Initializing DR structures...succeeded
    17. Forking 1 'soctcp' listener threads...succeeded
    18. Starting tracing...succeeded
    19. Initializing 8 flushers...succeeded
    20. Initializing SDS Server network connections...succeeded
    21. Initializing log/checkpoint information...succeeded
    22. Initializing dbspaces...succeeded
    23. Opening primary chunks...succeeded
    24. Validating chunks...succeeded
    25. Initialize Async Log Flusher...succeeded
    26. Starting B-tree Scanner...succeeded
    27. Init ReadAhead Daemon...succeeded
    28. Init DB Util Daemon...succeeded
    29. Initializing DBSPACETEMP list...succeeded
    30. Init Auto Tuning Daemon...succeeded
    31. Checking database partition index...succeeded
    32. Initializing dataskip structure...succeeded
    33. Checking for temporary tables to drop...succeeded
    34. Updating Global Row Counter...succeeded
    35. Forking onmode_mon thread...succeeded
    36. Creating periodic thread...succeeded
    37. Creating VP cache drain thread...succeeded
    38. Creating limits manager thread...succeeded
    39. Starting scheduling system...succeeded
    40. Verbose output complete: mode = 5

  • 相关阅读:
    Pytorch-lightning简介
    javascript：for...of和for..in循环的区别
    通达信吊灯止损指标公式，根据波动幅度自动调整止盈止损
    【OpenCV】使用OpenCV调用手机摄像头
    【吴恩达老师《机器学习》】课后习题5之【偏差与方差】
    【子网，超网和掩码】
    椭球面的切平面
    这个Spring Security登录插件牛啊，验证码、小程序、OAuth2都能快速接入
    工匠精神育种陈温福培育一粒好种子 国稻种芯百团计划行动
    《向量数据库指南》——用Milvus cloud搭建聊天机器人
  • 原文地址：https://blog.csdn.net/whowhowhoisimportant/article/details/126114871