How To Solve Ora-01219 Database Or Pluggable Database Not Open

Ora-01219 Database Or Pluggable Database Not Open

Those Of Us Who Use Oracle Database Have To Face This Problem At Different Times, Ora-01219 Database Or Pluggable Database Not Open. In Today's Post I Will Discuss In Detail How To Solve The Problem Of Ora-01219 Database Or Pluggable Database Not Open, Hopefully After Reading The Entire Post You Can Easily Solve The Problem Of Ora-01219 Database Or Pluggable Database Not Open.

1. Open The Computer's CMD In Administrator Mode

SQLPlUS / AS SYSDBA

Check The Database Name And Open Mode-

SELECT NAME, OPEN_MODE FROM V$DATABASE;

Check The Name Of The Pluggable Database And Open Mode-

SELECT NAME, OPEN_MODE FROM V$PDBS;

Connect Pluggable Database-

CONN SYS / SYS @ ORCLPDB AS SYSDBA

Check Pluggable Database Status-

select status from v$instance;

If The Pluggable Database Is Not Open Or Shows A Different Status, Enter The Following SQL Codes.

ALTER DATABASE OPEN;
		or
	alter pluggable database orclpdb open;

Check The Pluggable Database Name And Open Mode Again. If The Open Mode Of The Pluggable Database Is Not Read And Write, Type The Following SQL Code And Press Enter, Hopefully Your Problem Will Be Solved.

SELECT name, open_mode FROM v$pdbs ORDER BY name;

🔗 Demo Application-
URL- Demo Application
Username - demo, Pass- demo

I hope everyone will like it. Please watch the full video,
Comment on any of your problems, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable. Visit my blog site, new technology related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work.
Please stay tuned by subscribing to the YouTube channel, and encourages new videos to be uploaded.
=================
Visit my site to get more collaborative posts about Oracle Apex and subscribe to my YouTube channel. Thanks.
Comment on any of your issues, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable.
Visit my blog site, new technology-related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work.
==============================

🙍🏾‍ Md jABER HOSSEN
📲 Mobile- +8801760688286
📨 Email- jaberit786@gmail.com
🌐 FB- facebook.com/mdjaber.hossen1
Please Subscribe to My Channel

Many thanks for visiting the site.

Then Enjoy.........................