Oninit cdi / Archive
Talk to an expert →

HDR setup- Network driver system error

Posted in 2011

Summary

Setting up HDR between two IDS 11.50.FC5 instances on HP-UX, 'ontape -p' on the secondary failed at boot with "listener-thread: err = -25572... Network driver cannot bind a name to the port" (oserr 226) and ASF_LISTEN failed. Suggestions included missing/mismatched /etc/services entries and duplicated aliases, but Madison Pruet's hint proved correct: a previous aborted 'ontape -p' had left oninit -r processes still holding the port. Killing those stale processes let HDR start with no config changes. Also noted: SERVERNUM need only be unique per machine, and HDR requires a network (SQLI) connection, not shared memory.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: High Availability & Replication, Backup & Restore, Server Administration, Security, Permissions & Auditing, Networking & sqlhosts Configuration, Platform-Specific Issues

MURALI PAZHAYANNUR — — source: IIUG Forums & Mailing Lists

I am trying to setup HDR between 2 instances (IDS 11.50.FC5, HP-UX 11.31) and on the 'ontape -p' on the secondary I get the following message: 19:23:18 IBM Informix Dynamic Server Started. 19:23:18 Segment locked: addr=c0000001c0000000, size=828485632 Wed Jul 13 19:23:18 2011 19:23:18 Event alarms enabled. ALARMPROG = '/usr/informix/etc/alarmprogram.sh' 19:23:18 Booting Language <c> from module <> 19:23:18 Loading Module <CNULL> 19:23:18 Booting Language <builtin> from module <> 19:23:18 Loading Module <BUILTINNULL> 19:23:24 DR: DRAUTO is 0 (Off) 19:23:24 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) 19:23:24 Fast poll /dev/poll enabled. 19:23:24 listener-thread: err = -25572: oserr = 226: errstr = : Network driver cannot bind a name to the port. System error = 226. 19:23:24 sql_listener: ASF_LISTEN failed 19:23:24 Attempting to bring listener thread down. 19:23:24 Server stopped. 1. The boxes trust each other ( via /etc/hosts, /etc/hosts.equiv) 2. Primary onconfig: DBSERVERNAME nike_SPTCP_PRIM DBSERVERALIASES nike_SPTCP,nike_SP,nike_SPTCP_PRIM Secondary onconfig: DBSERVERNAME nike_SPTCP_SEC DBSERVERALIASES nike_SPTCP,nike_SP,nike_SPTCP_SEC 3. Primary SQLHOSTS ############################################################################ nike_SP onipcshm hpnew nike_SP nike_SPTCP onsoctcp hpnew nike_SPTCP ############################################################################ nike_SPTCP_PRIM onsoctcp hpnew nike_SPTCP_PRIM nike_SPTCP_SEC onsoctcp uxdr nike_SPTCP_SEC ############################################################################ Secondary SQLHOSTS ############################################################################ nike_SP onipcshm uxdr nike_SP nike_SPTCP onsoctcp uxdr nike_SPTCP ############################################################################ nike_SPTCP_PRIM onsoctcp hpnew nike_SPTCP_PRIM nike_SPTCP_SEC onsoctcp uxdr nike_SPTCP_SEC ############################################################################ 4. /etc/services (Primary) nike_SPTCP 1532/tcp nike_SBTCP 1531/tcp nike_sbtcp 1541/tcp nike_SPTCP_PRIM 1551/tcp ## Primary HDR service nike_SPTCP_SEC 1561/tcp ## Secondary HDR service /etc/services (Secondary) nike_SPTCP 1528/tcp nike_SPTCP_PRIM 1551/tcp ## Primary HDR service nike_SPTCP_SEC 1561/tcp ## Secondary HDR service nike_DRTCP 1628/tcp nike_drtcp 1728/tcp 5. netstat -a | grep 1551|1561 returns empty. 6. I can ping each box from the other by host name. Thanks for the assistance. Murali

↪ replying to MURALI PAZHAYANNUR
Art Kagel — — source: IIUG Forums & Mailing Lists

