How to Check Group of OSDBA
OSDBA or OSOPER OSDBA and OSOPER are just a symbol name defined by Oracle database, users belonged to either group are natively granted to use… Read More »How to Check Group of OSDBA
srvctl config database
Srvctl Modify Database Oracle Home
New Oracle Home After cloning a new Oracle home for the RAC database, we should report the new Oracle Home to the cluster by command… Read More »Srvctl Modify Database Oracle Home
Srvctl Remove Database Example
Srvctl Remove Database Command srvctl remove database removes the database configuration from the cluster only, it won't remove the datafiles and dependencies in the storage.… Read More »Srvctl Remove Database Example
How to Resolve PRCD-1120 : The resource for database could not be found.
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 Resolve PRCD-1120 : The resource for database could not be found.
How to Change DB_UNIQUE_NAME of a RAC Database
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_UNIQUE_NAME of a RAC Database
Srvctl Add Database Example
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 »Srvctl Add Database Example
How to Resolve ORA-29760: instance_number parameter not specified
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 ORA-29760: instance_number parameter not specified
How to Resolve OPW-00010: Could not create the password file. This resource has a Password File.
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 to Resolve OPW-00010: Could not create the password file. This resource has a Password File.
How Srvctl Modify Database SPFILE
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 SPFILE
How Srvctl Modify Database Password File
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 Srvctl Modify Database Password File