How to Change DB_UNIQUE_NAME of a RAC Databaseby Ed ChenFebruary 3, 2021January 24, 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'
How to Resolve NID-00120: Database should be mounted exclusivelyby Ed ChenJanuary 6, 2021January 22, 2021NID-00120 NID-00120 means that the current instance does not get the exclusivity of the cluster database, so DBNEWID utility (nid) cannot change the database name… Read More »How to Resolve NID-00120: Database should be mounted exclusively
How to Resolve ORA-01730: invalid number of column names specifiedby Ed ChenJanuary 2, 2021December 17, 2020ORA-01730 ORA-01730 means that the number of listed columns between the target (the view) and the source (the base table) in the CREATE VIEW statement… Read More »How to Resolve ORA-01730: invalid number of column names specified