SOLVED

ORA-00849: SGA_TARGET cannot be set to more than MEMORY_MAX_TARGET

Asked by OracleDba••12 views•oracle

#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
ORA-00849: SGA_TARGET cannot be set to more than MEMORY_MAX_TARGET

SQL> show sga

SQL> show parameter memory

SQL> show parameter sga

SQL> create pfile = 'INITPRIM.ORA' from spfile ='SPFILEPRIM.ORA';

File created.

 modify pfile as per your need using some editor, and remove your spfile

SQL> create spfile = 'SPFILEPRIM.ORA' from pfile ='INITPRIM.ORA';

File created.

SQL> STARTUP

ORACLE instance started.

Total System Global Area 3.4206E+10 bytes

Fixed Size                  2256912 bytes

Variable Size            1.9864E+10 bytes

Database Buffers         1.4227E+10 bytes

Redo Buffers              112771072 bytes

Database mounted.

Database opened.

Hope It Helps!
OracleDba•

Post Your Solution