关于dispatchers 各版本对比，及Re…

dispatchers    

<本文转自http://www.orafaq.com/parms/parm508.htm>

---

    Oracle 11.1.0:Parameter Name:dispatchersDescription:specifications of dispatchersType:CHARObsoleted:FALSECan ALTER SESSION:FALSECan ALTER SYSTEM:IMMEDIATE

Oracle 10.2.0:

Parameter Name:dispatchersDescription:specifications of dispatchersType:CHARObsoleted:FALSECan ALTER SESSION:FALSECan ALTER SYSTEM:IMMEDIATE

Oracle 10.1.0:

Parameter Name:dispatchersDescription:specifications of dispatchersType:CHARObsoleted:FALSECan ALTER SESSION:FALSECan ALTER SYSTEM:IMMEDIATE

Oracle 9.2.0:

Parameter Name:dispatchersDescription:specifications of dispatchersType:CHARObsoleted:FALSECan ALTER SESSION:FALSECan ALTER SYSTEM:IMMEDIATE

Oracle 8.1.7:

Nosuch parmeter in Oracle 8.1.7.

Oracle 8.0.6:

Nosuch parmeter in Oracle 8.0.6.

Oracle 7.3.4:

Nosuch parmeter in Oracle 7.3.4.

---

Related Error Messages:

ORA-00101:invalid specification for system parameter DISPATCHERS

Cause: The syntax for theDISPATCHERS parameter is incorrect.

Action: Refer to the manualfor correct syntax.

ORA-00102: network protocol %s cannot be used bydispatchers

Cause: The network specifiedin DISPATCHERS does not have the functionality required by thedispatchers.

Action: Refer to the manualon network protocols supported by the dispatchers.

ORA-00113: protocol name %s is too long

Cause: A protocol namespecified in the DISPATCHERS system parameter is too long.

Action: Use a validprotocol name for the DISPATCHERS value.

ORA-00134: invalid DISPATCHERS specification #%s

Cause: The syntax for the n-thDISPATCHERS specification was incorrect.

Action: Refer to the OracleReference Manual for the correct syntax.

ORA-02066: missing or invalid DISPATCHERS text

Cause: A character stringliteral was expected, but not found, following ALTER SYSTEM SETDISPATCHERS

Action: place the stringliteral containing the dispatcher's specification after ALTERSYSTEM SET DISPATCHERS

ORA-12509: TNS:listener failed to redirect client to servicehandler

Cause: The dispatcherterminated unexpectedly

Action: Attempt to connectagain and if the same error occurs,contact the DBA to check thestate of the dispatchers for this SID.If the problem persists, turnon tracing in the listener to determinethe TNS error caused by theredirect.

ORA-12510: TNS:database temporarily lacks resources to handlethe request

Cause: The dispatchers appearto be busy handling other requests.

Action: Attempt theconnection again. If error persists, askthe DBA to increase thenumber of dispatchers and/or dispatchers' limit on number ofconnections/sessions that they can accept.

ORA-12511: TNS:service handler found but it is not acceptingconnections

Cause: The dispatchersnotified the listener that they temporarily do not accept newconnections.

Action: Attempt theconnection again. If error persists, contact the DBAto check thestate of the dispatchers and/or ask him to increase the numberofdispatchers.

ORA-12513: TNS:service handler found but it has registered for adifferent protocol

Cause: The dispatchersregistered for this service are connected tothe listener by way ofa different network protocol than that of the client.

Action: Contact the DBA toregister a dispatcher on your protocol.

ORA-32021: parameter value longer than %s characters

Cause: An attempt was made toalter a parameter value but the number of characters in theparameter value was longer than the allowed maximum. For a listparameter, one of the values in the list was longer than theallowed maximum.

Action: Reduce theparameter value length and retry the command. For the DISPATCHERSparameter, use listener aliases to reduce value length.

ORA-32022: parameter value longer than %s characters

Cause: An attempt was made toalter a parameter value but the combined length of all theparameter values was more than the allowed maximum.

Action: Reduce theparameter value length and retry the command. For the DISPATCHERSparameter, use listener aliases to reduce value length.

---

This parameter is documented inthe OracleServer Reference Guide. Search for more info about [dispatchers ]on the Oracle FAQ.