Hi Team,
Yes the port is opened from both servers, i tested it using telnet.
I tried some changes like adding the hostname in the /etc/hosts file.
Also removed informix from hosts.equiv and added the respective hosts.
Now i get the following errors.
PRIMARY
2:49:29 DR: Receive error
02:49:29 dr_accept thread : asfcode = -25582: oserr = 0: errstr = : Network connection is broken.
02:49:29 DR_ERR set to -1
02:49:30 rolling upgrade Invalid Level 15 12
02:49:30 rolling upgrade version mismatch ol_norwaysoc
02:49:48 rolling upgrade Invalid Level 15 12
02:49:48 rolling upgrade version mismatch ol_norwaysoc
SECONDARY
02:48:48 DR_ERR set to -1
02:49:29 DR: Secondary to Secondary
02:49:29 DR: new type = secondary, primary server name = labsoc
02:49:29 DR: Trying to connect to primary server = labsoc
02:49:29 rolling upgrade Invalid Level 12 15
02:49:29 rolling upgrade version mismatch labsoc
02:49:29 DR: Cannot connect to primary server
02:49:29 DR: Turned off on secondary server
02:49:30 DR: Receive error
02:49:30 dr_accept thread : asfcode = -25582: oserr = 0: errstr = : Network connection is broken.
02:49:30 DR_ERR set to -1
There is no firewall that is blocking the servers.
I used the same servers for a Guardium test and there was no issue regarding ports.
I checked the ports and 16001 is present in both.
tcp 0 0 192.168.1.59.16001 *.* LISTEN == primary
tcp 0 0 192.168.1.61.16001 *.* LISTEN == secondary
Thanks
------------------------------
koonjul khemraj
------------------------------
Original Message:
Sent: Tue October 04, 2022 03:43 AM
From: Kirit Rana
Subject: Replication of Informix
Gerd
I don't believe that matters. If you wanted to keep your HDR traffic separate from your user traffic, an option would be to create the HDR connection with an INFORMIXSERVER setting defined as part of DBSERVERALIASES and operating through a different port.
Koonjul, Is port 16001 open in both directions?
------------------------------
Kirit Rana
Original Message:
Sent: Tue October 04, 2022 02:46 AM
From: Gerd Kaluzinski
Subject: Replication of Informix
I know this problem.
It is related to the fact, that you should set the name "ol_norwaysoc" as DBSERVERNAME, not as DBSERVERALIAS.
Just change these names and you will see all works as designed.
Mit freundlichen Grüßen / Kind regards
Gerd Kaluzinski
DataOps Application Consultant
IBM Expert Labs DACH, Data & AI
-------------------------------------------------------------------------------------------------------------------------------------------
IBM Deutschland
Mies-van-der-Rohe-Straße 6
80807 München
Phone: +49-175-228 1983
E-Mail: gerd.kaluzinski@de.ibm.com
-------------------------------------------------------------------------------------------------------------------------------------------
IBM Deutschland GmbH
Vorsitzender des Aufsichtsrats: Sebastian Krause
Geschäftsführung: Gregor Pillen (Vorsitzender), Nicole Reimer, Gabriele Schwarenthorer, Christine Rupp, Frank Theisen
Sitz der Gesellschaft: Ehningen / Registergericht: Amtsgericht Stuttgart, HRB 14562 / WEEE-Reg.-Nr. DE 99369940
Mit freundlichen Grüßen / Kind regards
Original Message:
Sent: 10/3/2022 6:30:00 AM
From: koonjul khemraj
Subject: RE: Replication of Informix
Thanks Andreas/Art,
I have tested the below commands as requested, but both servers cannot connect.
PRIMARY - AIXSANTO
onmode -d primary ol_norwaysoc
-- On-Line (Prim)
Log_Primary
DR: Primary to Primary
DR: new type = primary, secondary server name = ol_norwaysoc
DR: Cannot connect to secondary server
SECONDARY - tiger4S
onmode -d secondary labsoc
-- Fast Recovery (Sec)
Log_Secondary
DR: Secondary to Secondary
DR: new type = secondary, primary server name = labsoc
DR: Trying to connect to primary server = labsoc
DR: Cannot connect to primary server
The replication is not working automatically.
------------------------------
koonjul khemraj
Original Message:
Sent: Fri September 30, 2022 12:13 PM
From: Art Kagel
Subject: Replication of Informix
OK, in the SQLHOSTS the comments say that labsoc is the primary and ol_norwaysoc is the HDR secondary, however, the error messages on the primary say that it thinks that the secondary is labsoc and the primary is ol_norwaysoc. Which is correct?
If the SQLHOSTS entries are correct then you onmode -d commands are backwards!
On the primary you should be running:
onmode -d primary ol_norwaysoc
And on the secondary it should be:
onmode -d secondary labsoc
You have to tell the primary that it is primary to what secondary and on the secondary you have to tell it the name of the primary.
Art
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
Original Message:
Sent: Fri September 30, 2022 10:18 AM
From: Andreas Legner
Subject: Replication of Informix
Not seeing any sign for a trust problem being in your way - how would you know it's about trust?
You might be confusing primary and secondary, or which command to run where ...
Apparently you're running 'onmode -d primary labsoc' on one side - which one?
And 'onmode -d secondary ol_norwayso[c?]' on the other side?
But your sqlhosts details seem to indicate labsoc is your primary and ol_norwaysoc the secondary.
So the commands should be:
- on AIXSANTO (primary box): onmode -d primary ol_norwaysoc
- on tiger4s (secondary box): onmode -d secondary labsoc
The names you provide in these commands should be the opposite side's Informix server.
Does this help?
Andreas
------------------------------
Andreas Legner
Original Message:
Sent: Fri September 30, 2022 10:00 AM
From: koonjul khemraj
Subject: Replication of Informix
Hi Art,
The SQLHOSTS details are:-
PRIMARY
lab onipcshm AIXSANTO 16000
labsoc onsoctcp AIXSANTO sqlexec
Server
ol_norwaysoc onsoctcp tiger4S sqlexec
SECONDARY
ol_norway onipcshm tiger4S 16000
ol_norwaysoc onsoctcp tiger4S sqlexec
Server
labsoc onsoctcp AIXSANTO sqlexec
SERVICES
sqlexec 16001/tcp #HDR
hosts.equiv
+ informix
HDRtrust
##Trusted Host ##Trusted User
AIXSANTO informix
tiger4S informix
I put some additional configs above.
Thanks
Khemraj
------------------------------
koonjul khemraj
Original Message:
Sent: Fri September 30, 2022 09:24 AM
From: Art Kagel
Subject: Replication of Informix
Please post your SQLHOSTS settings from both servers' hosts for both servers.
Art
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
Original Message:
Sent: Fri September 30, 2022 04:07 AM
From: koonjul khemraj
Subject: Replication of Informix
Hi Team,
I am setting up HA for Informix. I am getting issue with trusting both Primary + Secondary Servers.
The errors are as follow:
Primary
DR: new type = primary, secondary server name = labsoc
DR: Cannot connect to secondary server
DR: Turned off on primary server
Secondary
DR: new type = secondary, primary server name = ol_norwayso
DR: Trying to connect to primary server = ol_norwaysoc
DR: Cannot connect to primary server
DR: Turned off on secondary server
I tried both the /etc/hosts.equiv and REMOTE_SERVER_CFG in the onconfig file but they are not working.
Telnet is working
$ telnet 192.168.1.61 16001
Trying...
Connected to 192.168.1.61.
Escape character is '^]'.
The new primary server is online however the new secondary is still on -- Fast Recovery (Sec) -- Up.
Kindly share your inputs.
Thanks
Regards
Khemraj
------------------------------
koonjul khemraj
------------------------------
#hdr
#Informix