SQL> startup
ORACLE instance started.
Total System Global Area 4294964000 bytes
Fixed Size 9143072 bytes
Variable Size 1577058304 bytes
Database Buffers 2701131776 bytes
Redo Buffers 7630848 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 46641
Session ID: 259 Serial number: 54397
SQL> STARTUP MOUNT;
SP2-0642: SQL*Plus internal error state 2133, context 3114:0:0
Unsafe to proceed
ORA-03114: not connected to ORACLE
SQL> sqlplus
SP2-0042: unknown command "sqlplus" - rest of line ignored.
SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@vmi2001271 ~]$ sqlplus
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Sep 10 09:15:03 2024
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> SHUTDOWN IMMEDIATE;
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 4376
Additional information: -896098569
Process ID: 0
Session ID: 0 Serial number: 0
SQL> shutdown abort
ORACLE instance shut down.
SQL> STARTUP MOUNT;
ORACLE instance started.
Total System Global Area 4294964000 bytes
Fixed Size 9143072 bytes
Variable Size 1577058304 bytes
Database Buffers 2701131776 bytes
Redo Buffers 7630848 bytes
Database mounted.
SQL> ^C
SQL> startup nomount
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> alter database clear unarchived logfile group 3;
Database altered.
SQL> alter database clear unarchived logfile group 2;
Database altered.
SQL> alter database clear unarchived logfile group 1;
Database altered.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 4294964000 bytes
Fixed Size 9143072 bytes
Variable Size 1577058304 bytes
Database Buffers 2701131776 bytes
Redo Buffers 7630848 bytes
Database mounted.
Database opened.
No comments:
Post a Comment