Database Administration (MOSC)

MOSC Banner

Problem start RAC database 12.2. from spfile on ASM

edited Oct 21, 2018 5:46PM in Database Administration (MOSC) 6 commentsAnswered ✓

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:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center