Notifications
Clear all

[Solved] ORA-01109: database not open

1 Posts
1 Users
1 Reactions
158 Views
0
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

Topic Tags
1 Answer
1
Topic starter

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>