Back to the basics: correct parameter from SPFILE in ASM
When you change the size of memory and forget to update SGA_MAX_SIZE it might happen:
oracle@anjo01:/home/oracle [] srvctl start database -d p05ltm02 PRCR-1079 : Failed to start resource ora.p05ltm02.db CRS-5017: The resource action "ora.p05ltm02.db start" encountered the following error: ORA-01078: failure in processing system parameters ORA-00823: Specified value of sga_target greater than sga_max_size
As this is a clustered database with ASM, here the easiest way to solve:
1. Find the full path of the SPFILE on ASM
oracle@anjo01:/home/oracle [p05ltm02_1] srvctl config database -d p05ltm02 -a Database unique name: p05ltm02 Database name: ltm02 Oracle home: /oracle/app/product/11.2.0.4 Oracle user: oracle Spfile: +DGDATA/p05ltm02/spfileltm02.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: sp_ha01 Database instances: Disk Groups: DGDATA,DGFRA Mount point paths: Services: p05ltm02_app.anjo01 Type: RACOneNode Online relocation timeout: 30 Instance name prefix: p05ltm02 Candidate servers: anjo01,anjo02 Database is enabled Database is policy managed
2. Create a PFILE from SPFILE on the local filesystem
oracle@anjo01:/home/oracle [p05ltm02_1] sqh SQL*Plus: Release 11.2.0.4.0 Production on Tue Feb 2 09:33:47 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> create pfile='/tmp/pfile.txt' from spfile='+DGDATA/p05ltm02/spfileltm02.ora'; File created. SQL> exit Disconnected
3. Correct the damn parameter
oracle@anjo01:/home/oracle [p05ltm02_1] vi /tmp/pfile.txt
4. Recreate the SPFILE on ASM:
oracle@anjo01:/home/oracle [p05ltm02_1] sqh SQL*Plus: Release 11.2.0.4.0 Production on Tue Feb 2 09:34:44 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> create spfile='+DGDATA/p05ltm02/spfileltm02.ora' from pfile='/tmp/pfile.txt'; File created. SQL> exit Disconnected
5. And finally restart the database:
oracle@anjo01:/home/oracle [p05ltm02_1] srvctl start database -d p05ltm02