Improper memory allocation of oracle11g, resulting in error ora-01034,ora-00838,ora-27101

Due to the development needs, oracle11g is applied to the virtual machine, so the system resources seem to be valuable, Baidu has a bit of answers.

With DBA access to Oracle, the author manages the database in Plsql:

Show parameter SGA; --Display of memory allocations

Alter system set sga_max_size=200m Scope=spfile; --Modify the size of the occupied memory

Note: Use the above command in the editor mode in the command window in PL/SQL

Go

and a memory_target.

alter system set memory_target=100m;

It is precisely because of this sentence that Oracle failed to function properly.

Failure phenomena:

Connect the Oralce, prompting the service to not listen.

ora-01034,ora-00838 and ORA-27101 errors occurred in starting the database.

While Windows service is normal, oracleoradb11g_home1tnslistener,oracleservicexxx.

Microsoft Windows [version6.1.7601] Copyright (c) theMicrosoft Corporation. All rights reserved. C:\Users\Administrator>sqlplus/Nologsql*plus:release11.2.0.1.0Production on Friday June - Ten: *: -  .Copyright (c)1982, ., Oracle. All rights reserved. SQL> Conn/ asthe SYSDBA is connected to the idle routine. SQL>Show Parameters Targetora-01034: ORACLE Not available process ID:0Session ID:0Serial number:0SQL>Startupora-00838: Specified Value of Memory_target isToo small, needs to BES at least 148M

After groping, the solution is as follows

Microsoft Windows [version 6.1.7601] Copyright (c) Microsoft Corporation. All rights reserved. C:\users\administrator>sqlplus/nologsql*plus:release 11.2.0.1.0 Production on Fri June 10:35:33 2017Copyright (c) 19 The Oracle.  All rights reserved. Sql> create SPFile from pfile= ' C:\oracle\admin\xxx\pfile\init.ora.9312016162455 '; The sql> startuporacle routine has been started. Total System Global area  208769024 bytesfixed size                  2174320 bytesvariable size             146801296 bytesdatabase Buffers           54525952 bytesredo buffers                5267456 bytes database loaded. The database is already open. Sql>

is estimated to be a spfile file configuration problem, and this file is binary, we use Pfile file to generate SPFile file.

Remember to open it first

C:\oracle\admin\xxx\pfile\init.ora.9312016162455
This file, find Memory_target modified to 209209200, i.e. 200m

Improper memory allocation of oracle11g, resulting in error ora-01034,ora-00838,ora-27101