Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

server-side load balancing again

User511360-OCMay 12 2014 — edited May 12 2014

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 ?

Comments

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

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 ?

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 9 2014
Added on May 12 2014
2 comments
1,294 views