Oracle錯誤案例：TNS-00510

TNS-00510 Internal limit restriction exceeded

Cause Too many files or sockets open simultaneously (or some other resource has been depleted).

Action For further details, trace the operation for protocol details.

TNS-12500 TNS:listener failed to start a dedicated server process

Cause The process of starting up a dedicated server process failed. The executable could not be found or the environment may be set up incorrectly.

Action Turn on tracing at the ADMIN level and re-execute the operation. Verify that the Oracle Server executable is present and has execute permissions enabled. Ensure that the Oracle environment is specified correctly in LISTENER.ORA. The Oracle Protocol Adapter that is being called may not be installed on the local hard drive. Check that the correct Protocol Adapter are successfully linked. If the error persists, contact Oracle Customer Support.

TNS-12540 TNS:internal limit restriction exceeded

Cause Too many TNS connections open simultaneously.

Action Wait for connections to close and retry.

TNS-12560 TNS:protocol adapter error

Cause A generic protocol adapter error occurred.

Action Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors.For further details, turn on tracing and re-execute the operation. Turn off tracing when the operation is complete.

問：進程的數量會引起監聽器錯誤嗎？

TNS-12500: TNS:listener failed to start a dedicated server process

TNS-12540: TNS:internal limit restriction exceeded

TNS-12560: TNS:protocol adapter error

TNS-00510: Internal limit restriction exceeded

IBM/AIX RISC System/6000 Error: 11: Resource temporarily unavailable

我們在監聽器日志中發現如上的錯誤信息。服務器上每個用戶的最大進程數量被設置600 Oracle中的最大進程數量為600。進程最大的利用率是482，每個會話的最大利用率是490。會話的數量設置為840。

根據我所了解的，看起來進程的數量是沒有問題的。我們通過在這個機器上無法正確建立內存分頁空間而對此進行了證實，然而，一些人仍然告訴我們要在起始的時候增加進程的數量。我不同意這個觀點。我遺漏了什麼嗎？

答：TNS-510錯誤信息顯示了有太多的文件或者socket同時開放了（或者是其他一些資源耗盡了）。這是操作系統的限制，不是Oracle的限制。你需要確認你的AIX平台可以處理你在服務器上開放的這麼多的文件。這是“全部”文件，並不僅僅是Oracle數據庫文件。並且，你還需要確認你的AIX服務器可以正確處理全部數量的Oracle進程，而不僅僅是專用的服務器進程。Oracle的起始參數PROCESSES限制了專用的服務器進程數量。但是還有後台的進程（SMON, PMON, LGWR等），以及支持並行語句的進程，更不用說你的監聽器等了。我覺得你應該配置AIX來允許每個Unix用戶擁有更多的進程。