TNS Names.ora File - Exercse

The sqlnet.ora file in further Detail

Working with sqlnet.ora and tnsnames.ora files

Objective:Define a sqlnet.ora and a tnsnames.ora file.

Exercise scoring

This exercise is worth a total of 20 points. To receive full credit, you will need to supply a complete tnsnames.ora entry for the new databases.

Background

Given the class project, you are now ready to define a master tnsnames.ora file and sqlnet.ora file. Let us review our connectivity rules:
Corporate headquarters ( $ORACLE_SID=HQ, hostname=abq) has identified a need to capture daily summary information on the total number of orders at each remote site

($ORACLE_SID=ORDER, raleigh_host=raleigh, colorado_host=dilbert).

They also want to know the total production volumes for each product ( $ORACLE_SID=MFG, hostname=fred) at the Rochester plant. In addition, each of the sales offices needs to check the inventory levels at Rochester to ensure that the product for each order is in stock.

Instructions

Given the sample template below, create a tnsnames.ora file that can be used by all clients at ABC Corporation.

location=
(DESCRIPTION=
       (ADDRESS=
       (PROTOCOL=TCP)
       (HOST=host_name)
       (PORT=1527)
       )       
       (CONNECT_DATA=
       (SID=site_identifier)
       )
)

Hint

Remember that both Raleigh and Colorado Springs are running identical databases.

Submitting the exercise

Type or paste your answer into the text box below. Then click the Submit button to submit your answer and view a results page.