DB_NAME

How to Resolve ORA-32016: parameter "db_name" cannot be updated in SPFILE

by Ed Chen
February 28, 2022January 17, 2022

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 »

Where is DBCA Log Location

by Ed Chen
December 31, 2021April 22, 2022

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 »

How to Change Both DB_NAME and DB_UNIQUE_NAME of a RAC Database

by Ed Chen
February 6, 2021January 11, 2021

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 DB_UNIQUE_NAME of a RAC Database

by Ed Chen
February 3, 2021October 3, 2021

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 Both DB_NAME and DB_UNIQUE_NAME of a Single-Instance Database

by Ed Chen
January 23, 2021October 24, 2021

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 DB_NAME of a Single-Instance Database

by Ed Chen
January 16, 2021March 8, 2022

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 Resolve NID-00120 Error Message

by Ed Chen
January 6, 2021September 18, 2021

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 Create a 19c Database by DBCA with Silent Mode

by Ed Chen
August 3, 2019October 24, 2021
4 Comments

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 »

Relationships among DB_NAME, DB_UNIQUE_NAME, SERVICE_NAMES, INSTANCE_NAME, and $ORACLE_SID

DB_NAME vs DB_UNIQUE_NAME

by Ed Chen
January 14, 2017October 7, 2021

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 »