Modify MEMORY_TARGET in Oracle

1. Oracle cannot be started because of reduced memory
 
Last login: Sun Nov 4 15:09:06 2012 from 192.168.5.222
[Oracle @ h1 ~] $ Sqlplus "/as SYSDBA"
 
SQL * Plus: Release 11.2.0.1.0 Production on Sun Nov 4 15:26:59 2012
 
Copyright (c) 1982,200 9, Oracle. All rights reserved.
 
Connected to an idle instance.
 
SQL> startup pfile =/app/oracle/admin/orcl/pfile/init. ora.103201271612
ORA-00845: MEMORY_TARGET not supported on this system
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup pfile =/app/oracle/admin/orcl/pfile/init. ora.103201271612 force
ORA-00845: MEMORY_TARGET not supported on this system
SQL> exit
Disconnected
 
# --------- Solution: extended memory
 
# -------- Pfile location: $ ORACLE_BASE/admin/[$ ORACLE_SID]/pfile/init. ora .*
 

2. Start by pfile after memory expansion, but sfile cannot be modified
 
SQL * Plus: Release 11.2.0.1.0 Production on Sun Nov 4 16:00:25 2012
 
Copyright (c) 1982,200 9, Oracle. All rights reserved.
 
Connected to an idle instance.
 
SQL> startup pfile =/app/oracle/admin/orcl/pfile/init. ora.103201271612 force
ORACLE instance started.
 
# ---------- Start by ORACLE PFILE
 
Total System Global Area 1219260416 bytes
Fixed Size 2212856 bytes
Variable Size 738200584 bytes
Database Buffers 469762048 bytes
Redo Buffers 9084928 bytes
Database mounted.
Database opened.
SQL> alter system set memory_max_target = 1258200 M scope = both;
Alter system set memory_max_target = 1258200 M scope = both
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
 

SQL> alter system set memory_max_target = 1258200 M scope = spfile;
Alter system set memory_max_target = 1258200 M scope = spfile
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE is in use // The spfile file may not exist
 
# -------------/App/oracle/product/11.2.0/dbhome_2/dbs/-------------- store spfile

1 2 Next Page