ORA-12519: TNS:no appropriate service handler found Cause: 監聽器認為連接數達上限,將服務狀態設為 BLOCKED,拒絕新連線。
SELECT COUNT(*) FROM V$PROCESS;
SELECT VALUE FROM V$PARAMETER WHERE NAME = 'processes';
ALTER SYSTEM SET PROCESSES = 300 SCOPE = SPFILE;
SHUTDOWN IMMEDIATE; STARTUP;
PMON 透過 SERVICE_UPDATE 定期向監聽器報告連接數,有時間間隔,故 LSNRCTL SERVICES 顯示的連接數可能略低於實際值。
SELECT MAX(UTILIZATION) FROM V$RESOURCE_LIMIT WHERE RESOURCE_NAME = 'processes';
SELECT OSUSER, USERNAME,
CPU_TIME/EXECUTIONS/1000000 || 's' AS CPU_PER_EXEC,
SQL_FULLTEXT, MACHINE
FROM V$SESSION S, V$SQLAREA Q
WHERE S.SQL_ADDRESS = Q.ADDRESS
ORDER BY CPU_TIME/EXECUTIONS DESC;