DR: Cannot connect to primary server
User configured HDR (High-Availability Data Replication) on IDS 9.40.UC5X3 but couldn't connect primary and secondary servers. The issue was using the wrong server names in onmode commands. Responders identified that the user was using Unix hostnames instead of the Informix instance service names from the first column of INFORMIXSQLHOSTS file. No explicit confirmation of successful resolution is provided in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Morning everyone,
This HDR is driving me nuts. I'm running IDS version 9.40.UC5X3 on both
servers. Replication worked before we moved the secondary server. Once I got
both my servers up and running and seeing each other, I performed the
following steps. Am I missing something???
1. dbaccess from both servers can login and see DB on other server.
2. Stopped all backups on primary server
3. Ran ontape -s -L 0
4. Put tape on secondary server
5. Ran ontape -p (Answered no to backup logs and level 1)
6. On secondary server I execute: onmode d secondary aimprd01 (Where aimprd01
is the name of my primary server)
When I do this I get the following entries in my online log:
04:18:19 Maximum server connections 0
04:18:22 Physical Restore of rootdbs, psapbtab, psapstab, psapclu, psapes46c,
psapbtab6, psappool, psapel46c, psapprot, psapdoc
u, psapload, psapstabx, psapuser1, psapddic, psapsource, psapbtab3, psapbtab2,
psapbtab1, logdbs, psapsystem, physdbs, psapglpca
d1, psapglpcad2, psapglpcad3, psapglpcai1, psapzzadptad1, psapzzadptad2,
psapzzadptad3, psapzzadptai1 Completed.
04:18:22 Checkpoint Completed: duration was 0 seconds.
04:18:22 Checkpoint loguniq 129914, logpos 0x864018, timestamp: 0x6cb5cfec
04:18:22 Maximum server connections 0
08:41:12 DR: Reservation of the last logical log for log backup turned off
08:41:12 DR: new type = secondary, primary server name = aimprd01
08:41:12 DR: Trying to connect to primary server = aimprd01
08:41:12 DR: Cannot connect to primary server
08:41:12 DR: Turned off on secondary server
When I run onmode -d primary sci01 on aimprd01 I get similar messages in my
online log:
09:04:42 Maximum server connections 136
09:17:34 DR: Primary to Primary
09:17:34 DR: new type = primary, secondary server name = sci01
09:17:34 DR: Cannot connect to secondary server
09:17:34 DR: Turned off on primary server
And now when I bring my secondary server fully online I can not access it from
my primary server via dbaccess. This is the list of servers can see:
aimprd01prdshm
aimprd01prdtcp
aimprd01pritcp
demo_on
demo_se
sci01sectcp
I chose the sci01sectcp server and tried to login, and recieved the following
error:
25539: Invalid connection-type.
This is my $INFORMIXSQLHOSTS file on the primary:
aimprd01prdshm onipcshm aimprd01 sapinfPRD
aimprd01prdtcp onsoctcp aimprd01 sapinfPRDaimprd01pritcp onsoctcp aimprd01 sapinfPRI s=6
sci01sectcp onsoctcp sci01 sapinfSEC s=6
This is my $INFORMIXSQLHOSTS file on the secondary:
demo_on onipcshm on_hostname on_servernamedemo_se seipcpip se_hostname sqlexec
sci01scishm onipcshm sci01 sapinfSCI
sci01scitcp onsoctcp sci01 sapinfSCI#aimprd01pritcp onsoctcp aimprd01 sapinfPRI s=6
sci01sectcp onsoctcp sci01 sapinfSEC s=6
aimprd01prdtcp onsoctcp aimprd01 sapinfPRD
Thanks in advance for any help.
CJ
I think you are using the wrong name in your 'onmode -d primary/secondary
' commands. You are using values from the host name (3rd) column. You
should have the name from the fourth column --> the service, I think.
"CJ BUTCHER" <creighton_butcher@adaptec.com>
Sent by: ids-bounces@iiug.org
08/06/2007 11:26 AM
Please respond to
ids@iiug.org
To
ids@iiug.org
cc
Subject
DR: Cannot connect to primary server [9701]
Morning everyone,
This HDR is driving me nuts. I'm running IDS version 9.40.UC5X3 on both
servers. Replication worked before we moved the secondary server. Once I
got
both my servers up and running and seeing each other, I performed the
following steps. Am I missing something???
1. dbaccess from both servers can login and see DB on other server.
2. Stopped all backups on primary server
3. Ran ontape -s -L 0
4. Put tape on secondary server
5. Ran ontape -p (Answered no to backup logs and level 1)
6. On secondary server I execute: onmode ?d secondary aimprd01 (Where
aimprd01
is the name of my primary server)
When I do this I get the following entries in my online log:
04:18:19 Maximum server connections 0
04:18:22 Physical Restore of rootdbs, psapbtab, psapstab, psapclu,
psapes46c,
psapbtab6, psappool, psapel46c, psapprot, psapdoc
u, psapload, psapstabx, psapuser1, psapddic, psapsource, psapbtab3,
psapbtab2,
psapbtab1, logdbs, psapsystem, physdbs, psapglpca
d1, psapglpcad2, psapglpcad3, psapglpcai1, psapzzadptad1, psapzzadptad2,
psapzzadptad3, psapzzadptai1 Completed.
04:18:22 Checkpoint Completed: duration was 0 seconds.
04:18:22 Checkpoint loguniq 129914, logpos 0x864018, timestamp: 0x6cb5cfec
04:18:22 Maximum server connections 0
08:41:12 DR: Reservation of the last logical log for log backup turned off
08:41:12 DR: new type = secondary, primary server name = aimprd01
08:41:12 DR: Trying to connect to primary server = aimprd01
08:41:12 DR: Cannot connect to primary server
08:41:12 DR: Turned off on secondary server
When I run onmode -d primary sci01 on aimprd01 I get similar messages in
my
online log:
09:04:42 Maximum server connections 136
09:17:34 DR: Primary to Primary
09:17:34 DR: new type = primary, secondary server name = sci01
09:17:34 DR: Cannot connect to secondary server
09:17:34 DR: Turned off on primary server
And now when I bring my secondary server fully online I can not access it
from
my primary server via dbaccess. This is the list of servers can see:
aimprd01prdshm
aimprd01prdtcp
aimprd01pritcp
demo_on
demo_se
sci01sectcp
I chose the sci01sectcp server and tried to login, and recieved the
following
error:
25539: Invalid connection-type.
This is my $INFORMIXSQLHOSTS file on the primary:
aimprd01prdshm onipcshm aimprd01 sapinfPRD
aimprd01prdtcp onsoctcp aimprd01 sapinfPRDaimprd01pritcp onsoctcp aimprd01 sapinfPRI s=6
sci01sectcp onsoctcp sci01 sapinfSEC s=6
This is my $INFORMIXSQLHOSTS file on the secondary:
demo_on onipcshm on_hostname on_servernamedemo_se seipcpip se_hostname sqlexec
sci01scishm onipcshm sci01 sapinfSCI
sci01scitcp onsoctcp sci01 sapinfSCI#aimprd01pritcp onsoctcp aimprd01 sapinfPRI s=6
sci01sectcp onsoctcp sci01 sapinfSEC s=6
aimprd01prdtcp onsoctcp aimprd01 sapinfPRD
Thanks in advance for any help.
CJ
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
I think you mean the first column. Which is the instance servername. Not the
UNIX server name.
**************************************
Ernie Knox
Sears Holding Co.
IT Database Administrator Specialist
IT Service Management, Strategy & Architecture
3333 Beverly Rd., B4-266A
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Fax: (847) 645-3874
Pager: (800) 759-8352 Pin#: 7271042
Email: eknox@sears.com
" It's always a great day to watch Football ! "
**************************************
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Joseph_Jurcazak@aotx.uscourts.gov
Sent: Monday, August 06, 2007 11:38 AM
To: ids@iiug.org
Subject: Re: DR: Cannot connect to primary server [9702]
I think you are using the wrong name in your 'onmode -d primary/secondary
' commands. You are using values from the host name (3rd) column. You
should have the name from the fourth column --> the service, I think.
"CJ BUTCHER" <creighton_butcher@adaptec.com>
Sent by: ids-bounces@iiug.org
08/06/2007 11:26 AM
Please respond to
ids@iiug.org
To
ids@iiug.org
cc
Subject
DR: Cannot connect to primary server [9701]
Morning everyone,
This HDR is driving me nuts. I'm running IDS version 9.40.UC5X3 on both
servers. Replication worked before we moved the secondary server. Once I
got
both my servers up and running and seeing each other, I performed the
following steps. Am I missing something???
1. dbaccess from both servers can login and see DB on other server.
2. Stopped all backups on primary server
3. Ran ontape -s -L 0
4. Put tape on secondary server
5. Ran ontape -p (Answered no to backup logs and level 1)
6. On secondary server I execute: onmode ?d secondary aimprd01 (Where
aimprd01
is the name of my primary server)
When I do this I get the following entries in my online log:
04:18:19 Maximum server connections 0
04:18:22 Physical Restore of rootdbs, psapbtab, psapstab, psapclu,
psapes46c,
psapbtab6, psappool, psapel46c, psapprot, psapdoc
u, psapload, psapstabx, psapuser1, psapddic, psapsource, psapbtab3,
psapbtab2,
psapbtab1, logdbs, psapsystem, physdbs, psapglpca
d1, psapglpcad2, psapglpcad3, psapglpcai1, psapzzadptad1, psapzzadptad2,
psapzzadptad3, psapzzadptai1 Completed.
04:18:22 Checkpoint Completed: duration was 0 seconds.
04:18:22 Checkpoint loguniq 129914, logpos 0x864018, timestamp: 0x6cb5cfec
04:18:22 Maximum server connections 0
08:41:12 DR: Reservation of the last logical log for log backup turned off
08:41:12 DR: new type = secondary, primary server name = aimprd01
08:41:12 DR: Trying to connect to primary server = aimprd01
08:41:12 DR: Cannot connect to primary server
08:41:12 DR: Turned off on secondary server
When I run onmode -d primary sci01 on aimprd01 I get similar messages in
my
online log:
09:04:42 Maximum server connections 136
09:17:34 DR: Primary to Primary
09:17:34 DR: new type = primary, secondary server name = sci01
09:17:34 DR: Cannot connect to secondary server
09:17:34 DR: Turned off on primary server
And now when I bring my secondary server fully online I can not access it
from
my primary server via dbaccess. This is the list of servers can see:
aimprd01prdshm
aimprd01prdtcp
aimprd01pritcp
demo_on
demo_se
sci01sectcp
I chose the sci01sectcp server and tried to login, and recieved the
following
error:
25539: Invalid connection-type.
This is my $INFORMIXSQLHOSTS file on the primary:
aimprd01prdshm onipcshm aimprd01 sapinfPRD
aimprd01prdtcp onsoctcp aimprd01 sapinfPRDaimprd01pritcp onsoctcp aimprd01 sapinfPRI s=6
sci01sectcp onsoctcp sci01 sapinfSEC s=6
This is my $INFORMIXSQLHOSTS file on the secondary:
demo_on onipcshm on_hostname on_servernamedemo_se seipcpip se_hostname sqlexec
sci01scishm onipcshm sci01 sapinfSCI
sci01scitcp onsoctcp sci01 sapinfSCI#aimprd01pritcp onsoctcp aimprd01 sapinfPRI s=6
sci01sectcp onsoctcp sci01 sapinfSEC s=6
aimprd01prdtcp onsoctcp aimprd01 sapinfPRD
Thanks in advance for any help.
CJ
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
CJ
> BUTCHER
> Sent: Monday, August 06, 2007 11:27 AM
> To: ids@iiug.org
> Subject: DR: Cannot connect to primary server [9701]
>
> Morning everyone,
>
> This HDR is driving me nuts. I'm running IDS version 9.40.UC5X3 on
both
> servers. Replication worked before we moved the secondary server. Once
I
> got
> both my servers up and running and seeing each other, I performed the
> following steps. Am I missing something???
>
> 1. dbaccess from both servers can login and see DB on other server.
> 2. Stopped all backups on primary server
> 3. Ran ontape -s -L 0
> 4. Put tape on secondary server
> 5. Ran ontape -p (Answered no to backup logs and level 1)
> 6. On secondary server I execute: onmode -d secondary aimprd01 (Where
> aimprd01
> is the name of my primary server)
You need the name of the database engine, not the server. Try this:
onmode -d secondary aimprd01prdtcp
>
> When I do this I get the following entries in my online log:
>
> 04:18:19 Maximum server connections 0
> 04:18:22 Physical Restore of rootdbs, psapbtab, psapstab, psapclu,
> psapes46c,
> psapbtab6, psappool, psapel46c, psapprot, psapdoc
> u, psapload, psapstabx, psapuser1, psapddic, psapsource, psapbtab3,
> psapbtab2,
> psapbtab1, logdbs, psapsystem, physdbs, psapglpca
> d1, psapglpcad2, psapglpcad3, psapglpcai1, psapzzadptad1,
psapzzadptad2,
> psapzzadptad3, psapzzadptai1 Completed.
> 04:18:22 Checkpoint Completed: duration was 0 seconds.
> 04:18:22 Checkpoint loguniq 129914, logpos 0x864018, timestamp:
0x6cb5cfec
>
> 04:18:22 Maximum server connections 0
> 08:41:12 DR: Reservation of the last logical log for log backup turned
off
> 08:41:12 DR: new type = secondary, primary server name = aimprd01
> 08:41:12 DR: Trying to connect to primary server = aimprd01
> 08:41:12 DR: Cannot connect to primary server
> 08:41:12 DR: Turned off on secondary server
>
> When I run onmode -d primary sci01 on aimprd01 I get similar messages
in
> my
> online log:
Same as above, database engine, not the server name.
onmode -d primary sci01sectcp
>
> 09:04:42 Maximum server connections 136
> 09:17:34 DR: Primary to Primary
> 09:17:34 DR: new type = primary, secondary server name = sci01
> 09:17:34 DR: Cannot connect to secondary server
> 09:17:34 DR: Turned off on primary server
>
> And now when I bring my secondary server fully online I can not access
it
> from
> my primary server via dbaccess. This is the list of servers can see:
>
> aimprd01prdshm
> aimprd01prdtcp
> aimprd01pritcp
> demo_on
> demo_se
> sci01sectcp
>
> I chose the sci01sectcp server and tried to login, and recieved the
> following
> error:
>
> 25539: Invalid connection-type.>
> This is my $INFORMIXSQLHOSTS file on the primary:
> aimprd01prdshm onipcshm aimprd01 sapinfPRD
> aimprd01prdtcp onsoctcp aimprd01 sapinfPRD> aimprd01pritcp onsoctcp aimprd01 sapinfPRI s=6
> sci01sectcp onsoctcp sci01 sapinfSEC s=6
>
> This is my $INFORMIXSQLHOSTS file on the secondary:
> demo_on onipcshm on_hostname on_servername> demo_se seipcpip se_hostname sqlexec
> sci01scishm onipcshm sci01 sapinfSCI
> sci01scitcp onsoctcp sci01 sapinfSCI> #aimprd01pritcp onsoctcp aimprd01 sapinfPRI s=6
> sci01sectcp onsoctcp sci01 sapinfSEC s=6
> aimprd01prdtcp onsoctcp aimprd01 sapinfPRD>
> Thanks in advance for any help.
>
> CJ
>
>
>
************************************************************************
**
> *****
> Forum Note: Use "Reply" to post a response in the discussion forum.
You are using RESTRICT port option (s=6) in your $INFORMIXSQLHOSTS, that is
why you are getting Invalid connection-type error. If you do not intend to
use s=6, removed that and you should be able to connect. Else, you need to
bring up server with DBSERVERALIASES in onconfig. Set your INFORMIXSERVER
to that DBSERVERALIASES name and connect to it. Also, add the machine name
in $INFORMIXDIR/etc/hosts.equiv respectively for the machine you want to
connect to.
Following is the v10 infocenter on RESTRICT setup. You can check yours for
9.40
http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.admin.doc/admin224.htm
Thanks,
Sen
__________________________________
"CJ BUTCHER"
<creighton_butche
r@adaptec.com> To
Sent by: ids@iiug.org
ids-bounces@iiug. cc
org
Subject
DR: Cannot connect to primary
08/06/2007 11:26 server [9701]
AM
Please respond to
ids@iiug.org
Morning everyone,
This HDR is driving me nuts. I'm running IDS version 9.40.UC5X3 on both
servers. Replication worked before we moved the secondary server. Once I
got
both my servers up and running and seeing each other, I performed the
following steps. Am I missing something???
1. dbaccess from both servers can login and see DB on other server.
2. Stopped all backups on primary server
3. Ran ontape -s -L 0
4. Put tape on secondary server
5. Ran ontape -p (Answered no to backup logs and level 1)
6. On secondary server I execute: onmode –d secondary aimprd01 (Where
aimprd01
is the name of my primary server)
When I do this I get the following entries in my online log:
04:18:19 Maximum server connections 0
04:18:22 Physical Restore of rootdbs, psapbtab, psapstab, psapclu,
psapes46c,
psapbtab6, psappool, psapel46c, psapprot, psapdoc
u, psapload, psapstabx, psapuser1, psapddic, psapsource, psapbtab3,
psapbtab2,
psapbtab1, logdbs, psapsystem, physdbs, psapglpca
d1, psapglpcad2, psapglpcad3, psapglpcai1, psapzzadptad1, psapzzadptad2,
psapzzadptad3, psapzzadptai1 Completed.
04:18:22 Checkpoint Completed: duration was 0 seconds.
04:18:22 Checkpoint loguniq 129914, logpos 0x864018, timestamp: 0x6cb5cfec
04:18:22 Maximum server connections 0
08:41:12 DR: Reservation of the last logical log for log backup turned off
08:41:12 DR: new type = secondary, primary server name = aimprd01
08:41:12 DR: Trying to connect to primary server = aimprd01
08:41:12 DR: Cannot connect to primary server
08:41:12 DR: Turned off on secondary server
When I run onmode -d primary sci01 on aimprd01 I get similar messages in my
online log:
09:04:42 Maximum server connections 136
09:17:34 DR: Primary to Primary
09:17:34 DR: new type = primary, secondary server name = sci01
09:17:34 DR: Cannot connect to secondary server
09:17:34 DR: Turned off on primary server
And now when I bring my secondary server fully online I can not access it
from
my primary server via dbaccess. This is the list of servers can see:
aimprd01prdshm
aimprd01prdtcp
aimprd01pritcp
demo_on
demo_se
sci01sectcp
I chose the sci01sectcp server and tried to login, and recieved the
following
error:
25539: Invalid connection-type.
This is my $INFORMIXSQLHOSTS file on the primary:
aimprd01prdshm onipcshm aimprd01 sapinfPRD
aimprd01prdtcp onsoctcp aimprd01 sapinfPRD
aimprd01pritcp onsoctcp aimprd01 sapinfPRI s=6
sci01sectcp onsoctcp sci01 sapinfSEC s=6
This is my $INFORMIXSQLHOSTS file on the secondary:
demo_on onipcshm on_hostname on_servername
demo_se seipcpip se_hostname sqlexec
sci01scishm onipcshm sci01 sapinfSCI
sci01scitcp onsoctcp sci01 sapinfSCI
#aimprd01pritcp onsoctcp aimprd01 sapinfPRI s=6
sci01sectcp onsoctcp sci01 sapinfSEC s=6
aimprd01prdtcp onsoctcp aimprd01 sapinfPRD
Thanks in advance for any help.
CJ
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
I know the feeling. Working with HDR sometimes makes my head spin as well. Take care. Clifton M. Bean Informix DBA / AIX System Admin Currency Technics & Metrics Phone: (972) 812-1411 x244 -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Wee Tung Sent: Monday, August 06, 2007 12:22 PM To: ids@iiug.org Subject: Re: DR: Cannot connect to primary server [9709] You are using RESTRICT port option (s=6) in your $INFORMIXSQLHOSTS, that is why you are getting Invalid connection-type error. If you do not intend to use s=6, removed that and you should be able to connect. Else, you need to bring up server with DBSERVERALIASES in onconfig. Set your INFORMIXSERVER to that DBSERVERALIASES name and connect to it. Also, add the machine name in $INFORMIXDIR/etc [rest clipped]
Hi Everett,
That partially worked. The onmode -d primary sci01sectcp command on the
primary now gives me the following:
10:24:18 DR: Primary to Primary
10:24:18 DR: new type = primary, secondary server name = sci01sectcp
10:24:20 DR: Primary server connected
10:24:21 DR: Secondary server needs failure recovery
Secondary still gives same error:
11:04:07 DR: Secondary to Secondary
11:04:07 DR: new type = secondary, primary server name = aimprd01prdtcp
11:04:07 DR: Trying to connect to primary server = aimprd01prdtcp
11:04:08 DR: Cannot connect to primary server
11:04:08 DR: Turned off on secondary server
Not sure why the first reply is all junk. Anyway, If you are using
RESTRICToption (s=3D6), please make sure you have it setup correctly.
Following is the v10 infocenter on RESTRICT setup. You can check the ma=
nual
for 9.40, I don't think there is a big different on setup
http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=3D=
/com.ibm.admin.doc/admin224.htm
Thanks,
Sen
=
"CJ BUTCHER" =
<creighton_butche =
r@adaptec.com> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
Re: RE: Cannot connect to primar=
y
08/06/2007 12:29 server [9712] =
PM =
=
=
Please respond to =
ids@iiug.org =
=
=
Hi Everett,
That partially worked. The onmode -d primary sci01sectcp command on the=
primary now gives me the following:
10:24:18 DR: Primary to Primary
10:24:18 DR: new type =3D primary, secondary server name =3D sci01sectc=
p
10:24:20 DR: Primary server connected
10:24:21 DR: Secondary server needs failure recovery
Secondary still gives same error:
11:04:07 DR: Secondary to Secondary
11:04:07 DR: new type =3D secondary, primary server name =3D aimprd01pr=
dtcp
11:04:07 DR: Trying to connect to primary server =3D aimprd01prdtcp
11:04:08 DR: Cannot connect to primary server
11:04:08 DR: Turned off on secondary server
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
Well that was interesting. I issued the onmode -d secondary aimprd01prdtcp as
suggested on the secondary and got the same error. I then issued the onmode -d
primary sci01sectcp as suggested on the primary and it worked. Ran to a
meeting and when I got back I reissued the onmode -d secondary aimprd01prdtcp
command it is now connected and working. I'm going to have check and see if I
have all my data, but at least I'm connected now.
Thank you all for the help!!!
CJ