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 Change Both DB_NAME and DB_UNIQUE_NAME of a Single-Instance Database
In 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 Database
In 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 Database
In 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 Database
For 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'
ORA-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 exclusively
NID-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 specified
ORA-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