DB_NAME

DATABASE_PROPERTIES, How and Why

by Ed Chen
August 17, 2023August 28, 2023

DATABASE_PROPERTIES DATABASE_PROPERTIES is a data dictionary view which is able to describe the nature of a database by collecting its permanent properties Let's see standard… Read More »

How Oracle Rename Database

by Ed Chen
October 14, 2022November 17, 2022

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 to Resolve ORA-32016: parameter "db_name" cannot be updated in SPFILE

by Ed Chen
February 28, 2022August 10, 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, 2021September 7, 2023

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, 2021February 12, 2023

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, 2021December 9, 2022

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 »

DBCA Silent Database Creation 19c

by Ed Chen
August 3, 2019September 7, 2023
4 Comments

By design, we split the entire installation into several clear sections and make the job easy to troubleshoot. Install Oracle Software Only in Silent Mode… Read More »

JavaScript is not enabled. Please enable it and reload the page.