Tuesday, February 6, 2018

How resolve Error ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET

ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET


[oracle@localhost ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Tue Feb 6 21:43:27 2018
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
SQL>
SQL> create pfile='/tmp/db.ora' from spfile;

File created.

SQL> exit
Disconnected
[oracle@localhost ~]$

Change memory_max_target,memory_target parameter in pfile

*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4385144832
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ducatXDB)'
*.memory_max_target=1000M
*.memory_target=1000M
*.open_cursors=300
*.os_authent_prefix='OPS$'

start instance using pfile 

[oracle@localhost ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Tue Feb 6 21:46:36 2018

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup pfile=/tmp/db.ora;
ORACLE instance started.

Total System Global Area 1043886080 bytes
Fixed Size                  2259840 bytes
Variable Size             654312576 bytes
Database Buffers          381681664 bytes
Redo Buffers                5632000 bytes
Database mounted.
Database opened.

SQL> show parameter mem

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address             integer     0
memory_max_target                    big integer 1000M
memory_target                        big integer 1000M
shared_memory_address                integer     0
SQL>
SQL> show parameter sga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 1000M
sga_target                           big integer 0
SQL>
SQL>

Create spfile from pfile 

SQL> create spfile from pfile='/tmp/db.ora';

File created.

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1043886080 bytes
Fixed Size                  2259840 bytes
Variable Size             654312576 bytes
Database Buffers          381681664 bytes
Redo Buffers                5632000 bytes
Database mounted.
Database opened.
SQL> show parameter target

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target                   integer     0
db_flashback_retention_target        integer     4320
fast_start_io_target                 integer     0
fast_start_mttr_target               integer     0
memory_max_target                    big integer 1000M
memory_target                        big integer 1000M
parallel_servers_target              integer     16
pga_aggregate_target                 big integer 0
sga_target                           big integer 0
SQL>
SQL> select name,open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
DUCAT     READ WRITE


SQL>


2 comments:

  1. 3 years later, I finally managed to do it. I lacked *.memory_max_target. Added it into the pfile and worked like a charm. Thanks!

    ReplyDelete
  2. Oracle Database Problem And Solutions: How Resolve Error Ora-00837: Specified Value Of Memory_Target Greater Than Memory_Max_Target >>>>> Download Now

    >>>>> Download Full

    Oracle Database Problem And Solutions: How Resolve Error Ora-00837: Specified Value Of Memory_Target Greater Than Memory_Max_Target >>>>> Download LINK

    >>>>> Download Now

    Oracle Database Problem And Solutions: How Resolve Error Ora-00837: Specified Value Of Memory_Target Greater Than Memory_Max_Target >>>>> Download Full

    >>>>> Download LINK

    ReplyDelete