Saturday, February 16, 2013

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

ORA-00119 Invalid Specification for System Parameter String

Error Code
ORA-00119

Description
Invalid specification for system parameter string.

Cause
Possible cause of this error is, the syntax for the specified parameter is incorrect.

Action
To fix this error, refer to the Oracle Reference Manual for the correct syntax.

reference

ORA-00118 Only One of PROTOCOL, ADDRESS or DESCRIPTION may be specified

Error Code
ORA-00118

Description
Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified.

Cause
Possible cause of this error is, more than one of PROTOCOL, ADDRESS or DESCRIPTION was specified.

Action
To fix this error, use only one of the attributes:
PROTOCOL, ADDRESS or DESCRIPTION to specify the listening address for dispatchers.

reference

Tuesday, February 12, 2013

ORA-00117 PROTOCOL, ADDRESS or DESCRIPTION must be specified

Error Code
ORA-00117

Description
PROTOCOL, ADDRESS or DESCRIPTION must be specified.

Cause
Possible cause of this error is, PROTOCOL, ADDRESS or DESCRIPTION was not specified.

Action
To fix this error, use one of the attributes: PROTOCOL, ADDRESS or DESCRIPTION to specify the listening address for dispatchers.


reference