SERVICE specifies service names & dispatchers register with listeners - Managing Oracle Database Processes

Q.  What specifies the service names and the dispatchers register with the listeners in  the DISPATCHERS Initialization Parameter Attributes ?
- Published on 03 Aug 15

a. LISTENER
b. SERVICE
c. CONNECTIONS
d. MULTIPLEX

ANSWER: SERVICE
 

    Discussion

  • Nirja Shah   -Posted on 23 Sep 15
    - SERVICE (SER or SERV) - Specify the service names the dispatchers register with the listeners.
    - If no values are specified, then service names specified with the SERVICE_NAMES initialization parameter are used.

    - CONNECTIONS (CON or CONN) - Specify the maximum number of network connections to allow for each dispatcher.
    - The default is operating system specific.
    - For example, 1024 is the default for Solaris Operating System and Windows NT.

    - LISTENER (LIS or LIST) - Specify an alias name for the listeners with which the PMON process registers dispatcher information.
    - Set the alias to a name which is resolved through a naming method.
    - The LISTENER attribute overrides the LOCAL_LISTENER and REMOTE_LISTENER initialization parameters.
    - The LISTENER attribute only needs to be specified if its value is different from the values specified by the LOCAL_LISTENER and REMOTE_LISTENER parameters.
    - Note that the LOCAL_LISTENER parameter has a default value of TCP/IP, port 1521.

    - MULTIPLEX (MUL or MULT) - Use to enable the Oracle Connection Manager session multiplexing feature.
    - If 1, ON, YES, TRUE, or BOTH is specified, then session multiplexing is enabled for both incoming and outgoing network sessions.
    - If IN is specified, then session multiplexing is enabled for incoming network sessions from clients.
    - If OUT is specified, then session multiplexing is enabled for outgoing network sessions.
    - If 0, NO, OFF, or FALSE is specified, then session multiplexing is disabled for both incoming and outgoing network connections.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)