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 set the schema session limit in Oracle 23 AI Database.

  In Oracle, to set a session limit per schema (user)—i.e., control how many concurrent sessions a specific user can have. You use profiles ...