show parameter processes; 然后 更改系統(tǒng)連接數(shù) alter system set processes=1000 scope=spfile; 下面是具體的操作步驟與說明 問題描述:客戶端連接數(shù)據(jù)庫報錯 ORA-12516: TNS: 監(jiān)聽程序無法找到匹配協(xié)議棧的可用句柄 解決過程: 1。查看當前會話數(shù)、processes和sessions值,發(fā)現(xiàn)session數(shù)和2個參數(shù)的值已經非常逼近 SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 10月 9 15:50:21 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> conn / as sysdba 已連接。 SQL> select count(*) from v$session; COUNT(*) ---------- 45
SQL> show parameter processes NAME TYPE VALUE ------------------------------------ ----------- ---------------------- aq_tm_processes integer 0 db_writer_processes integer 1 gcs_server_processes integer 0 job_queue_processes integer 10 log_archive_max_processes integer 2 processes integer 50 SQL> show parameter sessions NAME TYPE VALUE ------------------------------------ ----------- ---------------------- java_max_sessionspace_size integer 0 java_soft_sessionspace_limit integer 0 license_max_sessions integer 0 license_sessions_warning integer 0 logmnr_max_persistent_sessions integer 1 sessions integer 60 shared_server_sessions integer
2。修改processes和sessions值 SQL> alter system set processes=300 scope=spfile; 系統(tǒng)已更改。 SQL> alter system set sessions=300 scope=spfile; 系統(tǒng)已更改。
3。查看processes和sessions參數(shù),但更改并未生效 SQL> show parameter processes NAME TYPE VALUE ------------------------------------ ----------- ---------------------- aq_tm_processes integer 0 db_writer_processes integer 1 gcs_server_processes integer 0 job_queue_processes integer 10 log_archive_max_processes integer 2 processes integer 50 SQL> show parameter sessions NAME TYPE VALUE ------------------------------------ ----------- ---------------------- java_max_sessionspace_size integer 0 java_soft_sessionspace_limit integer 0 license_max_sessions integer 0 license_sessions_warning integer 0 logmnr_max_persistent_sessions integer 1 sessions integer 60 shared_server_sessions integer
4。重啟數(shù)據(jù)庫,使更改生效 SQL> shutdown immediate
SQL> startup
SQL> show parameter processes NAME TYPE VALUE ------------------------------------ ----------- ---------------------- aq_tm_processes integer 0 db_writer_processes integer 1 gcs_server_processes integer 0 job_queue_processes integer 10 log_archive_max_processes integer 2 processes integer 300 SQL> show parameter sessions NAME TYPE VALUE ------------------------------------ ----------- ---------------------- java_max_sessionspace_size integer 0 java_soft_sessionspace_limit integer 0 license_max_sessions integer 0 license_sessions_warning integer 0 logmnr_max_persistent_sessions integer 1 sessions integer 335 shared_server_sessions integer 最后測試加大連接數(shù)到50,100都沒報ORA-12516錯誤。