ORA-00845

ERROR-1. ORA-00845: MEMORY_TARGET not supported on this system

SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system

Solution :-
Go to pfile location
$ cd /u01/app/oracle/admin/abc/pfile/init.ora.7242012104324
edit MEMORY_TARGET size.
MEMORY_TARGET=88M
save pfile.
After that again startup with pfile..

SQL> startup pfile=/u01/app/oracle/admin/abc/pfile/init.ora.7242012104324

No comments:

How to add a datafile to a bigfile tablespace in Oracle 23ai Database.

  Syntax for Bigfile Tablespace: SQL > ALTER TABLESPACE tablespace_name ADD DATAFILE SIZE 10G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED; Ho...