RelationalDBDesign RelationalDBDesign


Serverside Configuration   «Prev  Next»
Lesson 6 Using the Oracle Net Assistant, part 1
Objective Describe the uses of the Oracle Net Assistant.

Using the Oracle Net Assistant

The Oracle Net Assistant automated the population of the parameter files for Oracle 8 prior to the release of Oracle Net Manager with Oracle 9i. It should be noted that there were some problems with the Oracle Net Assistant, because it can only handle parameter files it has created, and it may have failed if it was run against parameter files that had been created manually. (This problem has been repaired in Oracle8i.) Hence, many long-time Oracle shops continue to maintain their parameter files by hand.
View the image below to see the main screen of the Oracle Net Assistant legacy interface which is no longer in use.

Legacy interface

Oracle Integration Cloud Service

Oracle Net Manager

Oracle Net Manager provides the same features as Oracle Enterprise Manager with the addition of configuring profiles.

Viewing Listener Configuration

The Oracle Net listener (the listener) runs on your database host and handles incoming client requests. With Oracle Enterprise Manager Database Control (Database Control), you can view the status of the listener, which is set to start automatically whenever your host is restarted. You can also view the listener status at the command line.
To view information about the listener with Database Control:
On the Database Home page, under the heading General, click the Listener link.
The Listener page appears, displaying the following information about the listener:
  1. Current status
  2. Availability over the last 24 hours
  3. Alias
  4. Version
  5. Oracle home for the listener
  6. Net address
  7. Configuration file (listener.ora) location
  8. Start time
  9. Host
  10. (Optional) Status of Oracle Restart

You can use the Oracle Net Assistant to accomplish a variety of tasks, including:
  1. Choosing the naming methods
  2. Defining trace levels for the listener
  3. Configuring the procedure for logging on to the client
  4. Routing connection requests from the client
  5. Specifying the TNS TMEOUT value
We will take a closer look at these procedures in the coming lessons.
The next lesson looks at how to use the Oracle Net Assistant to choose naming methods.