ora-00838: specified value of memory_target is too small

SQL> startup
ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 3072M



Make your calculation 3072*1024*1024 = 3221225472

create pfile='F:\oracle192\app\OracleHomeUser2\admin\orcl\pfile\init.ora' from spfile;

edit file and put the above number in memory_target.

Create spfile from pfile='F:\oracle192\app\OracleHomeUser2\admin\orcl\pfile\init.ora' ;

Startup ;




LIVE

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jan 10 09:39:44 2021

Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Enter user-name: sys as sysdba

Enter password:

Connected to an idle instance.

SQL> startup

ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 3216M

ORA-01078: failure in processing system parameters

SQL> startup

ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 3216M

ORA-01078: failure in processing system parameters

SQL> create pfile='F:\oracle192\app\OracleHomeUser2\admin\orcl\pfile\init.ora' from spfile;

File created.

SQL> create spfile from pfile='F:\oracle192\app\OracleHomeUser2\admin\orcl\pfile\init.ora';

File created.

SQL> startup

ORACLE instance started.

Total System Global Area 3372218944 bytes

Fixed Size 9062976 bytes

Variable Size 1371537408 bytes

Database Buffers 1983905792 bytes

Redo Buffers 7712768 bytes

Database mounted.

Database opened.

SQL> conn sys as sysdba

Enter password:

Connected.

SQL>