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 status 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 PRKO-3032 : Invalid instance name(s)
PRKO-3032 or PRKO-03032 Tried to start one instance of a RAC database by SRVCTL utility, but it failed with PRKO-3032. [oracle@primary01 oracle]$ srvctl start instance… Read More »How to Resolve PRKO-3032 : Invalid instance name(s)
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 SRVCTL Error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
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 Error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
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