How to Clone Oracle Home
Cloning Database Home Cloning an Oracle database home to another place by clone.pl might be more complicated than you thought, especially in a RAC environment.… Read More »How to Clone Oracle Home
srvctl stop database
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 PRKO-3141 : Database could not be removed because it was running
PRKO-3141 or PRKO-03141 Tried to remove a RAC database from the cluster, but it failed with PRKO-3141. [oracle@primary01 ~]$ srvctl remove database -d orclcdb PRKO-3141… Read More »How to Resolve PRKO-3141 : Database could not be removed because it was running
How to Resolve CRS-0245: User doesn't have enough privilege to perform the operation
CRS-0245 There could be many possibilities that throw CRS-0245, this is only one case when we tried to modify the database by grid. In this… Read More »How to Resolve CRS-0245: User doesn't have enough privilege to perform the operation
How to Resolve PRCC-1016 : ORCLCDB was already stopped
PRCC-1016 Found an error PRCC-1016 when I tried to stop a RAC database. By the way, it's a Container Database (CDB). [oracle@primary01 ~]$ srvctl stop… Read More »How to Resolve PRCC-1016 : ORCLCDB was already stopped
How to Resolve ORA-32002: cannot create SPFILE already being used by the instance
ORA-32002 Tried to restore the server parameter (SPFILE) to the default location from a parameter file (PFILE), but it failed with ORA-32002 like this. SQL>… Read More »How to Resolve ORA-32002: cannot create SPFILE already being used by the instance
How to Change DBID of a RAC Database
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 Change DBID of a RAC Database
How to Restart Oracle Database
In this post, we'll talked about how to restart a database in a efficient way, which includes: Restart a Single-Instance DB Restart a RAC DB… Read More »How to Restart Oracle Database
How Srvctl Stop Database
There're 4 levels that can stop a RAC database, each level has different effect on the RAC system. As for stopping a single-instance database, it… Read More »How Srvctl Stop Database
How to Change SPFILE Location in Oracle
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 »How to Change SPFILE Location in Oracle