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