How to Tell What State of Databaseby Ed ChenFebruary 10, 2021February 3, 2021We 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 »How to Tell What State of Database
How to Change Both DB_NAME and DB_UNIQUE_NAME of a RAC Databaseby Ed ChenFebruary 6, 2021January 11, 2021We 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 Databaseby Ed ChenFebruary 3, 2021March 14, 2021In 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 Databaseby Ed ChenJanuary 30, 2021February 1, 2021In 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 Databaseby Ed ChenJanuary 27, 2021February 4, 2021In 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 Change Both DB_NAME and DB_UNIQUE_NAME of a Single-Instance Databaseby Ed ChenJanuary 23, 2021January 24, 2021In previous post, we have talked about how to change DB_UNIQUE_NAME of a single-instance database. In this post, we will talk about how to change… Read More »How to Change Both DB_NAME and DB_UNIQUE_NAME of a Single-Instance Database
How to Change DB_UNIQUE_NAME of a Single-Instance Databaseby Ed ChenJanuary 20, 2021January 24, 2021In previous post, we have talked about how to change DB_NAME of a single-instance database. In this post, we will talk about how to change… Read More »How to Change DB_UNIQUE_NAME of a Single-Instance Database
How to Change DB_NAME of a Single-Instance Databaseby Ed ChenJanuary 16, 2021January 24, 2021In previous post, we have talked about how to change DBID of a single-instance database. In this post, we will talk about how to change… Read More »How to Change DB_NAME of a Single-Instance Database
How to Change DBID of a Single-Instance Databaseby Ed ChenJanuary 13, 2021January 23, 2021For a duplicate database, you may want to change its Database Identifier (DBID) only in order to distinguish this one from another. For a RAC… Read More »How to Change DBID of a Single-Instance Database
How to Resolve ORA-01565: error in identifying file '?=/dbs/spfile@.ora'by Ed ChenJanuary 9, 2021January 14, 2021ORA-01565 To create a plain-text parameter file, I usually don't specify both locations of the parameter file (PFILE) or the server parameter file (SPFILE). SQL>… Read More »How to Resolve ORA-01565: error in identifying file '?=/dbs/spfile@.ora'