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>
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!
ReplyDeleteOracle Database Problem And Solutions: How Resolve Error Ora-00837: Specified Value Of Memory_Target Greater Than Memory_Max_Target >>>>> Download Now
ReplyDelete>>>>> 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