6 Configuration and Administration Tools Overview

Oracle Enterprise Manager

Oracle Enterprise Manager enables you to configure Oracle Net Services for any Oracle home across multiple file systems. It also provides common administration functions for listeners. Oracle Enterprise Manager provides an integrated environment for configuring and managing Oracle Net Services.

You can use Oracle Enterprise Manager to configure and administer the following from multiple Oracle homes:

• Listeners—Configure listeners to receive client connections.

• Naming—Define simple names, connect identifiers, and map them to connect descriptors to identify the network location and identification of a service. Oracle Net Manager supports configuration of connect descriptors in local tnsnames.ora files or a centralized directory service.

• File Location—Change the file location of the Oracle home.

  See Also:

  Oracle Enterprise Manager documentation set and online Help for information about using Oracle Enterprise Manager

Accessing the Net Services Administration Page

To access the Net Services Administration page:

1. From the Login to Database page, enter the database credentials, and then click Login.

   The Database page appears.

2. In the General section, click the listener.

   The Listener Home page appears.

3. In the Related Links section, click Net Services Administration.

   The Net Services Administration page appears.

4. Select an Oracle home location for network configuration files.

5. From the Administer list, select one of the following options:

   • Listeners

   • Directory Naming

   • Local Naming

   • File Location

6. Click Go.

   If you selected Listeners, Directory Naming, or Local Naming, then the Net Services Administration: Host Login page appears.

7. Enter the username and password credentials for the computer, and then click Login.

   If you selected Directory Naming, then the Net Services Administration: Directory Server Login page appears.

8. In the User DN field, enter an authorized user that has access to the directory.

9. If you want to add or modify entries, then enter a directory administrator user that has been given add and modify privileges in the form of a distinguished name. c=US,o=ACME,ou=admin,cn=scott, for example, is the DN for an administrator named Scott.

10. In the Password field, enter the password for the user.

11. Click Login.

Oracle Net Manager

Oracle Net Manager enables you to configure Oracle Net Services for an Oracle home on a local client or server host.

You can use Oracle Net Manager to configure the following network components:

• Naming—Define simple names, connect identifiers, and map them to connect descriptors to identify the network location and identification of a service. Oracle Net Manager supports configuration of connect descriptors in local tnsnames.ora files or a centralized directory service.

• Naming Methods—Configure the different ways in which connect identifiers are resolved into connect descriptors.

• Profiles—Configure preferences for enabling and configuring Oracle Net features on the client or server.

• Listeners—Create and configure listeners to receive client connections.

This section introduces you to the features of Oracle Net Manager. However, the primary documentation for using Oracle Net Manager is the accompanying online Help. This section contains these topics:

• Starting Oracle Net Manager

• Navigating Oracle Net Manager

• Toolbar

• Menus

• Oracle Net Manager Wizards

Starting Oracle Net Manager

You can start Oracle Net Manager using the Oracle Enterprise Manager Console or as an independent application.

To start Oracle Net Manager from the Oracle Enterprise Manager console, on the Oracle Enterprise Manager console, choose Tools > Service Management > Oracle Net Manager.

To start Oracle Net Manager as standalone application:

• On UNIX, run netmgr from $ORACLE_HOME/bin

• On Windows, choose Start > Programs > Oracle - HOME_NAME >Configuration and Migration Tools > Net Manager.

Navigating Oracle Net Manager

The Oracle Net Manager interface includes two panes, a toolbar, and various menu items.

Panes

The Oracle Net Manager interface has two panes: the navigator pane and the right pane.

Navigator Pane

The navigator pane provides a graphical tree view of network objects and the objects they contain, organized in hierarchies of folders. You can use the navigator pane to view, modify, add, or delete objects in each folder.

The navigator pane functions the same way as it does in other Oracle Enterprise Manager applications. That is, the navigator pane lets you:

• Expand and contract folders so that you can navigate to the network object you want to monitor or manage. Examples of objects are connect identifiers, listeners, and profiles.

• Right-click an object to perform operations on the object.

When you expand a folder, you see a nested list of objects and folders. When a object is selected, information about the object is displayed in the right pane of the Oracle Net Manager.

Table 6-1 lists the main folders in the navigator pane.

Right Pane

The right pane contains property sheets that enable you to configure network components. XREF to 5-2 shows the Service Identification property sheet used for connect identifier configuration.

Toolbar

The toolbar contains buttons that correspond to the network objects in the folder hierarchies. The toolbar buttons are enabled depending on the objects viewed or selected in a pane. Move the mouse cursor over a toolbar button to display the description of the button's function. The toolbar buttons are:

Create

This button creates new connect identifiers, listeners objects under the Directory or Local > Service Naming, Listeners folders.

Delete

This button deletes connect identifier and listener objects under the Directory or Local > Service Naming and Listeners folders.