Sounds like the service name was not entered into /etc/services on the secondary. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Jul 13, 2011 at 8:57 PM, MURALI PAZHAYANNUR < pmurali@ftportfolios.com> wrote: > I am trying to setup HDR between 2 instances (IDS 11.50.FC5, HP-UX 11.31) > and > on the 'ontape -p' on the secondary I get the following message: > > 19:23:18 IBM Informix Dynamic Server Started. > 19:23:18 Segment locked: addr=c0000001c0000000, size=828485632 > > Wed Jul 13 19:23:18 2011 > > 19:23:18 Event alarms enabled. ALARMPROG = > '/usr/informix/etc/alarmprogram.sh' > 19:23:18 Booting Language <c> from module <> > 19:23:18 Loading Module <CNULL> > 19:23:18 Booting Language <builtin> from module <> > 19:23:18 Loading Module <BUILTINNULL> > 19:23:24 DR: DRAUTO is 0 (Off) > 19:23:24 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) > 19:23:24 Fast poll /dev/poll enabled. > 19:23:24 listener-thread: err = -25572: oserr = 226: errstr = : Network > driver > cannot bind a name to the port. > System error = 226. > 19:23:24 sql_listener: ASF_LISTEN failed > > 19:23:24 Attempting to bring listener thread down. > > 19:23:24 Server stopped. > > 1. The boxes trust each other ( via /etc/hosts, /etc/hosts.equiv) > 2. Primary onconfig: > > DBSERVERNAME nike_SPTCP_PRIM > > DBSERVERALIASES nike_SPTCP,nike_SP,nike_SPTCP_PRIM > > Secondary onconfig: > > DBSERVERNAME nike_SPTCP_SEC > > DBSERVERALIASES nike_SPTCP,nike_SP,nike_SPTCP_SEC > 3. Primary SQLHOSTS > > > ############################################################################ > nike_SP onipcshm hpnew nike_SP > nike_SPTCP onsoctcp hpnew nike_SPTCP> > ############################################################################ > nike_SPTCP_PRIM onsoctcp hpnew nike_SPTCP_PRIM > nike_SPTCP_SEC onsoctcp uxdr nike_SPTCP_SEC> > ############################################################################ > > Secondary SQLHOSTS > > > ############################################################################ > nike_SP onipcshm uxdr nike_SP > nike_SPTCP onsoctcp uxdr nike_SPTCP> > ############################################################################ > nike_SPTCP_PRIM onsoctcp hpnew nike_SPTCP_PRIM > nike_SPTCP_SEC onsoctcp uxdr nike_SPTCP_SEC> > ############################################################################ > > 4. /etc/services (Primary) > > nike_SPTCP 1532/tcp > nike_SBTCP 1531/tcp > nike_sbtcp 1541/tcp > nike_SPTCP_PRIM 1551/tcp ## Primary HDR service > nike_SPTCP_SEC 1561/tcp ## Secondary HDR service > > /etc/services (Secondary) > > nike_SPTCP 1528/tcp > nike_SPTCP_PRIM 1551/tcp ## Primary HDR service > nike_SPTCP_SEC 1561/tcp ## Secondary HDR service > > nike_DRTCP 1628/tcp > nike_drtcp 1728/tcp > > 5. netstat -a | grep 1551|1561 returns empty. > > 6. I can ping each box from the other by host name. > > Thanks for the assistance. > > Murali > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --bcaec5016181e1207004a7fd7597

↪ replying to MURALI PAZHAYANNUR
jak aka — — source: IIUG Forums & Mailing Lists

