Shulou(Shulou.com)06/01 Report--

System environment: Windows server 2008 R2

Database version: oracle 11.2.0.1 RAC

When checking the database for the customer, it was found that the 128G memory configured by the customer's system had a low utilization rate, so I wanted to increase the memory, so I set a few parameters.

SQL > alter system set memory_max_target=83200Mscope=spfile

SQL > alter system set memory_ target=76800Mscope=spfile

SQL > alter system set sga_target=70400Mscope=spfile

SQL > alter system set pga_aggregate_target=12800Mscope=spfile

After the configuration is completed, the database restart startup fails to start. The error is as follows:

ORA-00838: Specified value of MEMORY_TARGETis too small, needs to be 83200M .

According to the error message, the MEMORY_TARGET setting is small, and because SGA,PGA is set, it means that it is the lowest allocation value, PGA+SGA > MEMORY TARGET, so it indicates that the memory is insufficient.

Because the database is closed, the pfile file can only be changed. At this point, look at the pfile file, find that there is nothing, re-create a pfile file.

SQL > Create pfile='d:/app/oracle/product/initorcl2.ora'from spfile='+data/orcl/spfile.ora'

Modify the initorcl2.ora file, set pga and sga to 0, and then

Startup pfile=' dvl LigUp appAGUP oracleAccord productUniverse initorcl2.ora'.ora'

At this point, the database starts. Then create the spfile file.

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.