MOUNT State

How to Resolve ORA-65054: Cannot open a pluggable database in the desired mode

by Ed Chen
November 14, 2022November 21, 2022

ORA-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-01033: ORACLE initialization or shutdown in progress

by Ed Chen
November 15, 2021May 24, 2022

ORA-01033 Tried to connect to the database, but it failed with ORA-01033 like the following. SQL> conn hr/hr@orcl ERROR: ORA-01033: ORACLE initialization or shutdown in… Read More »

How to Resolve ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only

by Ed Chen
October 29, 2021June 8, 2022

ORA-01219 Tried to query a data dictionary, but it failed with ORA-01219. SQL> select * from dba_tablespaces; select * from dba_tablespaces … Read More »

How to Resolve ORA-01109: database not open

by Ed Chen
June 5, 2021December 24, 2022
2 Comments

ORA-01109 ORA-01109 is pretty normal when the database you want to connect or operate with is at MOUNT or NOMOUNT state. In this post, we… Read More »

How Srvctl Start Database

by Ed Chen
September 28, 2019October 22, 2022

To startup a RAC database, we'd better NOT use commands that we used to startup a normal single-instance database, we should use Server Control Utility… Read More »

Switch Database To Copy

by Ed Chen
May 16, 2016October 16, 2022

Move Database by RMAN In the previous post, we have talked about how to move data files in a tablespace to another place by RMAN.… Read More »

Srvctl Modify Database Startup Options

by Ed Chen
November 2, 2012November 9, 2022

Srvctl Start Database Mount Standby In some cases, you would like to change the default startup option of srvctl other than OPEN, for example, after… Read More »