Oracle 12C 啟動(dòng)數(shù)據(jù)庫報(bào)錯(cuò)ORA-01078、ORA-00093
Oracle 12.2啟動(dòng)數(shù)據(jù)庫報(bào)錯(cuò):
SQL> startupORA-01078: failure in processing system parameters
ORA-00093: pga_aggregate_limit must be between 2048M and 100000G
從12.2開始,pga_aggregate_limit默認(rèn)不低于2G,否則啟動(dòng)會(huì)報(bào)錯(cuò),修改參數(shù)即可。
SQL> alter system set pga_aggregate_limit = 2G;

標(biāo)簽: