How to Check DB Status by Scriptby Ed ChenJanuary 27, 2023January 5, 2023To check if a databae is alive or not, we already have a way to do it. However, such script can't tell NOMOUNT, MOUNT or… Read More »How to Check DB Status by Script
How to Resolve ORA-65054: Cannot open a pluggable database in the desired modeby Ed ChenNovember 14, 2022November 21, 2022ORA-65054 Tried to open a pluggable database (PDB), but it failed with ORA-65054. Let's see how it happened. SQL> alter session set container=ORCLPDB; Session altered.… Read More »How to Resolve ORA-65054: Cannot open a pluggable database in the desired mode
Database States Differentiations in Oracleby Ed ChenFebruary 10, 2021January 12, 2023We have already known that there're 4 states in life cycle of an instance. They are idle, nomount, mount and open. In this post, we… Read More »Database States Differentiations in Oracle