银行数据库
各位大侠 求助 oninit -v
各位大虾:
昨晚我在执行导库操作 dbimport 应该是失败了,早上来的时候就看到磁盘空间空闲为0了,数据库也进不去,于是 我就oninit -v 执行了一下 起不来 下面是错误信息:
$ oninit -v
Checking group membership to determine server run mode...succeeded
Reading configuration file '/home/informix/etc/onconfig.snkf'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Checking config parameters...succeeded
20:25:48 IBM Informix Dynamic Server Started.
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.
20:25:48 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 addi
ng virtual shared memory segments. Please refer to Server machine notes for more information.
Allocating and attaching to shared memory...succeeded
Creating resident pool 2032 kbytes...succeeded
Allocating 8016 kbytes for buffer pool of 4K page size...succeeded
Creating infos file "/home/informix/etc/.infos.localhost"...succeeded
Linking conf file "/home/informix/etc/.conf.localhost"...succeeded
oninit: DBSERVERNAME 'localhost' not in sqlhosts file or sqlhosts file contents
are damaged.
WARNING: server initialization failed, or possibly timed out (if -w was used).
Check the message log, online.log, for errors.
$
在执行其他的informix命令的时候都是提示我:
shared memory not initialized for INFORMIXSERVER 'mydata'
请问这是什么原因啊 ???应该如何解决呢 谢谢
我重启过机器,现在online.log也不写了
昨晚我在执行导库操作 dbimport 应该是失败了,早上来的时候就看到磁盘空间空闲为0了,数据库也进不去,于是 我就oninit -v 执行了一下 起不来 下面是错误信息:
$ oninit -v
Checking group membership to determine server run mode...succeeded
Reading configuration file '/home/informix/etc/onconfig.snkf'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Checking config parameters...succeeded
20:25:48 IBM Informix Dynamic Server Started.
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.
20:25:48 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 addi
ng virtual shared memory segments. Please refer to Server machine notes for more information.
Allocating and attaching to shared memory...succeeded
Creating resident pool 2032 kbytes...succeeded
Allocating 8016 kbytes for buffer pool of 4K page size...succeeded
Creating infos file "/home/informix/etc/.infos.localhost"...succeeded
Linking conf file "/home/informix/etc/.conf.localhost"...succeeded
oninit: DBSERVERNAME 'localhost' not in sqlhosts file or sqlhosts file contents
are damaged.
WARNING: server initialization failed, or possibly timed out (if -w was used).
Check the message log, online.log, for errors.
$
在执行其他的informix命令的时候都是提示我:
shared memory not initialized for INFORMIXSERVER 'mydata'
请问这是什么原因啊 ???应该如何解决呢 谢谢
我重启过机器,现在online.log也不写了
13同行回答
一个informix创建和启动或者查看要注意如下
1、环境变量是否正确，（INFORMIXDIR,ONCONFIG,INFORMIXSERVER );
2、INFORMIXSERVER是否和ONCONFIG文件中的SERVERNAME一致
3、sqlhosts（如果没有指定特殊的sqlhosts,默认是$INFORMIXDIR/etc/sqlhosts)中是否有对于INFORMIXSERVER的定义。
4、sqlhosts定义的地址或者端口是否在/etc/hosts和/etc/services中定义（用绝对地址和端口可以忽略此项，但要注意）
5、你查看onstat的时候所用的环境变量是否和启动一样，有人可能喜欢写一个单独的profile作为启动的。
6、你的SERVERNUM不要和别人重，可以用onstat -g dis看看是否有别的数据库配置。收起
1、环境变量是否正确，（INFORMIXDIR,ONCONFIG,INFORMIXSERVER );
2、INFORMIXSERVER是否和ONCONFIG文件中的SERVERNAME一致
3、sqlhosts（如果没有指定特殊的sqlhosts,默认是$INFORMIXDIR/etc/sqlhosts)中是否有对于INFORMIXSERVER的定义。
4、sqlhosts定义的地址或者端口是否在/etc/hosts和/etc/services中定义（用绝对地址和端口可以忽略此项，但要注意）
5、你查看onstat的时候所用的环境变量是否和启动一样，有人可能喜欢写一个单独的profile作为启动的。
6、你的SERVERNUM不要和别人重，可以用onstat -g dis看看是否有别的数据库配置。收起
浏览1332
从错误信息看，错误有以下几个
1、ONCONFIG('/home/informix/etc/onconfig.snkf')文件中"INFORMIXSERVER"参数与环境变量"INFORMIXSERVER"值不一致，前者显示为localhost(实际可能为空),后者显示为mydata
2、SHMBASE参数设置与操作系统不吻合，错误信息指示，须设置为0x700000010000000
分析：ONCONFIG设置不正确，指向了错误的onconfig文件，INFORMIXSERVER及SHMBASE都不对，该文件很可能是其他操作系统拷贝过来的。
解决：设置正确的ONCONFIG，或者直接修改onconfig文件。目前错误看，需修改INFORMIXSERVER及SHMBASE
Reading configuration file '/home/informix/etc/onconfig.snkf'...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.
Creating infos file "/home/informix/etc/.infos.localhost"...succeeded
Linking conf file "/home/informix/etc/.conf.localhost"...succeeded
shared memory not initialized for INFORMIXSERVER 'mydata'收起
1、ONCONFIG('/home/informix/etc/onconfig.snkf')文件中"INFORMIXSERVER"参数与环境变量"INFORMIXSERVER"值不一致，前者显示为localhost(实际可能为空),后者显示为mydata
2、SHMBASE参数设置与操作系统不吻合，错误信息指示，须设置为0x700000010000000
分析：ONCONFIG设置不正确，指向了错误的onconfig文件，INFORMIXSERVER及SHMBASE都不对，该文件很可能是其他操作系统拷贝过来的。
解决：设置正确的ONCONFIG，或者直接修改onconfig文件。目前错误看，需修改INFORMIXSERVER及SHMBASE
Reading configuration file '/home/informix/etc/onconfig.snkf'...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.
Creating infos file "/home/informix/etc/.infos.localhost"...succeeded
Linking conf file "/home/informix/etc/.conf.localhost"...succeeded
shared memory not initialized for INFORMIXSERVER 'mydata'收起
浏览1431
如果之前正常的话，那么需要确认如下：
ipcs -m看看关闭数据库后，内存段是否释放
onstat -g seg也可以看到。
数据库关闭后disk繁忙率还是100%?
如果informix的共享内存段海存在的话，通过ipcs -rm 删除共享内存段后才能正常启动收起
ipcs -m看看关闭数据库后，内存段是否释放
onstat -g seg也可以看到。
数据库关闭后disk繁忙率还是100%?
如果informix的共享内存段海存在的话，通过ipcs -rm 删除共享内存段后才能正常启动收起
浏览1387
从做imp来看，你之前数据库应该是正常的。但是之后，报sqlhosts中没有你的DBSERVERNAME。
你首先确认一下，你的DBSERVERNAME是什么，是不是localhost. 然后去sqlhosts里检查一下。
具体问题原因，需要进一步的信息。收起
你首先确认一下，你的DBSERVERNAME是什么，是不是localhost. 然后去sqlhosts里检查一下。
具体问题原因，需要进一步的信息。收起
浏览1458
这个你需要查看帮助文档。收起
浏览1367
如果你的数据库实例中只有一个DB,建议在dbimport之前做如下操作:
1、对数据库实例做初始化，保障能够到online模式
2、dbimport的观察一下是哪有问题
从目前来看是你的数据库实例本身就起不到online，那就帮不了你了收起
1、对数据库实例做初始化，保障能够到online模式
2、dbimport的观察一下是哪有问题
从目前来看是你的数据库实例本身就起不到online，那就帮不了你了收起
浏览1391