Saturday, February 16, 2013

ORA-00124 DISPATCHERS Specified without MAX_SHARED_SERVERS

Error Code
ORA-00124

Description
DISPATCHERS specified without MAX_SHARED_SERVERS.

Cause
Possible cause of this error is, a definition for DISPATCHERS was specified in the initialization parameter file, but MAX_SHARED_SERVERS was specified as zero.

Action
To fix this error, specify MAX_SHARED_SERVERS to be greater than zero.

reference

ORA-00123 Idle Public Server Terminating

Error Code
ORA-00123

Description
Idle public server terminating.

Cause
Possible cause of this error is, too many idle servers were waiting on the common queue.

Action
This error is used internally, no action is required.

reference

ORA-00122 Cannot Initialize Network Configuration

Error Code
ORA-00122

Description
Cannot initialize network configuration.

Cause
Possible cause of this error is, ORACLE could not initialize SQL*Net version 2.


Action
To fix this error, check the error stack for detailed information.

reference

ORA-00121 SHARED_SERVERS Specified without DISPATCHERS

Error Code
ORA-00121

Description
SHARED_SERVERS specified without DISPATCHERS.

Cause
Possible cause of this error is, 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.

Action
To fix this error, add a definition for DISPATCHERS in the initialization parameter file (or remove the definition for SHARED_SERVERS, if shared servers are not being used).

reference

Wednesday, February 13, 2013

ORA-00120 Dispatching Mechanism not Enabled or Installed

Error Code
ORA-00120

Description
Dispatching mechanism not enabled or installed.

Cause
Possible cause of this error is, either the dispatching mechanism was not enabled or the Oracle executable image was not installed with the dispatching mechanism.

Action
To fix this error, refer to the >Oracle9i Database Administrator's Guide and your operating system-specific documentation for procedures for starting and configuring the dispatcher process.

reference