TCP problem upgrade 9.40 to 11.50
On Solaris 10, upgrading from IDS 9.40 to 11.50, the instance started over shared memory but the TCP listener failed with "err = -25572: oserr = 8 ... Network driver cannot bind a name to the port." Suggestions included matching the protocol in sqlhosts and NETTYPE (tlitcp vs soctcp on Solaris), checking the port wasn't already in use (lsof), verifying DBSERVERNAME/DBSERVERALIASES, and checking hostname resolution. The fix was the hostname: adding an alias in /etc/hosts and using the short name (orgrimmar) instead of informix.orgrimmar in sqlhosts let the server come online; the dotted name appeared to be the problem.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Good afternoon everyone.
I'm doing some tests to upgrade from version 9.40 to 11.50.
I am in a Solaris 10 Sparc 64bits.
My instance works with share memory (shm) but when I tried to use tcp
(onsoctcp or ontlitpc) It does not start up.
Anybody know how to resolve the problem?.
In online.log message
14:53:44 listener-thread: err = -25572: oserr = 8: errstr = : Network driver
cannot bind a name to the port.
My sqlhosts
prueba onipcshm informix.orgrimmar prueba
pruebatcp ontlitcp informix.orgrimmar 1528
My onconfig
SERVERNUM 11
DBSERVERNAME prueba
DBSERVERALIASES pruebatcp
NETTYPE ipcshm,1,50,NET
NETTYPE soctcp,1,50,NET
LISTEN_TIMEOUT 60
MAX_INCOMPLETE_CONNECTIONS 1024
FASTPOLL 1
Thank a lot
Servio Velasco
AFAIK ontlitcp is used on Solaris.
Your problem most likely is tied to your hostname resoultion.
If you try to "ping informix.orgrimmar" what does it return?
If it is server only sqlhosts file, put asterisk (*) in 3rd column.
HTH
Hrvoje
SERVIO VELASCO wrote:
Good afternoon everyone.
I'm doing some tests to upgrade from version 9.40 to 11.50.
I am in a Solaris 10 Sparc 64bits.
My instance works with share memory (shm) but when I tried to use tcp
(onsoctcp or ontlitpc) It does not start up.
Anybody know how to resolve the problem?.
In online.log message
14:53:44 listener-thread: err = -25572: oserr = 8: errstr = : Network driver
cannot bind a name to the port.
My sqlhosts
prueba onipcshm informix.orgrimmar prueba
pruebatcp ontlitcp informix.orgrimmar 1528
My onconfig
SERVERNUM 11
DBSERVERNAME prueba
DBSERVERALIASES pruebatcp
NETTYPE ipcshm,1,50,NET
NETTYPE soctcp,1,50,NET
LISTEN_TIMEOUT 60
MAX_INCOMPLETE_CONNECTIONS 1024
FASTPOLL 1
Thank a lot
Servio Velasco
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Of course, because on Solaris ontlitcp is used, and you must set
appropriate NETTYPE
NETTYYPE tlitcp,1,50,NET
HTH
Hrvoje
SERVIO VELASCO wrote:
Good afternoon everyone.
I'm doing some tests to upgrade from version 9.40 to 11.50.
I am in a Solaris 10 Sparc 64bits.
My instance works with share memory (shm) but when I tried to use tcp
(onsoctcp or ontlitpc) It does not start up.
Anybody know how to resolve the problem?.
In online.log message
14:53:44 listener-thread: err = -25572: oserr = 8: errstr = : Network driver
cannot bind a name to the port.
My sqlhosts
prueba onipcshm informix.orgrimmar prueba
pruebatcp ontlitcp informix.orgrimmar 1528
My onconfig
SERVERNUM 11
DBSERVERNAME prueba
DBSERVERALIASES pruebatcp
NETTYPE ipcshm,1,50,NET
NETTYPE soctcp,1,50,NET
LISTEN_TIMEOUT 60
MAX_INCOMPLETE_CONNECTIONS 1024
FASTPOLL 1
Thank a lot
Servio Velasco
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
The possible reason is that port designated for oninit is used by some
other process. That process could be a old oninit process. I would use
lsof utility to check if that port is used by some other process. You can
download lsof utility from http://www.sunfreeware.com for your OS version.
Usage: as root: lsof -i<port_number>
where port_number is the port used by your engine.
TCP problem upgrade 9.40 to 11.50 [14771]
SERVIO VELASCO
to:
ids
02/05/2009 03:36 PM
Sent by:
ids-bounces@iiug.org
Please respond to ids
Good afternoon everyone.
I'm doing some tests to upgrade from version 9.40 to 11.50.
I am in a Solaris 10 Sparc 64bits.
My instance works with share memory (shm) but when I tried to use tcp
(onsoctcp or ontlitpc) It does not start up.
Anybody know how to resolve the problem?.
In online.log message
14:53:44 listener-thread: err = -25572: oserr = 8: errstr = : Network
driver
cannot bind a name to the port.
My sqlhosts
prueba onipcshm informix.orgrimmar prueba
pruebatcp ontlitcp informix.orgrimmar 1528
My onconfig
SERVERNUM 11
DBSERVERNAME prueba
DBSERVERALIASES pruebatcp
NETTYPE ipcshm,1,50,NET
NETTYPE soctcp,1,50,NET
LISTEN_TIMEOUT 60
MAX_INCOMPLETE_CONNECTIONS 1024
FASTPOLL 1
Thank a lot
Servio Velasco
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
On a different issue, shouldn't your first NETTYPE entry be
"NETTYPE ipcshm, 1, 50, CPU"? NET VPs aren't usually efficient for
shared memory connections.
--EEM
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Dattatreya Govindappanavar
> Sent: Thursday, February 05, 2009 3:59 PM
> To: ids@iiug.org
> Subject: Re: TCP problem upgrade 9.40 to 11.50 [14776]
>
> The possible reason is that port designated for oninit is used by some
> other process. That process could be a old oninit process. I would use
> lsof utility to check if that port is used by some other process. You
can
> download lsof utility from http://www.sunfreeware.com for your OS
version.
>
> Usage: as root: lsof -i<port_number>
>
> where port_number is the port used by your engine.
>
> TCP problem upgrade 9.40 to 11.50 [14771]
>
> SERVIO VELASCO
> to:
> ids
> 02/05/2009 03:36 PM
>
> Sent by:
> ids-bounces@iiug.org
> Please respond to ids
>
> Good afternoon everyone.
>
> I'm doing some tests to upgrade from version 9.40 to 11.50.
>
> I am in a Solaris 10 Sparc 64bits.
>
> My instance works with share memory (shm) but when I tried to use tcp
> (onsoctcp or ontlitpc) It does not start up.
>
> Anybody know how to resolve the problem?.
>
> In online.log message
> 14:53:44 listener-thread: err = -25572: oserr = 8: errstr = : Network
> driver
> cannot bind a name to the port.
>
> My sqlhosts
> prueba onipcshm informix.orgrimmar prueba
> pruebatcp ontlitcp informix.orgrimmar 1528>
> My onconfig
> SERVERNUM 11
> DBSERVERNAME prueba
> DBSERVERALIASES pruebatcp
> NETTYPE ipcshm,1,50,NET
> NETTYPE soctcp,1,50,NET
> LISTEN_TIMEOUT 60
> MAX_INCOMPLETE_CONNECTIONS 1024
> FASTPOLL 1>
> Thank a lot
>
> Servio Velasco
>
>
>
************************************************************************
**
> *****
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
************************************************************************
**
> *****
> Forum Note: Use "Reply" to post a response in the discussion forum.
Hi Servio,
In the sqlhosts, you have ontlitcp, while in the ONCONFIG you have NETTYPE
soctcp.
In Solaris, we use TLI for TCP communication, rather than sockets (SOC).
Can you try just changing the NETTYPE in the ONCONFIG file, to change from
'soctcp' to 'tlitcp', make sure you have TLI in both sqlhosts and ONCONFIG,
and see if that helps?
Regards,
Veronica.
> To: ids@iiug.org
> From: servio_velasco@hotmail.com
> Subject: TCP problem upgrade 9.40 to 11.50 [14771]
> Date: Thu, 5 Feb 2009 16:32:24 -0500
>
> Good afternoon everyone.
>
> I'm doing some tests to upgrade from version 9.40 to 11.50.
>
> I am in a Solaris 10 Sparc 64bits.
>
> My instance works with share memory (shm) but when I tried to use tcp
> (onsoctcp or ontlitpc) It does not start up.
>
> Anybody know how to resolve the problem?.
>
> In online.log message
> 14:53:44 listener-thread: err = -25572: oserr = 8: errstr = : Network driver
> cannot bind a name to the port.
>
> My sqlhosts
> prueba onipcshm informix.orgrimmar prueba
> pruebatcp ontlitcp informix.orgrimmar 1528>
> My onconfig
> SERVERNUM 11
> DBSERVERNAME prueba
> DBSERVERALIASES pruebatcp
> NETTYPE ipcshm,1,50,NET
> NETTYPE soctcp,1,50,NET
> LISTEN_TIMEOUT 60
> MAX_INCOMPLETE_CONNECTIONS 1024
> FASTPOLL 1>
> Thank a lot
>
> Servio Velasco
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
_________________________________________________________________
Get 5 GB of storage with Windows Live Hotmail.
http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_5gb_112008
Hello everyone. I put in sqlhost (ontlitcp) and onconfig (NETTYPE tlitcp,1,50,NET) and It did not work. I put in sqlhost (onsoctcp) and onconfig (NETTYPE soctcp,1,50,NET) and It did not work. I provee ping informix.on and responde is alive. I use diferent ports and It did not work. In this machine is working other instance but in version 9.4 and In this instance work with SOC and TLI. Anybody have other idea? Thank a lot Servio Velasco
Post your sqlhosts file and ONCONFIG file. Art On Fri, Feb 6, 2009 at 8:16 AM, SERVIO VELASCO <servio_velasco@hotmail.com>wrote: > Hello everyone. > > I put in sqlhost (ontlitcp) and onconfig (NETTYPE tlitcp,1,50,NET) and It > did > not work. > I put in sqlhost (onsoctcp) and onconfig (NETTYPE soctcp,1,50,NET) and It > did > not work. > > I provee ping informix.on and responde is alive. > > I use diferent ports and It did not work. > > In this machine is working other instance but in version 9.4 and In this > instance work with SOC and TLI. > > Anybody have other idea? > > Thank a lot > > Servio Velasco > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. --0016364ee3109e0aac046240d869
SQLHOST
#**************************************************************************
#
# Licensed Material - Property Of IBM
#
# "Restricted Materials of IBM"
#
# IBM Informix Dynamic Server
# (c) Copyright IBM Corporation 1996, 2004 All rights reserved.
#
# Title: sqlhosts.demo
# Description:
# Default sqlhosts file for running demos.
#
#**************************************************************************
prueba onipcshm informix.orgrimmar prueba
pruebatcp ontlitcp informix.orgrimmar 1528
#****************************************************************************
ONCONFIG
NETTYPE ipcshm,1,50,NET
NETTYPE tlitcp,1,50,NET
LISTEN_TIMEOUT 60
MAX_INCOMPLETE_CONNECTIONS 1024
FASTPOLL 1
Dos recomendaciones:
1.- Me llama la atencion que veo una sola linea con los dos tipos de conexión
en el sqlhosts. Si no es un error por el cut-paste en el correo, separala asi:
prueba onipcshm informix.orgrimmar prueba
pruebatcp ontlitcp informix.orgrimmar 1528
2.- Cambia el valor de host (informix.orgrinmar) por la IP de tu servidor.
Saludos
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of SERVIO
VELASCO
Sent: Viernes, 06 de Febrero de 2009 11:03 a.m.
To: ids@iiug.org
Subject: Re: RE: TCP problem upgrade 9.40 to 11.50 [14787]
SQLHOST
#**************************************************************************
#
# Licensed Material - Property Of IBM
#
# "Restricted Materials of IBM"
#
# IBM Informix Dynamic Server
# (c) Copyright IBM Corporation 1996, 2004 All rights reserved.
#
# Title: sqlhosts.demo
# Description:
# Default sqlhosts file for running demos.
#
#**************************************************************************
prueba onipcshm informix.orgrimmar prueba pruebatcp ontlitcp
informix.orgrimmar 1528
#****************************************************************************
ONCONFIG
NETTYPE ipcshm,1,50,NET
NETTYPE tlitcp,1,50,NET
LISTEN_TIMEOUT 60
MAX_INCOMPLETE_CONNECTIONS 1024
FASTPOLL 1
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Just for your information, the IIUG also provides technical forums for
different languages. They are listed at the bottom on our main web page.
www.iiug.org
Here is the list:
Informix Engine Discussion: English Español Deutsche Francophone Português
For example, check this one out
http://www.iiug.org/forums/iiug-esp/
Thanks!
Kate Tomchik [ kate@iiug.org ] www.iiug.org
International Informix Users Group Board of Directors
I'm prepared for all emergencies but totally unprepared for everyday
life.
---------- Original Message -----------
From: "SERVIO VELASCO" <servio_velasco@hotmail.com>
To: ids@iiug.org
Sent: Fri, 6 Feb 2009 12:03:15 -0500 (EST)
Subject: Re: RE: TCP problem upgrade 9.40 to 11.50 [14787]
> SQLHOST
>
#**************************************************************************
> #
> # Licensed Material - Property Of IBM
> #
> # "Restricted Materials of IBM"
> #
> # IBM Informix Dynamic Server
> # (c) Copyright IBM Corporation 1996, 2004 All rights reserved.
> #
> # Title: sqlhosts.demo
> # Description:
> # Default sqlhosts file for running demos.
> #
> #**************************************************************************
>
> prueba onipcshm informix.orgrimmar prueba
> pruebatcp ontlitcp informix.orgrimmar 1528>
>
#****************************************************************************
> ONCONFIG
>
> NETTYPE ipcshm,1,50,NET
> NETTYPE tlitcp,1,50,NET
> LISTEN_TIMEOUT 60
> MAX_INCOMPLETE_CONNECTIONS 1024
> FASTPOLL 1>
>
*****************************************************************************
** Forum Note: Use "Reply" to post a response in the discussion forum.
------- End of Original Message -------
What about the settings for SERVERNAME and DBSERVERALIASES? SERVERNAME
should be set to prueba and DBSERVERALIASES set to pruebatcp. Also note,
though this has nothing to do with your problems, the NETTYPE for ipcshm
should specify CPU poll threads not NET VP poll threads. NET VP poll
threads listening for shared memory activity burn too much CPU time. Also
if the shared memory connection is not just for administration, ie if it is
heavily used, there should be the same number of poll threads configured as
there are CPU VPs.
Art
On Fri, Feb 6, 2009 at 12:03 PM, SERVIO VELASCO
<servio_velasco@hotmail.com>wrote:
> SQLHOST
> #**************************************************************************
> #
> # Licensed Material - Property Of IBM
> #
> # "Restricted Materials of IBM"
> #
> # IBM Informix Dynamic Server
> # (c) Copyright IBM Corporation 1996, 2004 All rights reserved.
> #
> # Title: sqlhosts.demo
> # Description:
> # Default sqlhosts file for running demos.
> #
> #**************************************************************************
>
> prueba onipcshm informix.orgrimmar prueba
> pruebatcp ontlitcp informix.orgrimmar 1528>
>
> #****************************************************************************
> ONCONFIG
>
> NETTYPE ipcshm,1,50,NET
> NETTYPE tlitcp,1,50,NET
> LISTEN_TIMEOUT 60
> MAX_INCOMPLETE_CONNECTIONS 1024
> FASTPOLL 1>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
--0016e641db12916dd204624593de
Oh, wait, what is 'informix.orgrimmar'? Is that the name of the machine? Is
the machine named 'informix' in domain 'orgrimmar'? If not, the sqlhosts
entries are not correct. What is set in the server that's working?
Art
On Fri, Feb 6, 2009 at 12:03 PM, SERVIO VELASCO
<servio_velasco@hotmail.com>wrote:
> SQLHOST
> #**************************************************************************
> #
> # Licensed Material - Property Of IBM
> #
> # "Restricted Materials of IBM"
> #
> # IBM Informix Dynamic Server
> # (c) Copyright IBM Corporation 1996, 2004 All rights reserved.
> #
> # Title: sqlhosts.demo
> # Description:
> # Default sqlhosts file for running demos.
> #
> #**************************************************************************
>
> prueba onipcshm informix.orgrimmar prueba
> pruebatcp ontlitcp informix.orgrimmar 1528>
>
> #****************************************************************************
> ONCONFIG
>
> NETTYPE ipcshm,1,50,NET
> NETTYPE tlitcp,1,50,NET
> LISTEN_TIMEOUT 60
> MAX_INCOMPLETE_CONNECTIONS 1024
> FASTPOLL 1>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
--0016e640cdd031728e04624599da
Art I added a new nickname in the /etc/hosts 180.180.169.151 informix.orgrimmar orgrimmar loghost And Modified the sqlhosts with this nickname: pruebatcp tlitcp orgrimmar 1528 The instance is runnig...and online. I belive the problem is the dot in the name of de machine. Thanks a lot Servio
2009/2/6 Art Kagel <art.kagel@gmail.com>:
> Oh, wait, what is 'informix.orgrimmar'? Is that the name of the machine? Is
> the machine named 'informix' in domain 'orgrimmar'? If not, the sqlhosts
> entries are not correct. What is set in the server that's working?
>
> Art
>
> On Fri, Feb 6, 2009 at 12:03 PM, SERVIO VELASCO
> <servio_velasco@hotmail.com>wrote:
>
>> SQLHOST
>> #**************************************************************************
>> #
>> # Licensed Material - Property Of IBM
>> #
>> # "Restricted Materials of IBM"
>> #
>> # IBM Informix Dynamic Server
>> # (c) Copyright IBM Corporation 1996, 2004 All rights reserved.
>> #
>> # Title: sqlhosts.demo
>> # Description:
>> # Default sqlhosts file for running demos.
>> #
>> #**************************************************************************
>>
>> prueba onipcshm informix.orgrimmar prueba
>> pruebatcp ontlitcp informix.orgrimmar 1528>>
>>
>>
> #****************************************************************************
>> ONCONFIG
>>
>> NETTYPE ipcshm,1,50,NET
>> NETTYPE tlitcp,1,50,NET
>> LISTEN_TIMEOUT 60
>> MAX_INCOMPLETE_CONNECTIONS 1024
>> FASTPOLL 1>>
>>
>>
>>
>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>
> --
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Oninit, the IIUG, nor any other organization
> with which I am associated either explicitly or implicitly. Neither do
> those opinions reflect those of other individuals affiliated with any entity
> with which I am affiliated nor those of the entities themselves.
>
> --0016e640cdd031728e04624599da
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Do the two ONCONFIG files have different SERVERNUM ?
Keith
Related threads
- HELP- database won't start !!
- Network driver cannot bind a name to the port.
- Solaris 8, IDSWE 7.31, WARNING: Network Down
- Error 25572 using ESQL/Cobol
- Identically named instances, different hosts