Problem start RAC database 12.2. from spfile on ASM
Hi guys, please I need help with RAC 12.2c
I did some bad modifications in the parameter PGA_AGGREGATE_LIMIT. I set wrong values.
Then I restarted whole DB via srvctl:
$ srvctl stop database -d PONNYDB
$ srvctl start database -d PONNYDB
I received this error:
ORA-00093: pga_aggregate_limit must be between 4500M and 100000G
Ok, then I created the pfile from the spfile:
SQL> create pfile from spfile='+DATA_GRP/PONNYDB/PARAMETERFILE/spfile.397.989864037' ;
File created.
then I manualy modified values in the pfile.
then I created the spfile from the pfile.
after that I setup the spfile parameter in the DB to new spfile file: