O'Reilly logo

Oracle Net8 Configuration and Troubleshooting by Jonathan Gennick, Hugo Toledo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Configuring a Client

Configuring a client to use Connection Manager involves making some changes to the definitions of the net service names used by that client. If you’re using Oracle Names (or some other central repository for service names) then you can make the changes centrally. Otherwise, you’ll need to make changes to your client’s tnsnames.ora file.

Connection Concentration

Connection concentration is attained by routing Net8 connections from the client, through Connection Manager, and then on to the server. To accomplish that, you need to configure your net service names with two addresses instead of just one. The first address points to the Connection Manager instance, and the second address points to the Net8 listener on the database server. The addresses should be embedded within an address list. For example:

PROD.GENNICK.ORG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = cman01.gennick.org)(PORT = 1630))
      (ADDRESS = (PROTOCOL = TCP)(HOST = donna.gennick.org)(PORT = 1523))
    )
    (SOURCE_ROUTE = YES)
    (CONNECT_DATA =
      (SERVICE_NAME = donna.gennick.org)
    )
  )

If you read Chapter 8, you’re probably thinking that this looks a lot like the setup you would use to implement either of those features. It is. The key difference is the use of the SOURCE_ROUTE parameter. Setting (SOURCE_ROUTE = YES) tells Net8 that Connection Manager is being used and that the connection should be routed through each address in sequence. Here is what happens when you connect using this ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required