ORACLE-基础十七(Oracle Net Server Dide Configuration)

The Listener Process

The Listener Process

ConnectionMethods

When a connection  request is made by a client to a server, the listener performs one of the following:

 1.Spawns a server process and bequeaths(passes)the connection to it

 2. Hands off the connectin to a dispatcher in an oracle Shared Server configuration

 3. Redirects the connection to a dispatcher or server process.

Spawn and Bequeath Conn.

Direct Hand-Off Connections

Redirection Session

Service  Config & Register

The listener can ben configured in two sway:

  1.Dynamic service registration

    Does not require configuration in listener.ora file

    The listener relies on the PMON process

  2.Static service configuration

   a.Used for Oracle8 and earlier releases

   b.Requires listener.ora configuration

   c.Required for Oracle Enterprise Manger and other services

Static Registration

 Default settings for the listener.ora file with Oracle software installation:

1. Listener name LISTENER

2.Port 1521

3. Prtocols TCP/IP and IPC

4. SID name Default instance

5 Host name Default host name

listener.ora

Dynamic Registration

Dynamic service registration is configured in the database initailization file , It does nt require any configuration in the listener.ora file. However , listener configuration must be synchronized with the information in the database initailization file.

The listener uses the dynamic service information about the database and instance it has received through service registration before using statically configured information in the listener.ora file.

Static configuration is also required for other services, such as extenal procedures,

To ensure that service registrantion is functional , the following initailization parameters must be configured:

1.SERVICE_NAMES

2.INSTANCE_NAME

The value for the SERVICE_NAMES PARAMETER defaults to the global database name, a name comprising the DB_NAME and DB_DOMAIN parameters int the initialization parameter file, entered during installatin r database creation, The value for the INSTANCE_NAME parameter defaults to the SID entered durin installation r database creation.

LSNRCTL里使用的命令：

start service_name

stop service_name

set trc_level admin

show trc_directory