Managing Users  «Prev  Next»

Configuring Oracle Net Client - Exercise

Editing the tnsnames.ora file

Objective: Edit your tnsnames.ora file, using Oracle Net Configuration Assistant, and add an entry for the COIN instance.

Exercise Scoring

You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the Submit button to receive full credit.

Background and Overview

In order for you to connect to a database on another computer, you need to tell the Oracle Net software where that database is. You do this by adding an entry for the database in a file named tnsnames.ora. The Oracle Net Configuration Assistant utility facilitates this process.


If you have Oracle installed on a computer, and are following along with the steps in this course, run the Oracle Net Configuration Assistant utility to edit your tnsnames.ora file, and add an entry pointing to the COIN database.
Oracle Net Configuration Assistant (NETCA) is fully supported and recommended for use in Oracle 13c. It's a primary tool used for configuring and managing network components for your Oracle database. Here are some of the tasks you can perform with NETCA in Oracle 13c:
  • Configuring listeners: Create, modify, and manage Oracle Net Listeners
  • Configuring naming methods: Set up local naming (tnsnames.ora) or directory naming (LDAP)
  • Configuring net service names: Define network service aliases used for connections.

Submitting your Exercise

When you are done, click on the Submit button to receive full credit for this exercise.