Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

modify spfile values

RobeenMar 12 2017 — edited Mar 22 2017

Oracle Database 12c with ASM

Hello,

I have to modify spfile parameters(db_block_size,db_keep_cahe_size..). I am getting

SQL> alter system set db_block_size=8192 scope=spfile;

alter system set db_block_size=8192 scope=spfile

ERROR at line 1:

ORA-32017: failure in updating SPFILE

ORA-32016: parameter "db_block_size" cannot be updated in SPFILE

The spfile is in +DATA1/NEWCF/PARAMETERFILE

How do I create pfile,modify and recreate spfile and restart?

I am new to ASM

Thanks,

Regards,

Joe

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 19 2017

Added on Mar 12 2017

#automatic-storage-management, #performance-availability

2 comments

2,570 views