TNS-12170: TNS:Connect timeout occurred

Cause: The server shut down because connection establishment with a client failed to complete within the allotted time interval. This may be a result of network/system delays; or this may indicate that a malicious client is trying to cause a Denial of Service attack on the server.

Action: If the error occurred because of a slow network/system, then reconfigure the "sqlnet.connect_timeout" parameter in sqlnet.ora to a larger value. If a malicious client is suspected, then use the address in sqlnet.log to identify the source and restrict access. Note that logged addresses may not be reliable as they can be forged (that is, in TCP/IP).

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-12169: TNS:Given net_service_name is too long

Cause: The net_service_name you are attempting to resolve is too long.

Action: The maximum length of the net_service_name is 255 bytes and this limit has been exceeded. Use a smaller alias. If this is not possible, then contact Oracle Support Services.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-12168: TNS:Unable to contact Directory Server 

Cause: Configured to use LDAP based Directory Server.

 Action: Bring the Directory Server up or change configuration to LOCAL. 

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-12166: TNS:Client can not connect to HO agent

Cause: NVstring contained DESCRIPTION/HO.

Action: Call HO agent from integrating server.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-12165: TNS:Trying to write trace file into swap space

Cause: Oracle Trace does not allow writing trace information into your swap space.

Action: Oracle Trace cannot write trace information into swap space so either disable tracing or redirect trace files to be written to another area of your disk.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-12164: TNS:Sqlnet.fdf file not present

Cause: The SQLNET.FDF file does not exist in $ORACLE_HOME/network/admin.

Action: The SQLNET.FDF file is required for Oracle Tracing to occur. Either install the SQLNET.FDF file in $ORACLE_HOME/network/admin or turn off tracing in your ORA file.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-12163: TNS:connect descriptor is too long

Cause: The connect descriptor corresponding to the service name in TNSNAMES.ORA is too long.

Action: The maximum length for a connect descriptor is 512 bytes and this limit has been exceeded. Use a smaller connect descriptor. If this is not possible, contact Oracle Support Services.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-12162: TNS:service name is incorrectly specified

Cause: The connect descriptor corresponding to the service name in TNSNAMES.ORA is incorrectly specified.

Action: Make sure there are no syntax errors in the connect descriptor. Particularly look for unmatched parentheses or stray characters. Any error in a TNSNAMES.ORA file makes it unusable. See the Oracle9i Net Services Administrator's Guide.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-12161: TNS:internal error: partial data received

Cause: The connection may be terminated.

Action: Reconnect and try again. 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-12160: TNS:internal error: Bad error number

Cause: Corrupt error reporting subsystem. 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/