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

Chapter 8. Net8 Failover and Load Balancing

Net8 supports two important advanced features: failover and load balancing. These options are actually related, and they are usually used in Oracle Parallel Server (OPS) environments. Failover allows you to configure Net8 such that failure to connect to one instance results in a connection attempt to a backup instance. Failover is used in high-availability environments to ensure that clients are always able to connect to a database. Load balancing allows you to distribute client connections among the various nodes accessing an OPS database.

Failover

Where Net8 is concerned, failover refers to the ability to switch to another database instance when the connection to the primary instance fails. Consider the situation shown in Figure 8.1 where a client connects to an instance named PROD01 in a Parallel Server environment. Under some circumstances, if the PROD01 instance fails, Net8 can automatically connect the client to the backup instance named PROD02.

Failover to a backup instance in an OPS environment

Figure 8-1. Failover to a backup instance in an OPS environment

Connection failures can be broadly categorized as follows:

  • Those that occur while attempting to connect for the first time

  • Those that occur after a connection has been established

The first category is the easiest one to deal with. If you attempt to connect to an instance and for some reason that attempt fails, you can simply try again, ...

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