目录

一、启动命令

二、报错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 '<NULL>'

解决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（权限不对）

报错内容

[informix@localhost ~]$ oninit -v

attn: Ignoring unknown or deprecated config parameter (PHYSDBS)

Reading configuration file '/opt/informix//etc/onconfig.tramsserver'...succeeded

Allocating and attaching to shared memory...succeeded

Creating resident pool 4310 kbytes...succeeded

Creating infos file "/opt/informix//etc/.infos.tramsserver"...succeeded

Linking conf file "/opt/informix//etc/.conf.tramsserver"...succeeded

Initializing rhead structure...rhlock_t 16384 (512K)... rlock_t (2656K)... Writing to infos file...succeeded

Initialization of Encryption...succeeded

Initializing ASF...succeeded

Initializing Dictionary Cache and SPL Routine Cache...succeeded

Initializing encryption-at-rest if necessary...succeeded

Bringing up ADM VP...succeeded

Creating VP classes...succeeded

Forking main_loop thread...succeeded

Initializing DR structures...succeeded

Forking 1 'soctcp' listener threads...succeeded

Starting tracing...succeeded

Initializing 8 flushers...succeeded

Initializing SDS Server network connections...succeeded

Initializing log/checkpoint information...succeeded

Initializing dbspaces...succeeded

Opening primary chunks...FAILED

oninit: Fatal error in shared memory initialization



WARNING: server initialization failed or timed out.

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、查看逻辑日志

[informix@localhost ~]$ onstat -l

IBM Informix Dynamic Server Version 12.10.FC9DE -- Fast Recovery -- Up 00:16:18 -- 148084 Kbytes

Physical Logging

Buffer bufused bufsize numpages numwrits pages/io

P-2 0 64 0 0 0.00

phybegin physize phypos phyused %used

1:263 25000 7819 0 0.00



Logical Logging

Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io

L-2 0 32 1 1 1 1.0 1.0

Subsystem numrecs Log Space used

OLDRSAM 1 44



Buffer Waiting

Buffer ioproc flags

L-2 0 0x21 0



address number flags uniqid begin size used %used

44d04f88 1 U------ 1 1:25263 5000 5000 100.00

44afef68 2 U------ 2 1:30263 5000 5000 100.00

44bb8f40 3 U------ 3 1:35263 5000 5000 100.00

44bb8fa8 4 U------ 4 1:40263 5000 5000 100.00

44ce8c50 5 U------ 5 1:45263 5000 5000 100.00

44ce8cb8 6 U---C-L 6 1:50263 5000 4999 99.98

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 把里面的一些文件权限改变了。 
解决办法：重装！！！

六、重启

[informix@localhost data]$ oninit -vy
attn: Ignoring unknown or deprecated config parameter (PHYSDBS)
Reading configuration file '/opt/informix//etc/onconfig.tramsserver'...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 4310 kbytes...succeeded
Creating infos file "/opt/informix//etc/.infos.tramsserver"...succeeded
Linking conf file "/opt/informix//etc/.conf.tramsserver"...succeeded
Initializing rhead structure...rhlock_t 16384 (512K)... rlock_t (2656K)... Writing to infos file...succeeded
Initialization of Encryption...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Initializing encryption-at-rest if necessary...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 8 flushers...succeeded
Initializing SDS Server network connections...succeeded
Initializing log/checkpoint information...succeeded
Initializing dbspaces...succeeded
Opening primary chunks...succeeded
Validating chunks...succeeded
Initialize Async Log Flusher...succeeded
Starting B-tree Scanner...succeeded
Init ReadAhead Daemon...succeeded
Init DB Util Daemon...succeeded
Initializing DBSPACETEMP list...succeeded
Init Auto Tuning Daemon...succeeded
Checking database partition index...succeeded
Initializing dataskip structure...succeeded
Checking for temporary tables to drop...succeeded
Updating Global Row Counter...succeeded
Forking onmode_mon thread...succeeded
Creating periodic thread...succeeded
Creating VP cache drain thread...succeeded
Creating limits manager thread...succeeded
Starting scheduling system...succeeded
Verbose output complete: mode = 5