Local Undo of PDB for Each RAC Instance
Usually, we have separate undo tablespace for each instance in a RAC database. For example, UNDOTBS1 is for the first instance and UNDOTBS2 is for… Read More »Local Undo of PDB for Each RAC Instance
RAC
How to Resolve ORA-01109: database not open
ORA-01109 ORA-01109 is pretty normal when your database is close, mostly it's previously shutdown manually by someone, or the database shutdown itself by accident, you… Read More »How to Resolve ORA-01109: database not open
How to Change Both DB_NAME and DB_UNIQUE_NAME of a RAC Database
We plan to do the following items in order to change both DB_NAME and DB_UNIQUE_NAME of a RAC database. Database Level: Change DB_NAME of a… Read More »How to Change Both DB_NAME and DB_UNIQUE_NAME of a RAC Database
How to Change DB_UNIQUE_NAME of a RAC Database
In previous post, we have talked about how to change DB_NAME of a RAC database. In this post, we will talk about how to change… Read More »How to Change DB_UNIQUE_NAME of a RAC Database
How to Change DB_NAME of a RAC Database
In previous post, we have talked about how to change DBID of a RAC database. In this post, we will talk about how to change… Read More »How to Change DB_NAME of a RAC Database
How to Change DBID of a RAC Database
In previous post, we have talked about how to change both DB_NAME and DB_UNIQUE_NAME of a single-instance database. In this post, we will talk about… Read More »How to Change DBID of a RAC Database
How to Create an Empty RAC Database without Using DBCA
Let me ask you a question, why would you like to create an empty RAC database? In my experience, there're two use cases that can… Read More »How to Create an Empty RAC Database without Using DBCA
How to Resolve ORA-29760: instance_number parameter not specified
ORA-29760 ORA-29760: instance_number parameter not specified means that Oracle cannot find any INSTANCE_NUMBER for given instance names in the parameter file to startup the instance.… Read More »How to Resolve ORA-29760: instance_number parameter not specified
How to Revert OMF Spfile and Password File in RAC
Even though I chose NOT to use Oracle Managed Files (OMF) during Oracle 19c RAC database creation, I still got OMF spfile and password file… Read More »How to Revert OMF Spfile and Password File in RAC
How to Prevent Automatic Restart of a Database by SRVCTL
Oracle Automatic Restart contains a lot of components to be restarted. Here we focus on the database. The default policy of a RAC database is… Read More »How to Prevent Automatic Restart of a Database by SRVCTL