TNS-12564: TNS:connection refused

Categories >> ERRORS >> Database Errors >> Oracle Errors
Suggest New Category

Question Posted / guest

6 Answers
34037 Views
Oracle, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

TNS-12564: TNS:connection refused..

Answer / guest

Cause: The connect request was denied by the remote user (or
TNS software).

Action: Not normally visible to the user. For further
details, turn on tracing and reexecute the operation.

Please add more information about this Error

Is This Answer Correct ?

10 Yes

4 No

TNS-12564: TNS:connection refused..

Answer / krish

tnsname .ora file is not configured properly. it a listner
problem, we can resolve this by starting up the listener
manually

Is This Answer Correct ?

12 Yes

7 No

TNS-12564: TNS:connection refused..

Answer / mike fernacz

Check the MTU size of the ethernet ports are not set to
9126. Once I changed my MTU size back to 1500 on Solaris
server. The sqlplus to remote database did not hang anymore.

Is This Answer Correct ?

1 Yes

0 No

TNS-12564: TNS:connection refused..

Answer / uma bala

This error can come if the DB connection given is incorrect

Is This Answer Correct ?

1 Yes

2 No

TNS-12564: TNS:connection refused..

Answer / rajaram

if you are trying to connect data base. if it went down at
the time . this case also you get this error.

Is This Answer Correct ?

5 Yes

8 No

TNS-12564: TNS:connection refused..

Answer / swetha

tns.ora is not configure.its a listener problem .we should
give an entry in listener.ora on which database
(service),protocol so it showin an error

Is This Answer Correct ?

2 Yes

5 No

Post New Answer