|
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 |