2 Replies Latest reply on May 12, 2014 11:12 AM by User511360-OC

    server-side load balancing again

    User511360-OC
    User511360-OC May 12, 2014 5:54 AM

      Hello,

      Am I understand right, that I could not use the default service (that is named the same as database) for server side load-balancing, but I must create additional services by hand for this ? If yes, then I must also change client side tnsnames.ora everywhere for use of this new service ?

      • 1198 Views
      • Tags:
        • 1. Re: server-side load balancing again
          Anand...
          Anand... May 12, 2014 7:48 AM (in response to User511360-OC)

          Hi,

           

          I think you can definitely set default service for server side load  balancing without an issue. Are you facing issue while using default service?Did you check the number of session  based on service_name from gv$session?

           

          Anand

          • 2. Re: server-side load balancing again
            User511360-OC
            User511360-OC May 12, 2014 11:12 AM (in response to Anand...)

            Hello. At the moment I couldn't even change this service's properties:

            sql>select name, goal, clb_goal from dba_services where name='MYDB';

             

            NAME       GOAL  CLB_G

            ----------        -----      -----

            MYDB                  LONG

             

            So, I try to change CLB_GOAL to 'short' I got an error:

            $srvctl modify service -s MYDB -d MYDB -j SHORT

            PRKO-2120 : The internal database service MYDB cannot be managed with srvctl

             

            Or are there other ways to change this ?