Skip to Main Content
Forums

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Howto configure dispatcher for Service=<sid>XDB and other services

oramanFeb 21 2014 — edited Feb 21 2014

Hello,

I'm wondering how its possible to allow shared connections for SERVICE=<sid>XDB and other services!?

in Mike Ault's Blog: DISPATCH the DISPATCHERS Parameter!

is written

Although shared server is enabled, this configuration permits only sessions that connect to the XDB service to use shared server. To enable shared server for regular database sessions (for submitting SQL statements), you must add an additional dispatcher configuration, or replace the existing configuration with one that is not specific to XDB


I would need to add additional services and also keep <sid>XDB.


this config allowes only XDB:

ALTER SYSTEM set DISPATCHERS = '(PROTOCOL=TCP)(DISPATCHERS=1)(SESSIONS=400)(SERVICE=<sid>XDB)' scope=both;


this allowes shared server for regular database sessions (for submitting SQL statements) but not for XDB:

ALTER SYSTEM set DISPATCHERS = '(PROTOCOL=TCP)(DISPATCHERS=1)(SESSIONS=400)' scope=both;


I would like to have both.

Any links and help appreciated
This post has been answered by JohnWatson on Feb 21 2014
Jump to Answer

Comments

sb92075

what problem are you trying to solve.

Do you realize & understand that the listener is NEVER involved with the ongoing packet exchange between the client & the database?

oraman

the fact is that a client which uses shared connection

jdbc:oracle:thin:@(description = (ADDRESS_LIST =

     (address = (host = host1)(protocol = tcp)(port = 1521))

     (address = (host = host2)(protocol = tcp)(port = 1521))

     (failover = yes))

     (connect_data =

       (service_name = test.example.com)

       (failover_mode =

          (type = select)

          (method = basic)

       )

       (SERVER=shared)

     )

)

is not able to connect to db if dispatcher configuration remains default

*.dispatchers='(PROTOCOL=TCP) (SERVICE=<sid>XDB)'

the strange thing is - dataguard automatic failover works only with service=<sid>XDB.

its not documented, however this is the result of tests on 11gR2.

JohnWatson
Answer

You configure dispatchers for as many services as you want. For example,

orclz>

orclz> sho parameter dispatcher

NAME                                 TYPE       VALUE

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

dispatchers                          string     (PROTOCOL=TCP) (SERVICE=orclzX

                                                DB)

max_dispatchers                      integer

orclz> alter system set dispatchers='(pro=tcp)(dispatchers=2)(service=orclz)(index=1)';

System altered.

orclz> sho parameter dispatcher

NAME                                 TYPE       VALUE

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

dispatchers                          string     (PROTOCOL=TCP) (SERVICE=orclzX

                                                DB), (PROTOCOL=tcp)(dispatcher

                                                s=2)(service=orclz)

max_dispatchers                      integer

orclz> alter system set dispatchers='(pro=tcp)(dispatchers=2)(service=another)(index=2)';

System altered.

orclz> sho parameter dispatcher

NAME                                 TYPE       VALUE

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

dispatchers                          string     (PROTOCOL=TCP) (SERVICE=orclzX

                                                DB), (PROTOCOL=tcp)(dispatcher

                                                s=2)(service=orclz), (PROTOCOL

                                                =tcp)(dispatchers=2)(service=a

                                                nother)

max_dispatchers                      integer

orclz>

Marked as Answer by oraman · Sep 27 2020
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 21 2014
Added on Feb 21 2014
#general-database-discussions, #services
3 comments
3,253 views