Verify Connectivity

This button verifies the connectivity of a selected connect identifier to an Oracle database service. During a connectivity test, a connection to a database service is made by using connect descriptor information stored in a directory server or a tnsnames.ora file.

Help

The Help button opens the Oracle Net Manager online Help.

Menus

You use Oracle Net Manager menus to perform actions, such as testing connectivity to an Oracle database, and to open wizards and dialog boxes. The following list describes the items available under each menu.

File Menu

Table 6-2 describes the contents of the File menu.

Edit Menu

Table 6-3 describes the contents of the Edit menu.

Command Menu

Table 6-4 describes the contents of the Command menu.

Help Menu

Table 6-5 describes the contents of the Help menu.

Oracle Net Manager Wizards

The Oracle Net Manager wizards provide step-by-step guidance for tasks that require many steps. The wizards simplify complex tasks by guiding you through the task in manageable steps. The wizards are not intended to provide all configuration options. Once you have completed a task with a wizard, use other components of Oracle Net Manager to modify the configuration.

The following topics describe the Oracle Net Manager wizards:

• Net Service Name Wizard

• Directory Server Migration Wizard

Net Service Name Wizard

The Net Service Name Wizard guides you through creating a basic net service name in a directory server or a tnsnames.ora file.

To start the Net Service Name Wizard to create net service names:

1. In the navigator pane, choose Directory or Local > Service Naming.

2. Choose plus (+) from the toolbar, or choose Edit > Create from the menu bar.

Figure 6-1 Opening Page of the Net Service Name Wizard

Description of "Figure 6-1 Opening Page of the Net Service Name Wizard"

Directory Server Migration Wizard

If a tnsnames.ora file already exists, its net service names can be exported to a directory server with the Directory Server Migration Wizard.

To start the Directory Server Migration Wizard, choose Command > Directory > Export Net Service Names in the Oracle Net Manager menu bar.

Figure 6-2 Opening Page of the Directory Server Migration Wizard

Description of "Figure 6-2 Opening Page of the Directory Server Migration Wizard"

Selecting When to Use Oracle Enterprise Manager and Oracle Net Manager

In Oracle Database 10g, much of the functionality previously only available in Oracle Net Manager has been integrated within Oracle Enterprise Manager. Oracle Enterprise Manager provides the ability to manage configuration for multiple Oracle homes across multiple file systems; Oracle Net Manager only enables you to manage configuration for one Oracle home on a local host computer. Table 6-6 describes the key differences between the tools.

Oracle Net Configuration Assistant

Oracle Net Configuration Assistant is provided primarily to configure basic network components during installation, including:

• Listener names and protocol addresses

• Naming methods the client will use to resolve connect identifiers to connect descriptors

• Net service names in a tnsnames.ora file

• Directory server usage

Oracle Net Configuration Assistant runs automatically during software installation, as described in your Oracle installation guide.

It can also be run after installation in standalone mode to configure naming method usage, the listener, net service names in the tnsnames.ora file, and directory server usage in a similar way that is provided during installation.

To start Oracle Net Configuration Assistant:

• On UNIX, run netca from $ORACLE_HOME/bin.

• On Windows, choose Start > Programs > Oracle - HOME_NAME > Configuration and Migration Tools > Net Configuration Assistant.

  See Also:

  Oracle Net Configuration Assistant online help

Figure 6-3 Opening Page of Oracle Net Configuration Assistant

Description of "Figure 6-3 Opening Page of Oracle Net Configuration Assistant"

Table 6-7describes the configuration options in the Welcome page:

Listener Control Utility

The Listener Control utility enables you to administer the listener. The basic syntax for this utility is as follows:

LSNRCTL command [listener_name] 

For example, the following command starts a listener named lsnr:

LSNRCTL START lsnr

You can also issue Listener Control utility commands at the LSNRCTL> program prompt. To obtain the prompt, enter lsnrctl with no arguments at the operating system command line. When you run lsnrctl, the program is started. You can then enter the necessary commands from the program prompt.

For example:

lsnrctl
LSNRCTL> START lsnr

Oracle Connection Manager Control Utility

The Oracle Connection Manager Control utility enables you to administer an Oracle Connection Manager. When you issue commands from the operating system, the basic syntax for this utility is as follows:

cmctl {command} [argument1. . . argumentN]instance_name} {-ppassword}

For example, the following command starts both the CMGW and the CMADMIN processes:

cmctl STARTUP -c cman1 -p my_credentials

You can also issue Oracle Connection Manager utility commands at the CMCTL> program prompt. To obtain the prompt, enter cmctl with no arguments at the operating system command line. When you run cmctl, the program is opened. You can then enter the necessary commands from the program prompt.

For example:

cmctl
CMCTL> STARTUP