TNS-01167: The command string is not supported by the listener contacted
Cause: The listener does not recognize the command.
Action: This is caused when a newer version of LSNRCTL contacts an old listener. Upgrade listener if executing this command is important.
TNS-01159: Internal connection limit has been reached; listener has shut down
Cause: The internal SQL*Net connection list is full. The listener is configured to use too many SQL*Net connections.
Action: Reduce the number of listen addresses or services connected to the listener. For further details, turn on tracing and re-execute the operation. If the error persists, contact Oracle Support Services.
TNS-01158: Internal connection limit reached, preventing dispatcher from connecting
Cause: The internal SQL*Net connection list is full. Too many dispatchers are connected to the listener; therefore, no more dispatchers are allowed to connect.
Action: For further details, turn on tracing and re-execute the operation. If the error persists, contact Oracle Support Services.
TNS-01157: Can only listen on number addresses - ignoring string
Cause: Too many addresses were given to listen on.
Action: Reduce the number of addresses to listen on and use another listener to listen on the remaining addresses.
TNS-01156: Missing or inappropriate PROTOCOL, TIMEOUT or POOL_SIZE parameter from PRESPAWN_DESC
Cause: PRESPAWN_DESC in each SID_DESC does not have required fields.
Action: Be sure the parameters required for PRESPAWN_DESC are specified in each SID_DESC. For example: SID_LIST_LISTENER = (SID_LIST=(SID_DESC=(SID_NAME=sid)(PRESPAWN_ MAX=5)(ORACLE_HOME=oracle_home)(PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_ SIZE=10)(TIMEOUT=30)))) Add or correct these parameters in the LISTENER.ORA file.
TNS-01155: Incorrectly specified SID_LIST_string parameter in LISTENER.ORA
Cause: SID_LIST_listener_name in LISTENER.ORA has an error in it.
Action: Be sure this parameter is specified as described in the Oracle9i Net Services Administrator's Guide. For example: SID_LIST_LISTENER = (SID_LIST=(SID_DESC=(SID_NAME=sid)(ORACLE_ HOME=oracle_home)))
TNS-01154: SID detected in old format that is no longer supported
Cause: One of the SIDs was specified in an obsolete format.
Action: Check LISTENER.ORA for a line of the form: sid = (SID=(ORACLE_HOME=oracle_home)) or sid = (SID_DESC=(ORACLE_HOME=oracle_home)) The above format is no longer supported and SID_LIST_listener_name format described in the Oracle9i Net Services Administrator's Guide should be used. For example: SID_LIST_LISTENER = (SID_LIST=(SID_DESC=(SID_NAME=sid)(ORACLE_ HOME=oracle_home)))
TNS-01152: All addresses specified for the listener name, string, failed
Cause: The listener failed to listen on any of the specified addresses.
Action: Make sure that another application is not listening on the addresses specified or check that the appropriate protocol adapters are installed. Turn on tracing and execute again for more information.
TNS-01151: Missing listener name, string, in LISTENER.ORA
Cause: The listener could not find the listener name specified.
Action: Make sure valid addresses on which to listen are specified for the listener name in LISTENER.ORA.
TNS-01150: The address of the specified listener name is incorrect
Cause: The address on which the listener attempted to listen contains a syntax error.
Action: For the listener name or service name specified to LSNRCTL, check that the address or connect descriptor is well-formed. You can find the listener name in LISTENER.ORA, or you can access the listener through the service name is TNSNAMES.ORA.