Something not matches on your ONCONFIG and /etc/services 2. Primary onconfig: DBSERVERNAME nike_SPTCP_PRIM DBSERVERALIASES nike_SPTCP,nike_SP,nike_SPTCP_PRIM << delete "nike_SP" (or Add "nike_SP" in /etc/services ) and delete "nike_SPTCP_PRIM" (repeat with DBSERVERNAME) >> Secondary onconfig: DBSERVERNAME nike_SPTCP_SEC DBSERVERALIASES nike_SPTCP,nike_SP,nike_SPTCP_SEC << delete ",nike_SP,nike_SPTCP_SEC" (same reason) >> 4. /etc/services (Primary) nike_SPTCP 1532/tcp << Change name to "nike_SP" >> nike_SBTCP 1531/tcp nike_sbtcp 1541/tcp nike_SPTCP_PRIM 1551/tcp ## Primary HDR service nike_SPTCP_SEC 1561/tcp ## Secondary HDR service << delete this line >> /etc/services (Secondary) nike_SPTCP 1528/tcp nike_SPTCP_PRIM 1551/tcp ## Primary HDR service << delete this line>> nike_SPTCP_SEC 1561/tcp ## Secondary HDR service << Add "nike_SBTCP 1531/tcp" if you want to use>> nike_DRTCP 1628/tcp nike_drtcp 1728/tcp ________________________________ From: MURALI PAZHAYANNUR <pmurali@ftportfolios.com> To: ids@iiug.org Sent: Thu, July 14, 2011 7:57:18 AM Subject: HDR setup- Network driver system error [24354] I am trying to setup HDR between 2 instances (IDS 11.50.FC5, HP-UX 11.31) and on the 'ontape -p' on the secondary I get the following message: 19:23:18 IBM Informix Dynamic Server Started. 19:23:18 Segment locked: addr=c0000001c0000000, size=828485632 Wed Jul 13 19:23:18 2011 19:23:18 Event alarms enabled. ALARMPROG = '/usr/informix/etc/alarmprogram.sh' 19:23:18 Booting Language <c> from module <> 19:23:18 Loading Module <CNULL> 19:23:18 Booting Language <builtin> from module <> 19:23:18 Loading Module <BUILTINNULL> 19:23:24 DR: DRAUTO is 0 (Off) 19:23:24 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) 19:23:24 Fast poll /dev/poll enabled. 19:23:24 listener-thread: err = -25572: oserr = 226: errstr = : Network driver cannot bind a name to the port. System error = 226. 19:23:24 sql_listener: ASF_LISTEN failed 19:23:24 Attempting to bring listener thread down. 19:23:24 Server stopped. 1. The boxes trust each other ( via /etc/hosts, /etc/hosts.equiv) 2. Primary onconfig: DBSERVERNAME nike_SPTCP_PRIM DBSERVERALIASES nike_SPTCP,nike_SP,nike_SPTCP_PRIM Secondary onconfig: DBSERVERNAME nike_SPTCP_SEC DBSERVERALIASES nike_SPTCP,nike_SP,nike_SPTCP_SEC 3. Primary SQLHOSTS ############################################################################ nike_SP onipcshm hpnew nike_SP nike_SPTCP onsoctcp hpnew nike_SPTCP ############################################################################ nike_SPTCP_PRIM onsoctcp hpnew nike_SPTCP_PRIM nike_SPTCP_SEC onsoctcp uxdr nike_SPTCP_SEC ############################################################################ Secondary SQLHOSTS ############################################################################ nike_SP onipcshm uxdr nike_SP nike_SPTCP onsoctcp uxdr nike_SPTCP ############################################################################ nike_SPTCP_PRIM onsoctcp hpnew nike_SPTCP_PRIM nike_SPTCP_SEC onsoctcp uxdr nike_SPTCP_SEC ############################################################################ 4. /etc/services (Primary) nike_SPTCP 1532/tcp nike_SBTCP 1531/tcp nike_sbtcp 1541/tcp nike_SPTCP_PRIM 1551/tcp ## Primary HDR service nike_SPTCP_SEC 1561/tcp ## Secondary HDR service /etc/services (Secondary) nike_SPTCP 1528/tcp nike_SPTCP_PRIM 1551/tcp ## Primary HDR service nike_SPTCP_SEC 1561/tcp ## Secondary HDR service nike_DRTCP 1628/tcp nike_drtcp 1728/tcp 5. netstat -a | grep 1551|1561 returns empty. 6. I can ping each box from the other by host name. Thanks for the assistance. Murali ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to jak aka
MURALI PAZHAYANNUR — — source: IIUG Forums & Mailing Lists

nike_SP is a shared memory connection and hence not in /etc/services Is repeating DBSERVERNAME in DBSERVERALIASES an issue or just not good practise. I have repeated this in the past and the HDR has worked correctly. Not sure what I am missing or where the mismatch is in this setup!! Thanks.

↪ replying to Art Kagel
MURALI PAZHAYANNUR — — source: IIUG Forums & Mailing Lists

