This discussion is archived
5 Replies Latest reply: Jan 2, 2013 2:13 AM by rajeshp RSS

multiple active standby pairs on the same pair of hosts

932780 Newbie
Currently Being Moderated
Dear sir,

I have already created an active standby pair(without cache group) and managed by Oracle Clusterware and it work fine.

Now ,I create another DSN and I also want to create another active standby pair on the same 2 hosts.

I try to setup and reference this setting:
http://docs.oracle.com/cd/E21901_01/doc/timesten.1122/e21632/upgrade.htm#CIAHEBBH

But I get error message in ttcwmessage :
TT17013 The default hostname cannot be set to host_name because a local host of host_name is currently in use

Is it possible that I can create more than one A/S pair(with different DSN) ?
Or any other solution? Thanks!

TimesTen version:11.2.2.3.3 (64 bit Linux/x86_64)
  • 1. Re: multiple active standby pairs on the same pair of hosts
    rajeshp Explorer
    Currently Being Moderated
    How you are configuring the new DSNs ? Has it needed to be managed by CRS ?



    Regards
    Rajesh
  • 2. Re: multiple active standby pairs on the same pair of hosts
    932780 Newbie
    Currently Being Moderated
    Dear Rajesh,

    Thanks for reply.
    Yes.
    The old DSN is nrett and the new DSN is CONTAINER.
    The new DSN is also needed to be managed by Oracle CRS,too.

    sys.odbc.ini :
    [nrett]
    Driver=/app/TimesTen/tt1122/lib/libtten.so
    DataStore=/ckp7201/oradata/nrett/nrett
    LogDir=/tra7201/oradata/nrett
    PermSize=61440
    TempSize=4096
    PLSQL=1
    Connections=200
    DurableCommits=1
    ConnectionCharacterSet=UTF8
    DatabaseCharacterSet=UTF8

    [CONTAINER]
    Driver=/app/TimesTen/tt1122/lib/libtten.so
    DataStore=/ckp7201/oradata/CONTAINER/CONTAINER
    LogDir=/tra7201/oradata/CONTAINER
    PermSize=131072
    TempSize=16384
    Connections=1314
    DurableCommits=1
    PLSQL=1
    LogFileSize=256
    LogBufMB=256
    LogBufParallelism=32
    ConnectionCharacterSet=ZHT16BIG5
    DatabaseCharacterSet=ZHT16BIG5

    cluster.oracle.ini :
    [nrett]
    MasterHosts=nrett01p,nrett02p
    MasterVIP=10.1.213.212,10.1.213.213
    VIPInterface=bond0
    VIPNetMask=255.255.255.0
    ReturnServiceAttribute=RETURN TWOSAFE
    RepBackupDir=/backup/RECOVERY/nrett
    RepBackupPeriod=360
    RepfullbackupCycle=2
    AutoRecover=Y

    [CONTAINER]
    MasterHosts=nrett02p,nrett01p
    ReturnServiceAttribute=RETURN TWOSAFE
    RepBackupDir=/backup/RECOVERY/CONTAINER
    RepBackupPeriod=360
    RepfullbackupCycle=2

    Edited by: user10069004 on 2012/12/26 上午 2:25
  • 3. Re: multiple active standby pairs on the same pair of hosts
    rajeshp Explorer
    Currently Being Moderated
    Thanks for the update.

    But can you share when exactly you are getting this error ?

    Is ttcwadmin -create or ttcwadmin -start is working fine for DSN CONTAINER ?

    Are you trying to set hostname using ttHostNameSet builtin procedure ?

    Regards
    Rajesh
  • 4. Re: multiple active standby pairs on the same pair of hosts
    932780 Newbie
    Currently Being Moderated
    Thanks for reply.

    It failed at ttcwadmin -create step.
    I am not set hostname using ttHostNameSet builtin procedure.

    The following is the procedure:
    nrett02p(timesten):/home/timesten:[]$ ttcwadmin -status
    TimesTen Cluster status report as of Fri Dec 28 15:48:21 2012

    ====================================================================
    TimesTen daemon monitors:
    Host:NRETT01P Status: online
    Host:NRETT02P Status: online

    ====================================================================
    ====================================================================
    TimesTen Cluster agents
    Host:NRETT01P Status: online
    Host:NRETT02P Status: online

    ====================================================================


    Status of Cluster related to DSN NRETT:
    ====================================================================
    1. Status of Cluster monitoring components:
    Monitor Process for Active datastore:RUNNING on Host nrett01p
    Monitor Process for Standby datastore:RUNNING on Host nrett02p
    Monitor Process for Master Datastore 1 on Host nrett01p: RUNNING
    Monitor Process for Master Datastore 2 on Host nrett02p: RUNNING
    Backup process monitor:
    Status: online Host: nrett01p
    Backup process monitor:
    Status: online Host: nrett02p

    2.Status of Datastores comprising the cluster
    Master Datastore 1:
    Host:nrett01p
    Status:AVAILABLE
    State:ACTIVE
    Grid:NO GRID
    Master Datastore 2:
    Host:nrett02p
    Status:AVAILABLE
    State:STANDBY
    Grid:NO GRID
    ====================================================================
    The cluster containing the replicated DSN is online
    nrett02p(timesten):/home/timesten:[]$ ttstatus
    TimesTen status report as of Fri Dec 28 15:49:19 2012

    Daemon pid 10072 port 53388 instance tt1122
    TimesTen server pid 16302 started on port 53389
    ------------------------------------------------------------------------
    Data store /ckp7201/oradata/CONTAINER/CONTAINER
    There are no connections to the data store
    Replication policy : Manual
    Cache Agent policy : Manual
    PL/SQL enabled.
    ------------------------------------------------------------------------
    Data store /ckp7201/oradata/nrett/nrett
    There are 20 connections to the data store
    Shared Memory KEY 0x160002ef ID 706445321
    PL/SQL Memory KEY 0x170002ef ID 706478090 Address 0x7fa0000000
    Type PID Context Connection Name ConnID
    Process 16398 0x0000000001f7a860 ttCRSmaster 1
    Process 18429 0x00000000016f7f50 ttCRSsubservice 3
    Replication 18387 0x000000000414c3a0 LOGFORCE:1107724608 236
    Replication 18387 0x00000000041da810 REPHOLD:1091467584 235
    Replication 18387 0x000000000422ef50 XLA_PARENT:1094617408 233
    Replication 18387 0x0000000004243670 REPLISTENER:1098877248 232
    Replication 18387 0x00000000042d8b70 TRANSMITTER(M):1110874432 231
    Replication 18387 0x000000000436c050 RECEIVER:1114024256 230
    Replication 18387 0x00007f328c002d90 FAILOVER:1103317312 234
    Subdaemon 10077 0x00000000023280a0 Manager 247
    Subdaemon 10077 0x000000000237e830 Rollback 246
    Subdaemon 10077 0x00000000024581b0 Flusher 245
    Subdaemon 10077 0x000000000248c7f0 Aging 243
    Subdaemon 10077 0x00000000024a0cd0 Log Marker 241
    Subdaemon 10077 0x00000000024b51b0 AsyncMV 239
    Subdaemon 10077 0x00000000024d5510 HistGC 237
    Subdaemon 10077 0x0000000002529a30 IndexGC 238
    Subdaemon 10077 0x0000000002599110 Monitor 244
    Subdaemon 10077 0x00000000025ad5f0 Deadlock Detector 240
    Subdaemon 10077 0x00000000025c1ad0 Checkpoint 242
    RAM residence policy: Always
    Replication policy : Always
    Replication agent is running.
    Cache Agent policy : Manual
    PL/SQL enabled.
    ------------------------------------------------------------------------
    Accessible by group ttadmin
    End of report
    nrett02p(timesten):/home/timesten:[]$ ttcwadmin -create -dsn CONTAINER
    Successful connection with Oracle clusterware stack
    replication DDL = create active standby pair "CONTAINER" on "nrett02p","CONTAINER" on "nrett01p" RETURN TWOSAFE

    Enter internal UID with ADMIN privileges: sysadm
    Enter password for the same UID:
    Enter any phrase for password encryption:
    Data store exists and uid/pwd are verified on host nrett02p
    Create active standby pair replication scheme on host nrett02p and make it the active master? (Y/N)Y
    Waiting for confirmation from hosts...
    ====================================================================
    Error:
    ====================================================================
    (ttCWAdmin:) crsctl.c(19628): TT48013: Failed to create ACTIVE STANDBY PAIR scheme for DSN CONTAINER on host nrett02p.
    Uid/Pwd could not be verified on host nrett01p
    ====================================================================
    Error:
    ====================================================================
    Error: Failed to create Cluster of an Active Standby pair



    ttcwmesg.log :
    2012-12-28 15:49:33.08 Info: : 12322: (ttCWAdmin:) cwadmin.c(862):Starting ttCWAdmin -create -dsn CONTAINER
    2012-12-28 15:49:33.08 Info: : 12322: (ttCWAdmin:) cwutils.c(1516): The option file for TimesTen CRS agent is = /app/TimesTen/tt1122/info/ttcrsagent.options
    2012-12-28 15:49:33.08 Info: : 12322: (ttCWAdmin:) cwutils.c(1609):The port number of TimesTen CRS agent is 53394
    2012-12-28 15:49:33.09 Info: : 12322: (ttCWAdmin:) crsctl.c(1037): daemon home = /app/TimesTen/tt1122/info
    2012-12-28 15:49:33.16 Info: : 12322: (ttCWAdmin:) crsctl.c(22159): TimesTen CW Admin registering with shared member number 4
    2012-12-28 15:49:33.16 Info: : 12322: (ttCWAdmin:) crsctl.c(22200): Registration successful for cwadmin, shared member number 4
    2012-12-28 15:49:33.19 Info: : 12322: (ttCWAdmin:) crsctl.c(14598): The cluster with DSN CONTAINER is available
    2012-12-28 15:49:33.19 Info: : 12322: (ttCWAdmin:) crsctl.c(22335): Port number for TimesTen cluster agent on host nrett02p : 53394
    2012-12-28 15:49:33.19 Info: : 12322: (ttCWAdmin:) crsctl.c(1563):TimesTen CRS Agent port number:53394
    2012-12-28 15:49:33.19 Info: : 12322: (ttCWAdmin:) crsctl.c(1580): Connected to TimesTen CRS Agent on host nrett02p
    2012-12-28 15:49:33.19 Info: : 9899: (ttClusterAgent:) crsagent.c(1216): TimesTen CRS agent accepted new request
    2012-12-28 15:49:33.19 Info: : 9899: (ttClusterAgent:) crsagent.c(1269):TimesTen Cluster agent received "create"
    2012-12-28 15:49:33.36 Info: : 9899: (ttClusterAgent:) crsagent.c(1288): TimesTen CRS agent successfully received cluster configuration model forDSN CONTAINER
    2012-12-28 15:49:33.36 Info: : 12322: (ttCWAdmin:) crsctl.c(1607): Successfully sent the replication model to TimesTen CRS Agent on host nrett02p
    2012-12-28 15:49:33.36 Info: : 12322: (ttCWAdmin:) crsctl.c(22335): Port number for TimesTen cluster agent on host nrett01p : 53394
    2012-12-28 15:49:33.36 Info: : 12322: (ttCWAdmin:) crsctl.c(1563):TimesTen CRS Agent port number:53394
    2012-12-28 15:49:33.36 Info: : 12322: (ttCWAdmin:) crsctl.c(1580): Connected to TimesTen CRS Agent on host nrett01p
    2012-12-28 15:49:33.52 Info: : 12322: (ttCWAdmin:) crsctl.c(1607): Successfully sent the replication model to TimesTen CRS Agent on host nrett01p
    2012-12-28 15:49:33.52 Info: : 9899: (ttClusterAgent:) crsagent.c(1362): TimesTen CRS agent successfully received all application information
    2012-12-28 15:49:39.45 Info: : 9899: (ttClusterAgent:) crsagent.c(1860): TimesTen CRS agent is verifying password on DSN CONTAINER
    2012-12-28 15:49:39.86 Info: : 9899: (ttClusterAgent:) crsagent.c 1944:TimesTen CRS agent has been successfully connected to to DSN CONTAINER
    2012-12-28 15:49:41.80 Err : : 9899: (ttClusterAgent:) crsagent.c(2239): S1000:[TimesTen][TimesTen 11.2.2.3.3 ODBC Driver][TimesTen]TT17013: The default hostname cannot be set to NRETT02P because a local host of NRETT01P is currently in use. -- file "repDDL.c", lineno 24301, procedure "sbRepHostnameSet"
    2012-12-28 15:49:42.90 Err : : 12322: (ttCWAdmin:) crsctl.c(19628): TT48013: Failed to create ACTIVE STANDBY PAIR scheme for DSN CONTAINER on host nrett02p.
    2012-12-28 15:49:42.94 Err : : 12322: (ttCWAdmin:) crsctl.c(19680): TT48012: Could not successfully verify user ID and password(s) for DSN CONTAINER on host nrett01p.
    2012-12-28 15:49:42.94 Err : : 9899: (ttClusterAgent:) cwutils.c(2000): TT16032: Call to recv() failed. System Error: -1
    2012-12-28 15:49:42.94 Err : : 9899: (ttClusterAgent:) crsagent.c(1798): TT48090: TimesTen Cluster agent could not successfully receive uid for the cluster containing the DSN CONTAINER.
  • 5. Re: multiple active standby pairs on the same pair of hosts
    rajeshp Explorer
    Currently Being Moderated
    Are you able to configure "Container" DSN using

    [CONTAINER]
    MasterHosts=nrett01p,nrett02p

    Can you share your /etc/hosts file output ?

    Is it possible for you to raise Service Request with Oracle Support ? There are certain things which we can verify more through SR .

    Regards
    Rajesh

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points