Wednesday, June 23, 2021

ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 3200M, ORA-01078: failure in processing system parameters

 SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 24 09:49:39 2021

Version 19.3.0.0.0


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


Enter user-name: hr/hr@orcl

ERROR:

ORA-12514: TNS:listener does not currently know of service requested in connect

descriptor



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 3200M

ORA-01078: failure in processing system parameters

SQL> startup pfile=D:\appdb19c\app\OracleHomeUser1\admin\orcl\pfile\init.ora.513202112044

ORACLE instance started.


Total System Global Area 2516579304 bytes

Fixed Size                  9053160 bytes

Variable Size             541065216 bytes

Database Buffers         1958739968 bytes

Redo Buffers                7720960 bytes

Database mounted.

Database opened.

SQL> create spfile from pfile='c:\temp\init.ora';


File created.


SQL> startup force;

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

ORA-01078: failure in processing system parameters

SQL> show parameter memory_target

ORA-01034: ORACLE not available

Process ID: 0

Session ID: 496 Serial number: 49087



SQL> startup pfile=D:\appdb19c\app\OracleHomeUser1\admin\orcl\pfile\init.ora.513202112044

ORACLE instance started.


Total System Global Area 2516579304 bytes

Fixed Size                  9053160 bytes

Variable Size             541065216 bytes

Database Buffers         1958739968 bytes

Redo Buffers                7720960 bytes

Database mounted.

Database opened.

SQL> create spfile from pfile=D:\appdb19c\app\OracleHomeUser1\admin\orcl\pfile\init.ora.513202112044

  2  /

create spfile from pfile=D:\appdb19c\app\OracleHomeUser1\admin\orcl\pfile\init.ora.513202112044

                         *

ERROR at line 1:

ORA-02236: invalid file name



SQL> create spfile from pfile='D:\appdb19c\app\OracleHomeUser1\admin\orcl\pfile\init.ora.513202112044'

  2  /


File created.


SQL> startup force;

ORACLE instance started.


Total System Global Area 2516582224 bytes

Fixed Size                  9031504 bytes

Variable Size             553648128 bytes

Database Buffers         1946157056 bytes

Redo Buffers                7745536 bytes

Database mounted.

Database opened.

SQL>

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...