2024-11-09 08:25:47
Topic starter
When I try to connect to my database I get this error:
C:\Users\Cruise-control>sqlplus system/<system>@localhost:1521/xepdb1
SQL*Plus: Release 18.0.0.0.0 - Production on Sat Nov 9 03:25:33 2024
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
ERROR:
ORA-01109: database not open
According to https://stackoverflow.com/questions/27280405/how-do-i-resolve-this-ora-01109-database-not-open-error the DB was previously shut down, and someone left it in the middle of the startup process
To fix this, run alter pluggable database xepdb1 open as sysdba:
C:\Users\Cruise-control>sqlplus / as sysdba SQL*Plus: Release 18.0.0.0.0 - Production on Sat Nov 9 03:26:08 2024 Version 18.4.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to: Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Version 18.4.0.0.0 SQL> alter pluggable database xepdb1 open; Pluggable database altered. SQL>