4 Replies Latest reply: Jul 22, 2013 11:52 AM by Chrisjenkins-Oracle RSS

    unable to create active standby replication with oracle clusterware

    1001703

      Hi

       

      unable to create active standby replication with oracle clusterware

       

       

      [ttadmin ttdb]$ ttcwadmin -create -dsn TT_TEST

      Successful connection with Oracle clusterware stack

      replication DDL = create active standby pair "TT_TEST" on "40.46.134.10","TT_TEST" on "40.46.134.22" 

       

      (ttCWAdmin:) crsctl.c(22353): TT48004: clssgspubdata failed with status = 12.

      (ttCWAdmin:) crsctl.c(22355): TT48010: Connection to TimesTen Cluster agent on host vfs1uup02 failed.

      (ttCWAdmin:) crsctl.c(1550): TT48009: Private hostname not found for the host vfs1uup02.

      Error: Cluster creation unsuccessful

        • 1. Re: unable to create active standby replication with oracle clusterware
          Chrisjenkins-Oracle

          In most cases you should not use the RepDDL option. Normally the replication scheme DDL is generated automatically based on the other parameters you have specified in your cluster.oracle.ini file. If you do use RepDDL you must not use IP addresses or actual hostnames. Instead you must use placeholders such as MASTERHOST[1], MASTERHOST[2] and so on. Please consult the information on RepDDL in section 8 of the Timesten Replication Guide.

           

          Chris

          • 2. Re: unable to create active standby replication with oracle clusterware
            1001703

            Hi Chris

             

            The parameter of cluster.oracle.ini file are

             

            [UUPDB]

            MasterHosts=vfs1uup01,vfs1uup02

            MasterVIP=10.46.114.220,10.46.114.221

            VIPInterface=bond0.101

            VIPNetMask=255.255.255.0

            CacheConnect=Y

            GridPort=5002,5003

             

            RepDDL option was never used , but when the following command is issued the getting the error

             

             

            $ ttcwadmin -create  -ttclusterini /timesten/tt1122/TimesTen/ttdb/info/cluster.oracle.ini -dsn UUPDB

             

            Successful connection with Oracle clusterware stack

            replication DDL = create active standby pair "UUPDB" on "10.46.114.220","UUPDB" on "10.46.114.221" 

             

            (ttCWAdmin:) crsctl.c(1623): TT48011: Could not successfully send cluster configuration model for DSN UUPDB to TimesTen Cluster agent on host vfs1uup02.

            Error: Cluster creation unsuccessful

            • 3. Re: unable to create active standby replication with oracle clusterware
              1001703

              Adding some points to the problem

               

              [ttadmin@VFS1UUP01 info]$ ttcwadmin -init -dsn UUPDB

              Oracle Clusterware home = /u01/app/11.2.0/grid, hosts = vfs1uup01,vfs1uup02

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

               

              Registering agent resources:... Registration complete.

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

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

               

              Registering daemon resources:... Registration complete.

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

              [ttadmin@VFS1UUP01 info]$

              [ttadmin@VFS1UUP01 info]$

              [ttadmin@VFS1UUP01 info]$

              [ttadmin@VFS1UUP01 info]$ ttcwadmin -status -dsn UUPDB

              TimesTen Cluster status report as of Thu Jul 18 16:25:58 2013

               

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

              TimesTen daemon monitors:

              Host:VFS1UUP01 Status: online

              Host:VFS1UUP02 Status: online

               

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

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

              TimesTen Cluster agents

              Host:VFS1UUP01 Status: online

              Host:VFS1UUP02 Status: online

               

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

              (ttCWAdmin:) crsctl.c(23387): TT48020: TimesTen cluster containing DSN UUPDB not found.

               

              Unable to understand why the particular DSN is not found as above it has been registered

              • 4. Re: unable to create active standby replication with oracle clusterware
                Chrisjenkins-Oracle

                This could be an issue with your Clusterware setup. Troubleshooting this is beyond what we can do in the forum I think. Please log an SR with support so they can help you diagnose and resolve this.

                 

                Thanks,

                 

                Chris