ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET

SQL> show parameter memory   

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address             integer     0
memory_max_target                    big integer 1536M
memory_target                        big integer 1504M
shared_memory_address                integer     0
SQL> shutdown immeidate;
SP2-0717: illegal SHUTDOWN option
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
SQL> startup

ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET



SQL> startup pfile='/oracle/app/oracle/admin/tomorrow/pfile/init.ora.24201619435'
ORACLE instance started.

Total System Global Area 1595060224 bytes
Fixed Size                  2265136 bytes
Variable Size             947916752 bytes
Database Buffers          637534208 bytes
Redo Buffers                7344128 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 1528M
sga_target                           big integer 0
SQL> show parameter memory

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address             integer     0
memory_max_target                    big integer 1528M
memory_target                        big integer 1528M
shared_memory_address                integer     0
SQL>  create spfile from memory;

File created.


SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>  startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size                  2253664 bytes
Variable Size             973081760 bytes
Database Buffers          603979776 bytes
Redo Buffers               24096768 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 1536M
sga_target                           big integer 0



SQL> show parameter memory;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address             integer     0
memory_max_target                    big integer 1536M
memory_target                        big integer 1536M
shared_memory_address                integer     0


SQL>  alter system set memory_target=1536M scope=spfile;

System altered.

SQL> alter system set memory_max_target=1536M scope=spfile;

System altered.


ORACLE instance shut down.
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size                  2253664 bytes
Variable Size             973081760 bytes
Database Buffers          603979776 bytes
Redo Buffers               24096768 bytes
Database mounted.
Database opened.
SQL> show parameter memory;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address             integer     0
memory_max_target                    big integer 1536M
memory_target                        big integer 1536M
shared_memory_address                integer     0



  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值