How to Change DB_UNIQUE_NAME of a RAC Databaseby Ed ChenFebruary 3, 2021January 24, 2021In 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 Create an Empty RAC Database without Using DBCAby Ed ChenDecember 5, 2020February 6, 2021Let 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 Create an Empty RAC Database without Using DBCA
How to Resolve ORA-29760: instance_number parameter not specifiedby Ed ChenDecember 4, 2020December 12, 2020ORA-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 Resolve ORA-29760: instance_number parameter not specified
How to Resolve OPW-00010: Could not create the password file. This resource has a Password File.by Ed ChenDecember 3, 2020December 14, 2020OPW-00010 Tried to create a password file by orapwd, an Oracle utility for a RAC database and got OPW-00010: Could not create the password file.… Read More »How to Resolve OPW-00010: Could not create the password file. This resource has a Password File.
How to Revert OMF Spfile and Password File in RACby Ed ChenDecember 2, 2020December 2, 2020Even 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 Revert OMF Spfile and Password File in RAC
How to Resolve SRVCTL Error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directoryby Ed ChenFebruary 8, 2020February 11, 2020error 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 Error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
How to Change SPFILE Location in Oracleby Ed ChenFebruary 23, 2019January 20, 2021In this post, I will talked about how to change SPFILE location in a single-instance database and in a RAC database. Change SPFILE Location of… Read More »How to Change SPFILE Location in Oracle