ORA-00105: too many dispatcher configurations
Cause: Too many dispatcher configurations have been specified. No more can be added.
Action: Consolidate the dispatcher configurations if possible.
All posts by mpbod
ORA-00104: deadlock detected; all public servers blocked waiting for resources
ORA-00104: deadlock detected; all public servers blocked waiting for resources
Cause: All available public servers are servicing requests that require resources locked by a client which is unable to get a public server to release the resources.
Action: Increase the limit for the system parameter MAX_SHARED_SERVERS as the system will automaticaly start up new servers to break the deadlock until the number of servers reaches the value specified in MAX_SHARED_SERVERS.
ORA-00103: invalid network protocol; reserved for use by dispatchers
ORA-00103: invalid network protocol; reserved for use by dispatchers
Cause: The network specified in the SQL*Net connect string is reserved for use by the dispatchers.
Action: Specify other network protocols in the connection string.
ORA-00102: network protocol string cannot be used by dispatchers
ORA-00102: network protocol string cannot be used by dispatchers
Cause: The network specified in DISPATCHERS does not have the functionality required by the dispatchers.
Action: Refer to the manual on network protocols supported by the dispatchers.
ORA-00101: invalid specification for system parameter DISPATCHERS
ORA-00101: invalid specification for system parameter DISPATCHERS
Cause: The syntax for the DISPATCHERS parameter is incorrect.
Action: Refer to the manual for correct syntax.
ORA-00100: no data found
ORA-00100: no data found
Cause: An application made reference to unknown or inaccessible data.
Action: Handle this condition within the application or make appropriate modifications to the application code. NOTE: If the application uses Oracle-mode SQL instead of ANSI-mode SQL, ORA-01403 will be generated instead of ORA-00100.
ORA-00099: timed out while waiting for resource, potential PDML deadlock
ORA-00099: timed out while waiting for resource, potential PDML deadlock
Cause: The resource needed by the transaction was busy. The PDML transaction could not acquire the resource within the specified amount of time. This indicates potential deadlock involving this PDML transaction and other transactions currently running in the system.
Action: Increase the value of the PARALLEL_TRANSACTION_RESOURCE_TIMEOUT parameter; then retry the operation.
ORA-00097: use of Oracle SQL feature not in SQL92 string Level
ORA-00097: use of Oracle SQL feature not in SQL92 string Level
Cause: Usage of Oracle’s SQL extensions.
Action: none
ORA-00096: invalid value string for parameter string, must be from among string
ORA-00096: invalid value string for parameter string, must be from among string
Cause: The value for the initialization parameter is invalid.
Action: Choose a value as indicated by the message.
ORA-00094: %s requires an integer value
ORA-00094: %s requires an integer value
Cause: The parameter value is not an integer.
Action: Modify the parameter value to be an integer.