I m getting the ORA-00823 message:
ORA-00823: Specified value of sga_target greater than
How do I recover from this ORA-00923
ORA-008323 often happens when you are trying to disable
Oracle Automatic Memory Management.
To safely fix the ORA-00823 error
follow these steps. You do NOT need to start the
database to fix this:
SQL> connect system/manager as sysdba
SQL> create pfile='C:\ora\pfile\init.ora'
Now edit the pfile in notepad to make
sga_target greater then sga_max_size.
See: "SGA Re-Sizes Occurring Despite
AMM/ASMM Being Disabled (MEMORY_TARGET/SGA_TARGET=0
MOSC ID 1269139.1