RAC

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, 2021January 24, 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 DB_NAME of a RAC Database

by Ed Chen
January 30, 2021February 1, 2021

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

by Ed Chen
January 27, 2021February 4, 2021

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 Create an Empty RAC Database without Using DBCA

by Ed Chen
December 5, 2020February 6, 2021

Let me ask you a question, why would you like to create an empty RAC database? In my experience, there're two use cases that will… Read More »

How to Resolve ORA-29760: instance_number parameter not specified

by Ed Chen
December 4, 2020December 12, 2020

ORA-29760 ORA-29760: instance_number parameter not specified means that Oracle cannot find any INSTANCE_NUMBER for given instance names in the parameter file to startup the instance.… Read More »

How to Revert OMF Spfile and Password File in RAC

by Ed Chen
December 2, 2020December 2, 2020

Even though I chose NOT to use Oracle Managed Files (OMF) during Oracle 19c RAC database creation, I still got OMF spfile and password file… Read More »

How to Prevent Automatic Restart of a Database by SRVCTL

by Ed Chen
November 14, 2020December 27, 2020

Oracle Automatic Restart contains a lot of components to be restarted. Here we focus on the database. The default policy of a RAC database is… Read More »

How to Resolve SRVCTL Error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory

by Ed Chen
February 8, 2020February 11, 2020

error while loading shared libraries After installing Oracle 10g RAC, we checked the configuration of the cluster database like this: [oracle@primary01 ~]$ srvctl config database… Read More »

How to Resolve Srvctl Start Database ORA-00304: requested INSTANCE_NUMBER is busy

by Ed Chen
July 6, 2019July 8, 2019

Srvctl Start Database ORA-00304 Saw some errors when I tried to startup a cluster database by srvctl. [oracle@primary01 ~]$ srvctl start database -d compdb PRCR-1079… Read More »