srvctl config database

How to Resolve PRCD-1120 : The resource for database could not be found.

by Ed Chen
July 10, 2021June 4, 2022
2 Comments

PRCD-1120 PRCD-1120 means that the database you want to operate with is not found in the cluster. Mostly, you misspelled the resource name of database.… Read More »

How to Change DB_UNIQUE_NAME of a RAC Database

by Ed Chen
February 3, 2021October 29, 2022

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 »

Srvctl Add Database Example

by Ed Chen
December 5, 2020October 24, 2022

Add RAC DB Let me ask you a question, why would you like to add a RAC database to a cluster? In my experience, there're… Read More »

How to Resolve ORA-29760: instance_number parameter not specified

by Ed Chen
December 4, 2020July 9, 2022
4 Comments

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 Resolve OPW-00010: Could not create the password file. This resource has a Password File.

by Ed Chen
December 3, 2020April 6, 2022
2 Comments

OPW-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 Srvctl Modify Database SPFILE

by Ed Chen
December 2, 2020November 2, 2022

Srvctl Modify Database SPFILE We have changed the location of password file by srvctl modify database in the previous post, here we plan to change… Read More »

How Srvctl Modify Database Password File

by Ed Chen
December 2, 2020July 8, 2022

Srvctl Modify Database Password Even though I chose NOT to use Oracle Managed Files (OMF) during Oracle RAC database creation, I still got OMF password… 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, 2020August 10, 2021

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 Change SPFILE Location in Oracle

by Ed Chen
February 23, 2019July 3, 2022

ALTER SYSTEM SET SPFILE Before reading, you have to know that there's no ALTER SYSTEM SET SPFILE statement in Oracle, because we can never write… Read More »