nicolasch 发表于 2011-01-24 11:03

oninit初始化报错，请帮忙看看原因，谢谢！

linux 5.4上装informix11.5
onninit -ivy后报错：

$ oninit -ivy
Checking group membership to determine server run mode...succeeded
Reading configuration file '/usr/informix/etc/onconfig.cib'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 25578 kbytes...succeeded
Allocating 200016 kbytes for buffer pool of 2K page size...succeeded
Creating infos file "/usr/informix/etc/.infos.testsv"...succeeded
Linking conf file "/usr/informix/etc/.conf.testsv"...succeeded
Initializing rhead structure...succeeded
Writing to infos file...succeeded
Initialization of Encryption...succeeded
The specified service name or protocol is unknown. Error -25507.
Initializing ASF...FAILED

WARNING: server initialization failed, or possibly timed out (if -w was used).
Check the message log, online.log, for errors.

online.log里就只有：
18:41:37Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure permiss
ions
18:41:37Event alarms enabled.ALARMPROG = '/usr/informix/etc/no_log.sh'


sqlhosts:
testsv      ontlitcp      lintest1      sqlexec

onconfig里面：
SERVERNUM       0               # Unique id corresponding to a OnLine instance
DBSERVERNAME    testsv         # Name of default database server
DBSERVERALIASES               # List of alternate dbservernames
NETTYPE         tlitcp,1,100,NET # Configure poll thread(s) for nettype
#NETTYPE         ipcshm,1,100,CPU # Configure poll thread(s) for nettype
#NETTYPE         tlitcp,5,5,NET# Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60            # Max time to wait of lock in distributed env.
RESIDENT      0

phyano 发表于 2011-01-24 12:17

/etc/sevices 里的informix服务配了吗？
贴出来

nicolasch 发表于 2011-01-24 13:12

sqlexec    6667/tcp

liaosnet 发表于 2011-01-24 13:29

sqlhosts:
testsv      ontlitcp      lintest1      sqlexec

ontlitcp------------------> onsoctcp


RHEL5 应该使用onsoctcp 而没有ontlitcp

nicolasch 发表于 2011-01-24 14:27

谢谢 liaosnet (暗夜星空) ，
搞清楚了，ontlitcp 这个协议是sco open的，linux是用onsoctcp。

nicolasch 发表于 2011-01-24 16:42

麻烦再请教老法王一个问题，在informix11.50中我创建一个表，其中有个字段这样定义：
create table "fib".cpls
(
    cpzxh integer
      default 0 not null ,
    cpznxh smallint
      default 0 not null ,
    jyrq date
      default'1899/12/31' not null
）
591: Invalid default value for column/variable (jyrq).

这个语句我经常在informix731上用，在informix11.50怎么就报错了呢?

liaosnet 发表于 2011-01-24 17:07

本帖最后由 liaosnet 于 2011-01-24 17:16 编辑

回复 6# nicolasch


    日期格式不对
在没设置DBDATE的情况下，默认是 mm/dd/yyyy

nicolasch 发表于 2011-01-24 17:40

OK，解决了！
页: [1]
查看完整版本: oninit初始化报错，请帮忙看看原因，谢谢！