Art, I have verified the secondary's /etc/services with sqlhosts and onconfig (see original post). I have two questions: 1. Can I use the same SERVERNUM value if the primary and secondary are on distinct boxes? 2. Can I use a shared memory connection name in DBSERVERALIASES in HDR? If the answers are 'yes' to both, then I am not sure where the problem is with my current setup. Thank you.

↪ replying to MURALI PAZHAYANNUR
Madison Pruet — — source: IIUG Forums & Mailing Lists

You might get an error like this because the socket is still in use. That can sometimes happen when IDS is brought down and the TCP socket was in a hung state so that the socket was not completely closed.. |------------> | From: | |------------> >------------------------------------------------------------------------------- -------------------------------------------------------------------| |"MURALI PAZHAYANNUR" <pmurali@ftportfolios.com> | >------------------------------------------------------------------------------- -------------------------------------------------------------------| |------------> | To: | |------------> >------------------------------------------------------------------------------- -------------------------------------------------------------------| |ids@iiug.org | >------------------------------------------------------------------------------- -------------------------------------------------------------------| |------------> | Date: | |------------> >------------------------------------------------------------------------------- -------------------------------------------------------------------| |07/13/2011 06:58 PM | >------------------------------------------------------------------------------- -------------------------------------------------------------------| |------------> | Subject: | |------------> >------------------------------------------------------------------------------- -------------------------------------------------------------------| |HDR setup- Network driver system error [24354] | >------------------------------------------------------------------------------- -------------------------------------------------------------------| |------------> | Sent by: | |------------> >------------------------------------------------------------------------------- -------------------------------------------------------------------| |ids-bounces@iiug.org | >------------------------------------------------------------------------------- -------------------------------------------------------------------| I am trying to setup HDR between 2 instances (IDS 11.50.FC5, HP-UX 11.31) and on the 'ontape -p' on the secondary I get the following message: 19:23:18 IBM Informix Dynamic Server Started. 19:23:18 Segment locked: addr=c0000001c0000000, size=828485632 Wed Jul 13 19:23:18 2011 19:23:18 Event alarms enabled. ALARMPROG = '/usr/informix/etc/alarmprogram.sh' 19:23:18 Booting Language <c> from module <> 19:23:18 Loading Module <CNULL> 19:23:18 Booting Language <builtin> from module <> 19:23:18 Loading Module <BUILTINNULL> 19:23:24 DR: DRAUTO is 0 (Off) 19:23:24 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) 19:23:24 Fast poll /dev/poll enabled. 19:23:24 listener-thread: err = -25572: oserr = 226: errstr = : Network driver cannot bind a name to the port. System error = 226. 19:23:24 sql_listener: ASF_LISTEN failed 19:23:24 Attempting to bring listener thread down. 19:23:24 Server stopped. 1. The boxes trust each other ( via /etc/hosts, /etc/hosts.equiv) 2. Primary onconfig: DBSERVERNAME nike_SPTCP_PRIM DBSERVERALIASES nike_SPTCP,nike_SP,nike_SPTCP_PRIM Secondary onconfig: DBSERVERNAME nike_SPTCP_SEC DBSERVERALIASES nike_SPTCP,nike_SP,nike_SPTCP_SEC 3. Primary SQLHOSTS ############################################################################ nike_SP onipcshm hpnew nike_SP nike_SPTCP onsoctcp hpnew nike_SPTCP ############################################################################ nike_SPTCP_PRIM onsoctcp hpnew nike_SPTCP_PRIM nike_SPTCP_SEC onsoctcp uxdr nike_SPTCP_SEC ############################################################################ Secondary SQLHOSTS ############################################################################ nike_SP onipcshm uxdr nike_SP nike_SPTCP onsoctcp uxdr nike_SPTCP ############################################################################ nike_SPTCP_PRIM onsoctcp hpnew nike_SPTCP_PRIM nike_SPTCP_SEC onsoctcp uxdr nike_SPTCP_SEC ############################################################################ 4. /etc/services (Primary) nike_SPTCP 1532/tcp nike_SBTCP 1531/tcp nike_sbtcp 1541/tcp nike_SPTCP_PRIM 1551/tcp ## Primary HDR service nike_SPTCP_SEC 1561/tcp ## Secondary HDR service /etc/services (Secondary) nike_SPTCP 1528/tcp nike_SPTCP_PRIM 1551/tcp ## Primary HDR service nike_SPTCP_SEC 1561/tcp ## Secondary HDR service nike_DRTCP 1628/tcp nike_drtcp 1728/tcp 5. netstat -a | grep 1551|1561 returns empty. 6. I can ping each box from the other by host name. Thanks for the assistance. Murali ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to MURALI PAZHAYANNUR
MURALI PAZHAYANNUR — — source: IIUG Forums & Mailing Lists

