How to Tell What State of Database
We 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 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 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'