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

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.