TNS-12170: TNS:Connect timeout occurred

Answers were Sorted based on User's Feedback



TNS-12170: TNS:Connect timeout occurred..

Answer / raya tharaka ram

ORA-12170: TNS:Connect timeout occurred
Cause: The server shut down because connection
establishment or communication with a client failed to
complete within the allotted time interval. This may be a
result of network or 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 or
system, reconfigure one or all of the parameters
SQLNET.INBOUND_CONNECT_TIMEOUT, SQLNET.SEND_TIMEOUT,
SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values. If a
malicious client is suspected, 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 (e.g. in TCP/IP).

Is This Answer Correct ?    1 Yes 0 No

TNS-12170: TNS:Connect timeout occurred..

Answer / guest

Cause: The server shut down because connection establishment
or communication with a client failed to complete within the
allotted time interval. This may be a result of network or
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 or
system, reconfigure one or all of the parameters
SQLNET.INBOUND_CONNECT_TIMEOUT, SQLNET.SEND_TIMEOUT,
SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values. If a
malicious client is suspected, 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 (e.g. in
TCP/IP).

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

LPX-00304: input parameter to function is null

1 Answers  


NNL-00911: Responses sent with invalid error code: number

1 Answers  


LSX-00262: attribute "~1S" cannot have complex type "~2S"

1 Answers  


KUP-11001: files not from the same unload operation

1 Answers  


QSM-00765: cannot validate user-defined workload because table string.string is invalid.

1 Answers  






ORA-25526: bad format of _DB_MTTR_SIM_TARGET: string

1 Answers  


PCC-02335: body of cursor must name statement identifier

1 Answers  


ORA-01285: error reading file string

1 Answers  


ORA-24058: cannot downgrade QUEUE_TABLE that has propagation in a prepared state

1 Answers  


ORA-07680: sou2os: another call to ORACLE currently executing

1 Answers  


ORA-26062: Can not continue from previous errors.

1 Answers  


ORA-13498: %s

1 Answers  


Categories