3 Replies Latest reply: Mar 28, 2012 12:31 PM by Levi Pereira RSS

    PRCD-1210 : The service name

    user10674190
      Hi all,

      I am getting a error message when I try to create a new service with my Oracle One Node:

      srvctl add service -d orcl -s orcl
      PRCD-1210 : The service name orcl cannot be same as the database default service name orcl

      PS.: I would like to create service name with the same database name.

      Can anybody help me?

      Thanks in advance.

      Leonardo.
        • 1. Re: PRCD-1210 : The service name
          Levi Pereira
          user10674190 wrote:
          Hi all,

          I am getting a error message when I try to create a new service with my Oracle One Node:

          srvctl add service -d orcl -s orcl
          PRCD-1210 : The service name orcl cannot be same as the database default service name orcl

          PS.: I would like to create service name with the same database name.

          Can anybody help me?
          By default this service already exists. Check on your Listener this Service Name is registered.
          So, you must create the service with another "service_name"

          If you use tnsnames.ora to connect on RAC you can use the alias called "orcl" with service_name "srv_orcl" for example.

          This is a restriction, it is not possible to bypass it.
          *PRCD-1210 : The service name orcl cannot be same as the database default service name orcl*
          Regards,
          Levi Pereira
          • 2. Re: PRCD-1210 : The service name
            user10674190
            Thanks for your replay Levi.

            Excellent idea, I've created srv_orcl service for orcl database:


            *# srvctl config service -d orcl*

            Service name: srv_orcl
            Service is enabled
            Server pool: orcl
            Cardinality: 1
            Disconnect: false
            Service role: PRIMARY
            Management policy: AUTOMATIC
            DTP transaction: false
            AQ HA notifications: true
            Failover type: NONE
            Failover method: NONE
            TAF failover retries: 180
            TAF failover delay: 5
            Connection Load Balancing Goal: LONG
            Runtime Load Balancing Goal: NONE
            TAF policy specification: BASIC
            Edition:
            Preferred instances: orcl_1
            Available instances:

            After that I changed Failover type and method:

            *# srvctl modify service -d orcl -s srv_orcl -q TRUE -m BASIC -P BASIC -e SELECT -z 180 -w 5 -j LONG*

            *# srvctl config service -d orcl*

            Service name: srv_orcl
            Service is enabled
            Server pool: orcl
            Cardinality: 1
            Disconnect: false
            Service role: PRIMARY
            Management policy: AUTOMATIC
            DTP transaction: false
            AQ HA notifications: true
            Failover type: SELECT
            Failover method: BASIC
            TAF failover retries: 180
            TAF failover delay: 5
            Connection Load Balancing Goal: LONG
            Runtime Load Balancing Goal: NONE
            TAF policy specification: BASIC
            Edition:
            Preferred instances: orcl_1
            Available instances:


            And I use this TNSNAMES (following your suggestion)

            orcl =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = racone01brz-scan)(PORT = 1521))(LOAD_BALANCE = yes)
            (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = srv_orcl)
            (FAILOVER_MODE =
            (TYPE = SELECT)
            (METHOD = BASIC)
            (RETRIES = 180)
            (DELAY = 5)
            )
            )
            )


            But, my problem is: When I connect on database, failover_type and failover_method column are NONE:


            SQL> conn system/manager@orcl
            Connected.
            SQL> select service_name,failover_type,failover_method from v$session where username='SYSTEM'
            2 /

            SERVICE_NAME FAILOVER_TYPE FAILOVER_M
            ---------------------------------------------------------------- ------------- ----------
            srv_orcl NONE NONE


            Please, do you know why don't show me BASIC and SELECT?

            Thanks in advance.

            Leonardo.
            • 3. Re: PRCD-1210 : The service name
              Levi Pereira
              Hi,

              On MOS have useful docs to help you with this issue:

              11gR2(11.2) RAC TAF Configuration for Admin and Policy Managed Databases [ID 1312749.1]

              How to Setup SCAN Listener and Client for TAF and Load Balancing [Video] [ID 1188736.1]

              Any doubt just ask.

              Regards,
              Levi Pereira