Oracle DBA - Tools for Network Configuration


I have created this learn oracle "The step 10 process" Oracle Tutorial to help Database aspirants to accomplish their dream of working as Oracle Database administrator. I have tried to keep it simple and Oracle DBA friendly. Use NEXT and PREVIOUS Button to navaigate away and to a chapter. Since i myself had been a Database adminstrator trainer and has got real life experience of working as a Oracle DBA, I would welcome any sort of queries and doubts or modifications to webmaster@oracleonline.info.

Step 4 - Tools for Network Configuration

Learn Oracle - Oracle Net Configuration Assistant

The Oracle Universal Installer launches Oracle Net Configuration Assistant after the database is installed. Oracle Net Configuration Assistant enables Oracle DBA to configure the listening protocol address and service information for an Oracle database. During a typical database install (as opposed to client install), Oracle Net Configuration Assistant automatically configures a listener with a name of LISTENER that has a TCP/IP listening protocol address for the Oracle database that Oracle DBA install. If Oracle DBA do a custom install, Oracle Net Configuration Assistant prompts Oracle DBA to configure a listener name and protocol address of your choice.

Oracle Net Configuration Assistant is primarily a post installation tool. Thereafter, Oracle provides other means for network configuration, which are the Oracle Enterprise Manager and Oracle Net Manager.

Enterprise Manager

Enterprise Manager enables you to manage your server-side network configuration with two pages: the Listener page and the Net Services Administration page.

The Net Services Administration page enables Oracle DBA to do the following:
Configure the following:

Local naming (tnsnames.ora files) on the machine running the database

Directory naming


Search and sort local and directory naming entries

Export directory naming entries to tnsnames.ora file

Perform the following administrative tasks for a selected listener:
  1. Show current status
  2. Change status (start/stop listener)
  3. Change tracing settings
  4. Change logging settings
Oracle DBA can navigate to the Net Services page from the Home page by clicking Listener under General. The Listener page appears. Under Related Links, click Net Services Administration.

Oracle Net Manager

Oracle DBA can access Oracle Net Manager from the command line or for Windows platforms through the Start menu.

For command line (UNIX, Linux, or Windows) run netmgr.

On Windows choose: Start > Programs > Oracle - home-name > Configuration and Migration Tools > Net Manager

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


STEP 4 - Next Topics
After installing your Oracle software and database, Oracle DBA have a fully functional database with a client/server network environment that has been minimally configured.This Step contains the topics to help Oracle DBA completely configure your client/server network. Learn Oracle DBA Step 4 by clicking links below:
Understanding Network ConfigurationOracle DBA
Oracle Net Listener ConfigurationOracle DBA
Client ConfigurationConfiguring client
Connection RequestsConnection Requests
Naming MethodsNaming Methods
Tools for Network ConfigurationTools for network configuration
Viewing Listener Configuration
Starting and Shutting down the Listener
Configuring Oracle Networking on Client Machine
More Tutorials on Oracle dba ...

Source : Oracle Documentation | Oracle DBA

Want to share or request Oracle Tutorial articles to become a Oracle DBA. Direct your requests to webmaster@oracleonline.info