0157

The following is a sample listener.ora file:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP) (HOST = eclipse) (PORT = 1521))
      )
    )
  )

Table 4-3 illustrates the contents of the listener.ora file.

In the following, host defines the server name, PORT defines the port number, SERVER defines the host server name, PIPE defines the pipe name, and KEY defines a unique name for the service. It is recommended to use the Oracle SID value for the key.

Table 4-4 defines the components of the protocol definition.

After installation, the Oracle Net Manager can be used to modify the listener configuration. Some of the values that can be configured for the listener include:

If the default port of 1521 is not specified, the LOCAL_LISTENER initialization parameter needs to be defined through a naming method. The LOCAL_LISTENER parameter is dynamic and can be set with the alter system command.

Parameter	Description
DESCRIPTION	Defines a connect descriptor for a net service name.
DESCRIPTION_LIST	Defines a list of connect descriptors.
LISTENER	Defines the listener alias.
ADDRESS	Defines the listener protocol address.
ADDRESS_LIST	Defines a list of protocol addresses that contain common behavior.
TABLE 4-3. Listener.ora File Formats

Team Fly

0157