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