My HDR is running correctly now. Thank you all. Madison was right. A previous aborted attempt at 'ontape -p' had left a number of 'oninit -r' running still listening to the port that the fresh instance of 'ontape -p' was trying to connect. I killed those sessions and HDR was established with no changes to any of my settings.

↪ replying to MURALI PAZHAYANNUR
Art Kagel — — source: IIUG Forums & Mailing Lists

Yes, servernum just has to be unique on each machine. No, you cannot use a shared memory connection for HDR, nor can you use a stream pipe (onipcstr) connection. The connection between instances for HDR, SDS, RSS, and ER has to be a network connection (and IB that it has to be an SQLI type connection not DRDA). Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jul 14, 2011 at 9:15 AM, MURALI PAZHAYANNUR < pmurali@ftportfolios.com> wrote: > Art, > > I have verified the secondary's /etc/services with sqlhosts and onconfig > (see > original post). I have two questions: > > 1. Can I use the same SERVERNUM value if the primary and secondary are on > distinct boxes? > > 2. Can I use a shared memory connection name in DBSERVERALIASES in HDR? > > If the answers are 'yes' to both, then I am not sure where the problem is > with > my current setup. Thank you. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --bcaec51b9a018a338f04a80b5e51

↪ replying to Art Kagel
MURALI PAZHAYANNUR — — source: IIUG Forums & Mailing Lists

Just to be clear. You cannot use a shared memory connection in HDR, etc as DBSERVERNAME. You may use it in DBSERVERALIASES. My HDR is operational. I have identified the problem ( with tips from Madison) and posted below.

↪ replying to Art Kagel
Madison Pruet — — source: IIUG Forums & Mailing Lists

Just to explain Art's response just a bit. The main usage of the servernum is to create the key used to create shared memory. If you have two instances running on the same machine, you must have different servernums because they need to create different shared memory segment keys. M.P. |------------> | From: | |------------> >------------------------------------------------------------------------------- -------------------------------------------------------------------| |"Art Kagel" <art.kagel@gmail.com> | >------------------------------------------------------------------------------- -------------------------------------------------------------------| |------------> | To: | |------------> >------------------------------------------------------------------------------- -------------------------------------------------------------------| |ids@iiug.org | >------------------------------------------------------------------------------- -------------------------------------------------------------------| |------------> | Date: | |------------> >------------------------------------------------------------------------------- -------------------------------------------------------------------| |07/14/2011 12:09 PM | >------------------------------------------------------------------------------- -------------------------------------------------------------------| |------------> | Subject: | |------------> >------------------------------------------------------------------------------- -------------------------------------------------------------------| |Re: HDR setup- Network driver system error [24386] | >------------------------------------------------------------------------------- -------------------------------------------------------------------| |------------> | Sent by: | |------------> >------------------------------------------------------------------------------- -------------------------------------------------------------------| |ids-bounces@iiug.org | >------------------------------------------------------------------------------- -------------------------------------------------------------------| Yes, servernum just has to be unique on each machine. No, you cannot use a shared memory connection for HDR, nor can you use a stream pipe (onipcstr) connection. The connection between instances for HDR, SDS, RSS, and ER has to be a network connection (and IB that it has to be an SQLI type connection not DRDA). Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jul 14, 2011 at 9:15 AM, MURALI PAZHAYANNUR < pmurali@ftportfolios.com> wrote: > Art, > > I have verified the secondary's /etc/services with sqlhosts and onconfig > (see > original post). I have two questions: > > 1. Can I use the same SERVERNUM value if the primary and secondary are on > distinct boxes? > > 2. Can I use a shared memory connection name in DBSERVERALIASES in HDR? > > If the answers are 'yes' to both, then I am not sure where the problem is > with > my current setup. Thank you. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --bcaec51b9a018a338f04a80b5e51 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Related threads

Glossary