Category Archives: TNS Database Error Messages

TNS-12541: TNS:no listener

oracle

TNS-12541: TNS:no listener
Cause: The connection request could not be completed because the listener is not running.
Action: Ensure that the supplied destination address matches one of the addresses used by the listener. Compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to go by way of an Interchange). Start the listener on the remote machine.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-12540: TNS:internal limit restriction exceeded

oracle

TNS-12540: TNS:internal limit restriction exceeded
Cause: Too many TNS connections open simultaneously.
Action: Wait for connections to close and retry.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-12539: TNS:buffer over- or under-flow

oracle

TNS-12539: TNS:buffer over- or under-flow
Cause: Buffer too small for incoming data or too large for outgoing data.
Action: This restriction (which is associated with CONNECT DATA) is not normally visible to the user. For further details, turn on tracing and re-execute the operation; contact Oracle Support Services.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-12538: TNS:no such protocol adapter

oracle

TNS-12538: TNS:no such protocol adapter
Cause: The protocol adapter requested (by way of the "(PROTOCOL=..)" keyword-value pair in a TNS address) is unknown. If the supplied address is typographically correct then the protocol adaptor is not installed.
Action: Install the protocol adapter or correct the typographical error, as appropriate. Note: if the supplied address was derived from resolving the service name, check the address in the appropriate file (TNSNAMES.ORA, LISTENER.ORA or TNSNET.ORA).

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-12537: TNS:connection closed

oracle

TNS-12537: TNS:connection closed
Cause: "End of file" condition has been reached; partner has disconnected. This is an informational message.
Action: No action required.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-12536: TNS:operation would block

oracle

TNS-12536: TNS:operation would block
Cause: An internal operation did not commence because to do so would block the current process and the user has requested that operations be non-blocking. This is an informational message.
Action: No action required.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-12535: TNS:operation timed out

oracle

TNS-12535: TNS:operation timed out
Cause: The requested connection could not be completed within the timeout period specified by the CONNECT_TIMEOUT parameter in LISTENER.ORA. This error arises from the TNSLSNR.
Action: Either reconfigure CONNECT_TIMEOUT to be 0, which means wait indefinitely, or reconfigure CONNECT_TIMEOUT to be some higher value. Or, if the timeout is unacceptably long, turn on tracing for further information.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-12534: TNS:operation not supported

oracle

TNS-12534: TNS:operation not supported
Cause: An internal function received a request to perform an operation that is not supported (on this machine). This message is not normally visible to the user.
Action: For further details, turn on tracing and re-execute the operation. If the error persists, contact Oracle Support Services.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-12533: TNS:illegal ADDRESS parameters

oracle

TNS-12533: TNS:illegal ADDRESS parameters
Cause: An illegal set of protocol adapter parameters was specified. In some cases, this error is returned when a connection cannot be made to the protocol transport.
Action: Verify that the destination can be reached using the specified protocol. Check the parameters within the ADDRESS section of TNSNAMES.ORA. Legal ADDRESS parameter formats may be found in the Oracle operating system-specific documentation for your platform. Protocols that resolve names at the transport layer (such as DECnet object names) are vulnerable to this error if not properly configured or names are misspelled.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-12532: TNS:invalid argument

oracle

TNS-12532: TNS:invalid argument
Cause: An internal function received an invalid parameter. This message is not normally visible to the user.
 Action: For further details, turn on tracing and re-execute the operation. If the error persists, contact Oracle Support Services.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/