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:

Manage Inactive session in Oracle 23AI Database.

# CONNECT WITH PDB DATABASE(ORACLE 23AI) [oracle@prd-23ai ~]$ sqlplus / as sysdba  SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engin...