How Oracle Rename Database
It depends on what name you want to change in the database. Usually, database name can be DB_NAME, DB_UNIQUE_NAME or both in Oracle. We have… Read More »How Oracle Rename Database
DB_NAME
How to Resolve ORA-32016: parameter "db_name" cannot be updated in SPFILE
ORA-32016 Tried to change DB_NAME in SPFILE when the instance is running, but it failed with ORA-32016. Let's see current value of DB_NAME. SQL> show… Read More »How to Resolve ORA-32016: parameter "db_name" cannot be updated in SPFILE
Where is DBCA Log Location
DBCA Log Location Two locations that you can see the trace log of Database Configuration Assistant (DBCA). DBCA log location The file path and name… Read More »Where is DBCA Log Location
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 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_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 Resolve NID-00120 Error Message
NID-00120: Database should be mounted exclusively NID-00120 means that the current instance does not get the exclusivity of the cluster database, so DBNEWID utility (nid)… Read More »How to Resolve NID-00120 Error Message
How to Create a 19c Database by DBCA with Silent Mode
After installing Oracle 19c software only with silent mode, you may like to create a database by Database Configuration Assistant (DBCA) with silent mode, too.… Read More »How to Create a 19c Database by DBCA with Silent Mode
DB_NAME vs DB_UNIQUE_NAME
Names Among MAA Under Oracle Maximum Availability Architecture (MAA), we might be confused about various kinds of name. Here I try to clarify these names… Read More »DB_NAME vs DB_UNIQUE_NAME