New entries in tnsnames.ora File - Exercise

Add Network capabilities to the tnsnames.ora file

Course project: Modify tnsnames.ora
Objective: Add new entries to the tnsnames.ora file.

Exercise Scoring

This exercise is worth 10 points.

Background | Overview

In this exercise, you will add new entries to the tnsnames.ora file to help the House-O-Pets database handle thousands of concurrent user connections.

Fact File

Review the fact file to find out more information about the House-O-Pets and its Oracle Database. Click the Fact File Table Data link to see the contents of the tables in the House-O-Pets database.
Fact File Table Data

Download files

None.

Scenario

The House-O-Pets database in Atlanta, which you added as a node in a previous lesson, is an MTS. To help this database handle thousands of concurrent user connections, you must create multiple listeners for the database.

Instructions

Given the original tnsnames.ora file below, add the appropriate entries for the tnsnames.ora file. You need to consider these factors:

Failover is on.
Load balancing is on.
The first listener address is already shown. The second listener is on the same host and the same protocol, but is on port 1526.

PETS_ATLANTA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ATLANTA.EPETS.COM)
        (PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = HOUSEOPETS)
    )
  )

Submitting your Exercise

Type (or cut and paste) your plan into the box below to submit your answer.
Click the Submit button when finished to submit the exercise. Remember to submit all of your answers at once.