Setting up HDR- First Time -11.70 Innovator-C
Sunil was configuring HDR for the first time on IDS 11.70 Innovator-C; the secondary stayed in Fast Recovery and the log showed "DR: Cannot connect to primary server / DR: Turned off on secondary server". Suggestions covered checking UPDATABLE_SECONDARY (and its separate licensing), comparing mismatched parameters in both message logs, and verifying /etc/hosts, /etc/services, hosts.equiv/.rhosts and sqlhosts on both machines, plus the correct backup/physical-restore sequence. Since dbaccess connections still prompted for a password, the cause was diagnosed as missing host trust (hosts.equiv entries on both sides); Sunil acknowledged the advice but no confirmed fix is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi,
I am setting up HDR for the first time.
onstat - on primary shows
IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s
onstat - on secondry shows
IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up00s
onstat -m on secondry shows (while issuing onmode -d secondary primaryserver)
DR Cannot Connect to primary server
DR Turned off on secondary server
IBM Informix Dynamic Server Stopped
Any inputs would be helpful.
Thanks- Sunil
Hello.
Your secondary node is not an UPDATABLE_SECONDARY, really.
Check your configurations, ok?
# UPDATABLE_SECONDARY - Controls whether secondary servers can accept
# update, insert, and delete operations from clients.
# If enabled, specifies the number of connection
# threads between the secondary and primary servers
# for transmitting updates from the secondary.
# Acceptable values are:
# 0 Secondary server is read-only (default)
# 1 through twice the number of CPU VPs, threads
# for performing updates from the secondary.
# Valid for HDR, SDS, and RSS.
Attention! If you need your secondary node as a Read-Write one, you
should license it separately! ;)
Best regards.
Em 08/06/2011 09:32, SUNIL PAWAR escreveu:
> Hi,
>
> I am setting up HDR for the first time.
>
> onstat - on primary shows
>
> IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up
> 0:11:5s>
> onstat - on secondry shows
>
> IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up> 00s
>
> onstat -m on secondry shows (while issuing onmode -d secondary primaryserver)>
> DR Cannot Connect to primary server
> DR Turned off on secondary server
> IBM Informix Dynamic Server Stopped
>
> Any inputs would be helpful.
>
> Thanks- Sunil
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Alexandre Marini
Tecnologia da Informação - DBA
msn: alexandre_marini@hotmail.com
SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix
Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg>
IBM Certified System Administrator - Informix Dynamic Server V10 / V11
First let's know the exact steps that you took.
Second - look at the message log file on the primary and secondary. There
are several parameters which must match up. If they don't then a message
will be places in the message log file describing the mis-matches.
M.P.
From: "SUNIL PAWAR" <suniliyr@gmail.com>
To: ids@iiug.org
Date: 06/08/2011 07:36 AM
Subject: Setting up HDR- First Time -11.70 Innovator-C [23945]
Sent by: ids-bounces@iiug.org
Hi,
I am setting up HDR for the first time.
onstat - on primary shows
IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up
0:11:5s
onstat - on secondry shows
IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) --Up
00s
onstat -m on secondry shows (while issuing onmode -d secondaryprimaryserver)
DR Cannot Connect to primary server
DR Turned off on secondary server
IBM Informix Dynamic Server Stopped
Any inputs would be helpful.
Thanks- Sunil
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Hi - Thanks for the response.
On my Secondary
UPDATABLE_SECONDARY = 0 (Default)I am going to use this as Read Only. This should take care of the License i
guess.
Am trying to figure out links in /etc/services - /etc/sqlhosts -/etc/host.equiv
Thanks - Sunil
Hi Sunil,
It seems that your problem come from a connection problem (possibly a
server trust problem).
You need to create a small instance on the secondary machine just for
testing purposes (on small chunk is enough); Create the stores database
in it.
Then try to connect from your primary instance (thru dbaccess) to that
"test" instance in order to see if you can see the data.
Make sure that /etc/services, /etc/hosts, and /etc/hosts.equiv or
.rhosts and the sqlhosts files on both sides are set correctly,
otherwise the connections will fail.
If this works OK, then go ahead to try set up your HDR:
1/ Primary
- engine up and running
- ontape or onbar for the whole instance
- onmode -d primary <secondary instance name>
2/ Secondary
- restore the instance backed up on the primary thru ontape or onbar
(need a physical restore: ontape )p for example)
- onmode - d secondary <primary instance name>
Advice: have enough logs available in order not to loop thru the logs
list between the time you backup on the primary and the time you finish
th restore. If not you will need to go go get the logs from the logs
backed up.
Follow the contents of the online.log file to see the progress.
Khaled Bentebal
Email: khaled.bentebal@consult-ix.fr
Site Web: www.consult-ix.fr
Le 08/06/11 15:32, SUNIL PAWAR a écrit :
> Hi,
>
> I am setting up HDR for the first time.
>
> onstat - on primary shows
>
> IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up
> 0:11:5s>
> onstat - on secondry shows
>
> IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up> 00s
>
> onstat -m on secondry shows (while issuing onmode -d secondary primaryserver)>
> DR Cannot Connect to primary server
> DR Turned off on secondary server
> IBM Informix Dynamic Server Stopped
>
> Any inputs would be helpful.
>
> Thanks- Sunil
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Hi Khaled,
Thanks for your reply. I did follow the steps that you mentioned.
Before starting HDR i was able to connect primary to secondary and vice vesa
through dbaccess. I had to give user name and password to connect.
How ever on secondary server after giving
onmode -d secondary primaryservername,i am still getting
12:54:16 DR: new type = secondary, primary server name = serv1
12:54:16 DR: Trying to connect to primary server = serv1
12:54:16 DR: Cannot connect to primary server
12:54:16 DR: Turned off on secondary server
/etc/hosts
On Primary:
contains entry for Primary Server only
On Secondry:
Contains entry for Secondry Server only
/etc/hosts.equiv
On Primary
Contains entry for Secondry Server only
ON Secondry
No Entry
/etc/services
On Primary and Secondry Server
Contains port/setvice entries for both the Servers and Vice Versa
$INFORMIXDIR/etc/sqlhosts
On Primary and Secondry Server
Contains entries for both the Servers and Vice Versa
Has it got something to do with trusted connecton?.
Thanks once again- Sunil
If you had to enter a passwd, you have obviously a trusting problem.
Check /etc/hosts.equiv on both servers
Khaled Bentebal de mon portable
Le 9 juin 2011 à 15:44, "SUNIL PAWAR" <suniliyr@gmail.com> a écrit :
> Hi Khaled,
>
> Thanks for your reply. I did follow the steps that you mentioned.
> Before starting HDR i was able to connect primary to secondary and vice vesa
> through dbaccess. I had to give user name and password to connect.
>
> How ever on secondary server after giving
> onmode -d secondary primaryservername,> i am still getting
>
> 12:54:16 DR: new type = secondary, primary server name = serv1
> 12:54:16 DR: Trying to connect to primary server = serv1
> 12:54:16 DR: Cannot connect to primary server
> 12:54:16 DR: Turned off on secondary server
>
> /etc/hosts
> On Primary:
> contains entry for Primary Server only
> On Secondry:
> Contains entry for Secondry Server only
>
> /etc/hosts.equiv
> On Primary
> Contains entry for Secondry Server only
> ON Secondry
> No Entry
>
> /etc/services
> On Primary and Secondry Server
> Contains port/setvice entries for both the Servers and Vice Versa
>
> $INFORMIXDIR/etc/sqlhosts
> On Primary and Secondry Server
> Contains entries for both the Servers and Vice Versa
>
> Has it got something to do with trusted connecton?.
>
> Thanks once again- Sunil
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Noted and Thanks Once again - Sunil