Color a Complete Row Based on Condition Interactive Report|| Oracle APEX

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

1<span class="lit">SQL</span><span class="pun">-</span><span class="pln"> conn SYS AS SYSSDBA</span>

Alter The Session To The Pluggable Database With The Following Command.

1<span class="lit">SQL</span><span class="pun">-</span><span class="pln"> ALTER SESSION SET CONTAINER </span><span class="pun">=</span><span class="pln"> orclpdb</span><span class="pun">;</span>

Next, Start Up The Database.

1<span class="lit">SQL</span><span class="pun">-</span><span class="pln"> STARTUP</span>

After That Database Will Not Show The Above Error.

Check Usage Status

1<span class="lit">SQL</span><span class="pun">-</span><span class="pln"> SELECT status FROM v$instance</span><span class="pun">;</span>

Oracle Database 19c Then Follow The Steps Below

Login With SYS as SYSDBA. Change The Session To The Pluggable Database, Following Command.

12<span class="lit">ALTER</span><span class="pln"> SESSION SET 
    CONTAINER </span><span class="pun">=</span><span class="pln"> orclpdb</span><span class="pun">;</span>

Startup Your Database..

1<span class="lit">STARTUP</span>

Ora-01531: Your Database Is Already Open Throws An Error Then Change Container To Enter PDB Database Name

1<span class="lit">ALTER</span><span class="pln"> SESSION SET CONTAINER </span><span class="pun">=</span><span class="pln"> ORCLPDB</span>

🔗 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.........................