DB_NAME

How to Change DB_NAME of a Single-Instance Database

by Ed Chen
January 16, 2021December 29, 2020

In this post, we will talk about how to change DB_NAME of a single-instance database. First of all, let's see the current status. SQL> select… Read More »

How to Resolve NID-00120: Database should be mounted exclusively

by Ed Chen
January 6, 2021January 9, 2021

NID-00120 I was trying to change database name (DB_NAME) of a 19c RAC database by DBNEWID utility (nid), but it failed with NID-00120: Database should… Read More »

How to Create a 19c Database by DBCA with Silent Mode

by Ed Chen
August 3, 2019December 29, 2020

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 »

DB_NAME, DB_UNIQUE_NAME, SERVICE_NAMES, INSTANCE_NAME, and $ORACLE_SID

by Ed Chen
January 14, 2017November 12, 2020

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 »