Interested to Buy Any Domain ? << Click Here >> for more details...
TNS-12170: TNS:Connect timeout occurred
- 2 Answers
- 6123 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
ORA-14046: a partition may be split into exactly two new partitions
ORA-24340: cannot support more than 255 columns
ORA-03236: max # extents (string) reached in index string.string subpartition string
TNS-01026: Start Date string
LSX-00145: attribute "~1S" invalid derived value "~2S"
ORA-19321: Could not open HTTP connection to host (string): port (string)
ORA-01409: NOSORT option may not be used; rows are not in ascending order
ORA-28152: proxy user 'string' may not specify initial role 'string' on behalf of client 'string'
DGM-16917: Unable to shut down instance "string".
ORA-23619: non-Oracle system error: string
QSM-01127: query rewritten with multiple MVs
TNS-01400: Instance "string" has number handlers.
Oracle Errors 
