How To Resolve This "Ora-01109: Database Not Open" Error?

How To Resolve This "Ora-01109, Ora-01109, Ora-01109: Database Not Open, Database Not Open, database not open
How To Resolve This "Ora-01109: Database Not Open" Error?
ORA-01109 database not open error ORA-01109 Database Not Open Error How Do I Resolve This Ora-01109: Database Not OpenError? If You Use 19c Then Follow The Steps Below- Open The Cmd Window On Your Computer. Login With SYS User SQL- conn SYS AS SYSSDBA Alter The Session To The Pluggable Database With The Following Command. SQL- ALTER SESSION SET CONTAINER = orclpdb; Next, Start Up The Database. SQL- STARTUP After That Database Will Not Show The Above Error. Check Usage Status SQL- SELECT status FROM v$instance; Oracle Database 19c Then Follow The Steps Below Login With SYS as SYSDBA. Change The Session To The Pluggable Database, Following Command. ALTER SESSION SET CONTAINER = orclpdb; Startup Your Database.. STARTUP Ora-01531: Your Database Is Already Open Throws An Error Then Change Container To Enter PDB Database Name ALTER SESSION SET CONTAINER = ORCLPDB 🔗 Demo Application- URL- Demo Application Username - demo, Pass- demo I hope everyone will like it. Please watch the full video, Comment on…

1 comment

  1. Anonymous
    Great this solution worked for me...thanks