Solved : ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 6256M
Keep parameter file backup of database, which will be found in $ORACLE_HOME/dbs/init[SID].ora
These step will increase the automatically increase sga_max_size
SQL> select name from v$database;
NAME
---------
ORCL
SQL> create pfile from spfile;
File created.
SQL> show parameter memory
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 0
memory_target big integer 0
shared_memory_address integer 0
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 4688M
sga_target big integer 4688M
SQL> alter system set memory_target=6G scope=spfile sid='*';
System altered.
SQL> shutdow
ORA-01013: user requested cancel of current operation
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 6256M
SQL> alter system set memory_target=6256M scope=spfile sid='*';
alter system set memory_target=6256M scope=spfile sid='*'
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 223 Serial number: 9
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup pfile='/DATAB/home/oracle/app/oracle/product/11.2.0/dbhome/dbs/initorcl.ora'
ORACLE instance started.
Total System Global Area 4893769728 bytes
Fixed Size 2254696 bytes
Variable Size 989857944 bytes
Database Buffers 3892314112 bytes
Redo Buffers 9342976 bytes
Database mounted.
Database opened.
SQL> show parameter memory
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 0
memory_target big integer 0
shared_memory_address integer 0
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 4688M
sga_target big integer 4688M
SQL> create spfile from pfile;
File created.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 4893769728 bytes
Fixed Size 2254696 bytes
Variable Size 989857944 bytes
Database Buffers 3892314112 bytes
Redo Buffers 9342976 bytes
Database mounted.
Database opened.
SQL> alter system set memory_target=6256M scope=spfile sid='*';
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 6530596864 bytes
Fixed Size 2258632 bytes
Variable Size 2634025272 bytes
Database Buffers 3875536896 bytes
Redo Buffers 18776064 bytes
Database mounted.
Database opened.
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 6256M
sga_target big integer 4688M
SQL> show parameter memory_target
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_target big integer 6256M
SQL>
SQL> show parameter memory
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 6256M
memory_target big integer 6256M
shared_memory_address integer 0
SQL>
No comments:
Post a Comment