3 Replies Latest reply: May 7, 2013 9:31 AM by Chrisjenkins-Oracle RSS

    ttcwadmin -create -dsn <name> returns error TT48008

    Ed Smith
      We had a functioning Oracle Clusterware managed Active Standby Pair configuration, but wanted to add an additional application to the cluster.oracle.ini.
      I did: ttcwadmin -stop -dsn <name>
      Then: ttcwadmin -drop -dsn <name>

      I updated the cluster.oracle.ini on both nodes adding the new application.

      Then: ttcwadmin -create -dsn <name>
      (ttCWAdmin:) crsctl.c(23373): TT48008: A cluster for the DSN <name> has already been registered.

      The description for TT48008 says: Stop and deregister the cluster corresponding to the DSN, before you create a new cluster with the same DSN.

      I thought that was what the ttcwadmin -drop did. I have done ttcwadmin -shutdown and the -init, but the error remains.

      The command: crsctl status resource -t
      gives no indication of what resource I should unregister (delete?, crsctl has no unregister option as far as I can tell)

      Edited by: Ed Smith on May 2, 2013 1:42 PM
        • 1. Re: ttcwadmin -create -dsn <name> returns error TT48008
          Gennady Sigalaev
          Hello Ed,

          Could you please post the following:
          1 - TimesTen and Oracle Clusterware (GI) versions
          2 - Output
          crsctl status resource -t (crs_stat -t),
          ps -ef | grep ttCRS (for linux),
          ttCWAdmin -status

          Try to rerun CRS and create a configuration after that.

          Best regards,
          Gena
          • 2. Re: ttcwadmin -create -dsn <name> returns error TT48008
            Ed Smith
            We have since determined that there is a bug in 11.2.2.3.0 which does not allow more that 1 application to be defined, but here is the info requested after success:

            ~> ttversion
            TimesTen Release 11.2.2.4.5 (64 bit Linux/x86_64) (linux:17001) 2013-03-30T17:04:57Z
            Instance admin: timesten
            Instance home directory: /opt/TimesTen/linux
            Group owner: timesten
            Daemon home directory: /opt/TimesTen/linux/info
            PL/SQL enabled.

            Oracle Clusterware 11.2.0.2 with patches 9974223, 13696242 and 13923804

            ~> crsctl stat res -t
            --------------------------------------------------------------------------------
            NAME TARGET STATE SERVER STATE_DETAILS
            --------------------------------------------------------------------------------
            Local Resources
            --------------------------------------------------------------------------------
            ora.ASM_NONDATA.dg
            ONLINE ONLINE eqiomsl711
            ONLINE ONLINE eqiomsl712
            ora.LISTENER.lsnr
            ONLINE ONLINE eqiomsl711
            ONLINE OFFLINE eqiomsl712
            ora.asm
            ONLINE ONLINE eqiomsl711
            ONLINE ONLINE eqiomsl712
            ora.gsd
            OFFLINE OFFLINE eqiomsl711
            OFFLINE OFFLINE eqiomsl712
            ora.net1.network
            ONLINE ONLINE eqiomsl711
            ONLINE ONLINE eqiomsl712
            ora.ons
            ONLINE ONLINE eqiomsl711
            ONLINE ONLINE eqiomsl712
            ora.registry.acfs
            ONLINE ONLINE eqiomsl711
            ONLINE ONLINE eqiomsl712
            --------------------------------------------------------------------------------
            Cluster Resources
            --------------------------------------------------------------------------------
            TT_Activeservice_linux_timesten_TTPFEI1
            1 ONLINE ONLINE eqiomsl711
            TT_Agent_linux_timesten_EQIOMSL711
            1 ONLINE ONLINE eqiomsl711
            TT_Agent_linux_timesten_EQIOMSL712
            1 ONLINE ONLINE eqiomsl712
            TT_App_linux_timesten_TTPFEI1_InsightPFE_0
            1 ONLINE ONLINE eqiomsl711
            TT_App_linux_timesten_TTPFEI1_InsightPFE_1
            1 ONLINE ONLINE eqiomsl712
            TT_Daemon_linux_timesten_EQIOMSL711
            1 ONLINE ONLINE eqiomsl711
            TT_Daemon_linux_timesten_EQIOMSL712
            1 ONLINE ONLINE eqiomsl712
            TT_Master_linux_timesten_TTPFEI1_0
            1 ONLINE ONLINE eqiomsl711
            TT_Master_linux_timesten_TTPFEI1_1
            1 ONLINE ONLINE eqiomsl712
            TT_Subservice_linux_timesten_TTPFEI1
            1 ONLINE ONLINE eqiomsl712
            ora.LISTENER_SCAN1.lsnr
            1 ONLINE ONLINE eqiomsl712
            ora.LISTENER_SCAN2.lsnr
            1 ONLINE ONLINE eqiomsl711
            ora.LISTENER_SCAN3.lsnr
            1 ONLINE ONLINE eqiomsl711
            ora.cvu
            1 ONLINE ONLINE eqiomsl711
            ora.eqiomsl711.vip
            1 ONLINE ONLINE eqiomsl711
            ora.oc4j
            1 ONLINE ONLINE eqiomsl711
            ora.scan1.vip
            1 ONLINE ONLINE eqiomsl712
            ora.scan2.vip
            1 ONLINE ONLINE eqiomsl711
            ora.scan3.vip
            1 ONLINE ONLINE eqiomsl711

            ~> ps -ef |grep ttCRS
            timesten 4930 1 0 May03 ? 00:00:00 /opt/TimesTen/linux/bin/ttCRSAgentCmd start
            timesten 4966 1 0 May03 ? 00:00:00 /opt/TimesTen/linux/bin/ttCRSdaemonCmd start
            timesten 8424 1 0 May03 ? 00:01:25 /opt/TimesTen/linux/bin/ttCRSactiveserviceCmd start
            timesten 8614 1 0 May03 ? 00:00:02 /opt/TimesTen/linux/bin/ttCRSmasterCmd start
            timesten 11077 1 0 May05 ? 00:00:09 /opt/TimesTen/linux/bin/ttCRSappCmd start

            ~> ttcwadmin -status
            TimesTen Cluster status report as of Mon May 6 09:32:30 2013

            ====================================================================
            TimesTen daemon monitors:
            Host:EQIOMSL711 Status: online
            Host:EQIOMSL712 Status: online

            ====================================================================
            ====================================================================
            TimesTen Cluster agents
            Host:EQIOMSL711 Status: online
            Host:EQIOMSL712 Status: online

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


            Status of Cluster related to DSN TTPFEI1:
            ====================================================================
            1. Status of Cluster monitoring components:
            Monitor Process for Active datastore:RUNNING on Host eqiomsl711
            Monitor Process for Standby datastore:RUNNING on Host eqiomsl712
            Monitor Process for Master Datastore 1 on Host eqiomsl711: RUNNING
            Monitor Process for Master Datastore 2 on Host eqiomsl712: RUNNING
            Monitor for Application InsightPFE_0: RUNNING on Host eqiomsl711
            Monitor for Application InsightPFE_1: RUNNING on Host eqiomsl712

            2.Status of Datastores comprising the cluster
            Master Datastore 1:
            Host:eqiomsl711
            Status:AVAILABLE
            State:ACTIVE
            Grid:NO GRID
            Master Datastore 2:
            Host:eqiomsl712
            Status:AVAILABLE
            State:STANDBY
            Grid:NO GRID
            ====================================================================
            The cluster containing the replicated DSN is online

            Edited by: Ed Smith on May 6, 2013 9:34 AM
            • 3. Re: ttcwadmin -create -dsn <name> returns error TT48008
              Chrisjenkins-Oracle
              I believe that this was already handled via an SR and a bug was identified that is fixed in a more recent release.

              Chris