Oninit cdi / Archive
Talk to an expert →

oninit fails using onsoctcp on linux

Posted in 2006

Topics: Installation, Setup & Upgrades, Storage & Space Management, Server Administration, Logging & Checkpoints, Networking & sqlhosts Configuration, Platform-Specific Issues

Ruediger Maehl — — source: Usenet: comp.databases.informix

Hi folks, I installed Informix 10 on my linux (SLES9) box, everything ok. All necessary environment variables set, "oninit -i" starts but stops when it is about to build the sysmaster, ONLY if I use "onsoctcp" in the sqlhosts file. No other process uses the service port. When (only) using "onipcshm", everything is fine, Informix comes up without any problems. Any help is greatly apreciated. Many regards, R'diger -----[ online.log ]----- 08:55:30 IBM Informix Dynamic Server Started.Tue May 9 08:55:30 2006 08:55:30 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecurepermissions 08:55:30 Event alarms enabled. ALARMPROG = '/home/informix/INFORMIX_TOOLS/ifmx_alarm_0' 08:55:31 Booting Language <c> from module <> 08:55:31 Loading Module <CNULL> 08:55:31 Booting Language <builtin> from module <> 08:55:31 Loading Module <BUILTINNULL> 08:55:42 DR: DRAUTO is 0 (Off) 08:55:42 IBM Informix Dynamic Server Version 10.00.UC4 SoftwareSerial Number AAA#B000000 08:55:43 IBM Informix Dynamic Server Initialized -- Complete DiskInitialized. 08:55:43 Checkpoint Completed: duration was 0 seconds. 08:55:43 Checkpoint loguniq 1, logpos 0xd0, timestamp: 0x70 08:55:43 Maximum server connections 0 08:55:43 Dataskip is now OFF for all dbspaces 08:55:43 On-Line Mode 08:55:43 Building 'sysmaster' database ... 08:55:56 listener-thread: err = -930: oserr = 0: errstr = linux4:Cannot connect to database server (linux4). 08:55:56 sql_listener: ASF_LISTEN failed 08:55:56 Attempting to bring listener thread down. 08:55:56 Server stopped. -----[ Shared memory does work ]----- environment: INFORMIXDIR=/opt/IBM/informix INFORMIXSERVER=idbs ONCONFIG=onconfig onconfig: DBSERVERNAME idbs sqlhosts: idbs onipcshm linux4 egal /etc/services: (not used) /etc/hosts: 10.1.7.13 linux4 -----[ TCP does not work ]----- environment: INFORMIXDIR=/opt/IBM/informix INFORMIXSERVER=ol_idbs ONCONFIG=onconfig onconfig: DBSERVERNAME ol_idbs sqlhosts: ol_idbs onsoctcp linux4 idbs_serv /etc/services: idbs_serv 1551/tcp /etc/hosts: 10.1.7.13 linux4

↪ replying to Ruediger Maehl
Adam Tauno Williams — — source: Usenet: comp.databases.informix

> I installed Informix 10 on my linux (SLES9) box, everything ok. > All necessary environment variables set, "oninit -i" starts > but stops when it is about to build the sysmaster, ONLY if I > use "onsoctcp" in the sqlhosts file. No other process uses the > service port. > When (only) using "onipcshm", everything is fine, Informix > comes up without any problems. I'm running Informx 10 on SuSe with - (sqlhosts) MOAIPC onipcshm localhost none BARNET onsoctcp moa online > sqlhosts: > idbs onipcshm linux4 egal What is "egal"? > /etc/hosts: > 10.1.7.13 linux4 Is the 10.1.7.13 interface up? > DBSERVERNAME ol_idbs > sqlhosts:> ol_idbs onsoctcp linux4 idbs_serv > /etc/services:> idbs_serv 1551/tcp > /etc/hosts: > 10.1.7.13 linux4 Are you sure nothing else is listening on 1551/tcp?

↪ replying to Adam Tauno Williams
Clive Eisen — — source: Usenet: comp.databases.informix

Adam Tauno Williams wrote: > > Are you sure nothing else is listening on 1551/tcp? And/or have you turned the firewall off or permitted 1551/tcp

↪ replying to Ruediger Maehl
Anup Nair — — source: Usenet: comp.databases.informix

--- Ruediger Maehl <ruediger.maehl@web.de> wrote: > Hi folks, > > I installed Informix 10 on my linux (SLES9) box, everything ok. > All necessary environment variables set, "oninit -i" starts > but stops when it is about to build the sysmaster, ONLY if I > use "onsoctcp" in the sqlhosts file. No other process uses the > service port. > When (only) using "onipcshm", everything is fine, Informix > comes up without any problems. > > Any help is greatly apreciated. > > Many regards, > > R'diger > > > -----[ online.log ]----- > 08:55:30 IBM Informix Dynamic Server Started.> Tue May 9 08:55:30 2006 > 08:55:30 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has> insecure > permissions > 08:55:30 Event alarms enabled. ALARMPROG = > '/home/informix/INFORMIX_TOOLS/ifmx_alarm_0' > 08:55:31 Booting Language <c> from module <> > 08:55:31 Loading Module <CNULL> > 08:55:31 Booting Language <builtin> from module <> > 08:55:31 Loading Module <BUILTINNULL> > 08:55:42 DR: DRAUTO is 0 (Off) > 08:55:42 IBM Informix Dynamic Server Version 10.00.UC4> Software > Serial Number AAA#B000000 > 08:55:43 IBM Informix Dynamic Server Initialized -- Complete Disk> Initialized. > 08:55:43 Checkpoint Completed: duration was 0 seconds. > 08:55:43 Checkpoint loguniq 1, logpos 0xd0, timestamp: 0x70 > 08:55:43 Maximum server connections 0 > 08:55:43 Dataskip is now OFF for all dbspaces > 08:55:43 On-Line Mode > 08:55:43 Building 'sysmaster' database ... > 08:55:56 listener-thread: err = -930: oserr = 0: errstr = linux4:> Cannot connect to database server (linux4). > 08:55:56 sql_listener: ASF_LISTEN failed > 08:55:56 Attempting to bring listener thread down. > 08:55:56 Server stopped.> > -----[ Shared memory does work ]----- > > environment: > INFORMIXDIR=/opt/IBM/informix > INFORMIXSERVER=idbs > ONCONFIG=onconfig> > onconfig: > DBSERVERNAME idbs> > sqlhosts: > idbs onipcshm linux4 egal> > /etc/services: > (not used) > > /etc/hosts: > 10.1.7.13 linux4 > > -----[ TCP does not work ]----- > > environment: > INFORMIXDIR=/opt/IBM/informix > INFORMIXSERVER=ol_idbs > ONCONFIG=onconfig> > onconfig: > DBSERVERNAME ol_idbs> > sqlhosts: > ol_idbs onsoctcp linux4 idbs_serv> > /etc/services: > idbs_serv 1551/tcp > > /etc/hosts: > 10.1.7.13 linux4 > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > Try these: - Give complete host name (linux4.xxx.xxx) - Give ip address instead of the name - Check if the port is free - Use a different port - Use the port number directly instead of the service name sqlhosts: ol_idbs onsoctcp 10.1.7.13 1151- Ping the port to see if it is active - Configure firewall to accept connection to this port

Related threads

Glossary