Skip to Main Content
Oracle Net8 Configuration and Troubleshooting
book

Oracle Net8 Configuration and Troubleshooting

by Hugo Toledo, Jonathan Gennick
December 2000
Intermediate to advanced content levelIntermediate to advanced
408 pages
12h 26m
English
O'Reilly Media, Inc.
Content preview from Oracle Net8 Configuration and Troubleshooting

Forcing a Dedicated Server Connection

There really are no changes that you need to make to your Net8 configuration files in order to use MTS. Once you’ve configured MTS for an instance, new connections begin using it. What you can do using the Net8 configuration files is override the use of MTS in order to force a dedicated server connection to be made.

tnsnames.ora

Remember that MTS is best used in cases where a client has a lot of idle time. While one client is idle, a server process can do work for another. If you’re dealing with a client or a batch job that requires a high degree of throughput, and one that won’t have much idle time, you’ll be better off having them make a dedicated server connection. One way to do that is to create a separate net service name and add attribute (SERVER = DEDICATED) to the list of CONNECT_DATA attributes. For example, if you are using local naming, you could define a net service name in listener.ora as follows:

HERMAN-DEDICATED.GENNICK.ORG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)
                 (HOST = jonathan.gennick.org)
                 (PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = herman.gennick.org)
      (SERVER = DEDICATED)
    )
  )

Dedicated server connections can also be configured in Oracle Names. If you are using the command-line interface to Names, the same syntax applies. If you are using the Net8 Assistant, there’s a checkbox on the Advanced Service Options window that allows you to choose dedicated server.

sqlnet.ora

You can also force the use of dedicated ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Pro Oracle Database 11g RAC on Linux

Pro Oracle Database 11g RAC on Linux

Steve Shaw, Martin Bach
Oracle 11g

Oracle 11g

Lewis Cunningham

Publisher Resources

ISBN: 1565927532Catalog PageErrata