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.
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:
Current status
Availability over the last 24 hours
Alias
Version
Oracle home for the listener
Net address
Configuration file (listener.ora) location
Start time
Host
(Optional) Status of Oracle Restart
You can use the Oracle Net Assistant to accomplish a variety of tasks, including:
Choosing the naming methods
Defining trace levels for the listener
Configuring the procedure for logging on to the client
Routing connection requests from the client
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.