數(shù)據(jù)庫報 ORA-00020錯誤且sys用戶無法正常登錄
數(shù)據(jù)庫內(nèi)連接會話超過參數(shù)配置，導致報錯ORA-00020:maximum number of processes (500) exceeded同時sys用戶無法正常登錄
[oracle@test ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Fri Mar 4 13:05:22 2022
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-00020:maximum number of processes (500) exceeded
Enter user-name:
解決 ORA-00020 錯誤，加大processes的參數(shù)值即可，但是需要sys用戶能夠登錄進行參數(shù)調(diào)整
通過加參數(shù) “-prelim” 強制登陸數(shù)據(jù)庫sqlplus?-prelim?/ as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Mar 4 13:10:09 2022
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL>
此時就可以正常關閉和開啟數(shù)據(jù)庫，進行參數(shù)調(diào)整
標簽：
