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

nicolasch

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

[informix@lintest1 ~]$ 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:37  Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure permiss
ions
18:41:37  Event 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

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

nicolasch

sqlexec    6667/tcp

liaosnet

sqlhosts:
testsv        ontlitcp        lintest1        sqlexec

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


RHEL5 应该使用onsoctcp 而没有ontlitcp

nicolasch

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

nicolasch

麻烦再请教老法王一个问题，在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

回复 6# nicolasch


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

nicolasch

OK，解决了！