Welcome to the Technical Portal: ORA-00101 to ORA-00125

ORA Code Code Description Cause Action
ORA-00101 Invalid specification for system parameter DISPATCHERS The syntax for the DISPATCHERS parameter is incorrect Refer to the manual for correct syntax
ORA-00102 Network protocol string cannot be used by dispatchers The network specified in DISPATCHERS does not have the functionality required by the dispatchers Refer to the manual on network protocols supported by the dispatchers
ORA-00103 Invalid network protocol; reserved for use by dispatchers An attempt was made to dump a variable by name on a system that does not support this feature Specify other network protocols in the connection string
ORA-00104 Deadlock detected; all public servers blocked waiting for resources 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 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-00105 Too many dispatcher configurations Too many dispatcher configurations have been specified. No more can be added Consolidate the dispatcher configurations if possible
ORA-00106 Cannot startup/shutdown database when connected to a dispatcher An attempt was made to startup/shutdown database when connected to a shared server via a dispatcher Re-connect as user INTERNAL without going through the dispatcher. For most cases, this can be done by connect to INTERNAL without specifying a network connect string
ORA-00107 Failed to connect to ORACLE listener process Most likely due to the fact that ORACLE listener has not been started Start ORACLE listener if it has not been started. Or else contact your ORACLE representative
ORA-00108 Failed to set up dispatcher to accept connection asynchronously Most likely due to the fact that the network protocol used by the the dispatcher does not support asynchronous operations Contact your ORACLE representative
ORA-00109 Invalid value for attribute string: string The value specified for the attribute was incorrect Refer to the manual for the proper values
ORA-00110 Invalid value string for attribute string, must be between string and string The value specified for the attribute was incorrect Specify a value within the range allowed
ORA-00111 Invalid attribute string The specified attribute was not recognized Refer to the manual for the proper keyword to use to specify a dispatcher attribute
ORA-00112 Value of string is null The attribute was specified with no value Specify a non-null value
ORA-00113 Protocol name string is too long A protocol name specified in the DISPATCHERS system parameter is too long Use a valid protocol name for the DISPATCHERS value
ORA-00114 Missing value for system parameter SERVICE_NAMES No value was specified for the SERVICE_NAMES system parameter, nor for the DB_NAME parameter Add an SERVICE_NAMES or DB_NAME definition to the INIT.ORA file. By default, SERVICE_NAMES is the value of DB_NAME unless SERVICE_NAMES is explicitly specified
ORA-00115 Connection refused; dispatcher connection table is full A connection request was refused by a dispatcher because the dispatcher cannot support any more connections Connect to a different dispatcher, or use a dedicated server
ORA-00116 SERVICE_NAMES name is too long A service name specified in the SERVICE_NAMES system parameter is too long Use a shorter name in the SERVICE_NAMES value (<= 255 chars)
ORA-00117 PROTOCOL, ADDRESS or DESCRIPTION must be specified PROTOCOL, ADDRESS or DESCRIPTION was not specified Use one of the attributes: PROTOCOL, ADDRESS or DESCRIPTION to specify the listening address for dispatchers
ORA-00118 Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified More than one of PROTOCOL, ADDRESS or DESCRIPTION was specified Use only one of the attributes: PROTOCOL, ADDRESS or DESCRIPTION to specify the listening address for dispatchers
ORA-00119 Invalid specification for system parameter string The syntax for the specified parameter is incorrect Refer to the Oracle Reference Manual for the correct syntax
ORA-00120 Dispatching mechanism not enabled or installed Either the dispatching mechanism was not enabled or the Oracle executable image was not installed with the dispatching mechanism Refer to the Oracle9i Database Administrator's Guide and your operating system-specific documentation for procedures for starting and configuring the dispatcher process
ORA-00121 SHARED_SERVERS specified without DISPATCHERS A definition for SHARED_SERVERS was specified in the initialization parameter file, but no definition for DISPATCHERS was specified. Without a value for DISPATCHERS, shared servers will never be used Add a definition for DISPATCHERS in the initialization parameter file (or remove the definition for SHARED_SERVERS, if shared servers are not being used)
ORA-00122 Cannot initialize network configuration ORACLE could not initialize SQL*Net version 2 Check the error stack for detailed information
ORA-00123 Idle public server terminating Too many idle servers were waiting on the common queue This error is used internally, no action is required
ORA-00124 DISPATCHERS specified without MAX_SHARED_SERVERS A definition for DISPATCHERS was specified in the initialization parameter file, but MAX_SHARED_SERVERS was specified as zero Specify MAX_SHARED_SERVERS to be greater than zero
ORA-00125 Connection refused; invalid presentation The PRESENTATION in the CONNECT_DATA of the TNS address DESCRIPTION is not correct or is not supported Correct the PRESENTATION specified in the TNS address

 

    Back to ORA Code Topics

 

Google