ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET

来源：互联网发布：天猫和淘宝哪个质量好编辑：程序博客网时间：2024/06/10 03:51

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

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