Skip to Main Content

ora-01109 database not open

NodjusFeb 18 2022

[oracle@localhost] SQLPLUS /NOLOG
SQL*Plus: Release 21.0.0.0.0 - Production on Jeu. FÚvr. 17 17:34:47 2022
Version 21.3.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
SQL>
SQL> conn sys/admin as sysdba
Connected.
SQL>
SQL>
SQL> shutdown immediate;
ORA-01109: database not open
Database unmounted.
ORACLE Instance stopped.
SQL>
SQL>
SQL> startup;
ORACLE Instance launched.

Total System Global Area 1291844872 bytes
Fixed Size 9854216 bytes
Variable Size 771751936 bytes
Database Buffers 503316480 bytes
Redo Buffers 6922240 bytes
Database mounted.
ORA-00742: Log read detects write loss in thread 1,
sequence 16, block 208650
ORA-00312: journal en ligne 1 thread 1 : 'C:\APEXDEV\DB\ORADATA\XE\REDO01.LOG'

SQL> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MOUNTED
3 XEPDB1 MOUNTED
SQL>
SQL>
SQL>
SQL> alter pluggable database xepdb1 open;
alter pluggable database xepdb1 open
*
ERREUR Ó la ligne 1 :
ORA-01109: database not open

Comments
Post Details
Added on Feb 18 2022
0 comments
2 views