2 Replies Latest reply: May 12, 2014 6:12 AM by User511360-OC RSS

    server-side load balancing again

    User511360-OC

      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 ?

        • 1. Re: server-side load balancing again
          Anand...

          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

            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 ?