I am using Oracle db 18c XE 64 bit. I am trying to enable Automatic Memory Management. In order to do so, I have to set memory_max_target parameter first then restart the database then set memory_target parameter according to the documentation https://docs.oracle.com/en/database/oracle/oracle-database/18/admin/managing-memory.html#GUID-0E201F66-D280-472A-AD80-20AB8F7E9C01. I started cmd then opened sqlplus using sqlplus / as sysdba command then issued alter system set memory_max_target=2000M. The system altered successfully. The next step was to set memory_target. I shudown the db using SHUTDOWN command. then exited sqlplus to reopen it using sqlplus /nolog then connect / as sysdba to see error "

ORA-56752: Oracle Database Express Edition (XE) memory parameter invalid or not
specified
ORA-01078: failure in processing system parameters

" Why am I seeing this error?

0

There are 0 answers