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

ORA-00097 Use of Oracle SQL feature not in SQL92 string Level

Error Code
ORA-00097
Description
Use of Oracle SQL feature not in SQL92 string Level.

Cause
Possible cause of this error is, usage of Oracle's SQL extensions.

Action
none

reference