Loading Consent Dialog

Network Admin   «Prev  Next»

Add Net Features - Exercise

Add Net features 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 Oracle8i 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:
  1. Failover is on.
  2. Load balancing is on.
  3. 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.