Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve the problem of error reporting ORA-00843 ORA-00849 in Oracle ASM". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "how to solve the problem of error reporting ORA-00843 ORA-00849 in Oracle ASM"!

Error description

ORA-00843: Parameter not taking MEMORY_MAX_TARGET into accountORA-00849: SGA_TARGET 4194304 cannot be set to more than MEMORY_MAX_TARGET 0.

Cause of error

When the two parameters of memory_max_targetmemory_target are off, it cannot be explicitly specified as 0 and 0 at the same time. The above error will occur during startup, resulting in ASM startup failure, resulting in CRS startup failure SQL > alter system set sga_target=700M scope=spfile;System altered.SQL > alter system set sga_max_size=800M scope=spfile;System altered.SQL > alter system set pga_aggregate_target=200M scope=spfile;SQL > alter system set memory_target=0 scope=spfile sid='*';System altered.SQL > alter system set memory_max_target=0 scope=spfile sid='*'. System altered. SQL > alter system reset memory_max_target scope=spfile sid='*';System altered.

Solve when ASM cannot be started due to the above error

/ * exclusive mode starts crs/* 11.2.0.The crsctl start crs-excl / * after 11.2.0.2 # crsctl start crs-excl-nocrs/* manually write asm pfile, specify pfile to start asm instance $sqlplus / as sysasmSQL > startup pfile='/tmp/asm.pfile';/* manually modify pfile, create spfileSQL > create spfile='+OCRDG' from pfile='';/* start test $sqlplus / as sysasmSQL > shutdown immediate;SQL > startup / * close the ASM instance and start the cluster # crsctl stop crs-f # crsctl start crs. I believe you have a better understanding of "how to solve the problem of ORA-00843 ORA-00849 reporting errors in Oracle ASM". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.