In Oracle, "TNS: Listeners cannot distribute client connections" is displayed.

1. Problem description:

Open sqlplus and log on with the system role

Switch to scott user and switch to sys

D:/> sqlplus sys/admin @ orcl as sysdba

Next, the following error occurs: "TNS: The Listener cannot distribute client connections"

2. Solution Process

Use lsnrctl service to view the listener status

D:/Documents and Settings> lsnrctl service

1. LSNRCTL for 32-bit Windows: Version 10.2.0.1.0-Production on 3-10-2012 20:11:19
3. Copyright (c) 1991,200 5, Oracle. All rights reserved.
5. Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 )))
6. Service summary ..
7. The Service "PLSExtProc" contains one routine.
8. Routine "PLSExtProc", status UNKNOWN, contains one handler of this service...
9. Handler:
10. "DEDICATED" created: 0 rejected: 0
11. LOCAL SERVER
12. The Service "orcl" contains one routine.
13. Routine "orcl", status READY, contains three processing programs of this service...
14. Handler:
15. "DEDICATED" created: 33 rejected: 0 status: ready
16. LOCAL SERVER
17. "D001" created: 0 rejected: 9 current: 0 maximum: 1002 status: ready
18. DISPATCHER <machine: NETPLUS, pid: 3448>
19. (ADDRESS = (PROTOCOL = tcps) (HOST = netplus) (PORT = 1934 ))
20. "D000" created: 1 rejected: 0 current: 1 Maximum: 1002 status: ready
21. DISPATCHER <machine: NETPLUS, pid: 3996>
22. (ADDRESS = (PROTOCOL = tcp) (HOST = netplus) (PORT = 1933 ))
23. The Service "orcl_XPT" contains one routine.
24. Routine "orcl", status READY, contains three processing programs of this service...
25. Handler:
26. "DEDICATED" created: 33 rejected: 0 status: ready
27. LOCAL SERVER
28. "D001" created: 0 rejected: 9 current: 0 maximum: 1002 status: ready
29. DISPATCHER <machine: NETPLUS, pid: 3448>
30. (ADDRESS = (PROTOCOL = tcps) (HOST = netplus) (PORT = 1934 ))
31. "D000" created: 1 rejected: 0 current: 1 Maximum: 1002 status: ready
32. DISPATCHER <machine: NETPLUS, pid: 3996>
33. (ADDRESS = (PROTOCOL = tcp) (HOST = netplus) (PORT = 1933 ))
34. Command executed successfully

The following reason: After the customer connects to the listener, the listener redirects the customer to the scheduling program port (probably not port 1521). Due to operating system problems, these connections will be rejected.

To solve this problem, you only need to use LISTENER. Add this line of DIRECT_HANDOFF_TTC_LISTENER = OFF to the ORA header.

Solution:

Add the following "add content" to listener. ora"

1. # Listener. ora Network Configuration File: E: \ oracle \ product \ 11.2.0 \ dbhome_1 \ network \ admin \ listener. ora
2. # Generated by Oracle configuration tools.
3. DIRECT_HANDOFF_TTC_LISTENER = OFF // added content </SPAN> <SPAN style = "COLOR: #333333">
4. SID_LIST_LISTENER =
5. (SID_LIST =
6. (SID_DESC =
7. (SID_NAME = CLRExtProc)
8. (ORACLE_HOME = E: \ oracle \ product \ 11.2.0 \ dbhome_1)
9. (PROGRAM = extproc)
10. (ENVS = "EXTPROC_DLLS = ONLY: E: \ oracle \ product \ 11.2.0 \ dbhome_1 \ bin \ oraclr11.dll ")
11. )
12. )

Then execute the following command in the command line to restart the listener and EM. If there is still a problem, restart the oracle service.

Lsnrctl stop
Lsnrctl start
Emctl stop dbconsole
Emctl start dbconsole