ORA-01109: database not open

🔴 What ORA-01109 Means

Oracle database has 3 main states:

1. NOMOUNT – Instance started (memory + background processes)

2. MOUNT – Control file opened

3. OPEN – Datafiles opened → database ready for use ✅

👉 ORA-01109 occurs when you try to run queries while DB is in:

• NOMOUNT or

• MOUNT state

---

🔎 How to Check Current Status

SELECT status FROM v$instance;

SELECT open_mode FROM v$database;

Example output:

STATUS = MOUNTED
OPEN_MODE = MOUNTED

---

🛠 Solution

✅ Open the Database

ALTER DATABASE OPEN;

---

✅ Or Start Database Fully

STARTUP;

This will:

• Start instance

• Mount database

• Open database

---

🛠 Quick Troubleshooting Checklist

✔ Check instance status
✔ Check database open mode
✔ Open database if mounted
✔ Check recovery requirement
✔ Check if standby DB
✔ Check PDB status (if applicable)

---

⭐ DBA Tip

Always follow:

STARTUP;

instead of partial startup unless needed.

---

🔥 Summary

State	Meaning	Action
NOMOUNT	Instance started	Mount DB
MOUNT	Control file open	Open DB
OPEN	Fully available	✅

---

💡 Important

👉 If database is not opening, always check:

• Alert log

• Recovery requirement

• Datafile status