ORA-32002: cannot create SPFILE already being used by the instance Tried to restore the server parameter (SPFILE) to the default location from a parameter file… Read More »How to Resolve ORA-32002 Oracle Error Message
Real Application Clusters (RAC)
Usually, we have separate undo tablespace for each instance in a RAC database. For example, UNDOTBS1 is for the first instance and UNDOTBS2 is for… Read More »Local Undo of PDB for Each RAC Instance
ORA-01109 ORA-01109 is pretty normal when your database is close, mostly it's previously shutdown manually by someone, or the database shutdown itself by accident, you… Read More »How to Resolve ORA-01109: database not open
ORA-65025 ORA-65025 means that the pluggable database should be closed completely for further operations like dropping. Let's see a case of dropping a PDB. SQL>… Read More »How to Resolve ORA-65025: Pluggable database is not closed on all instances.
We plan to do the following items in order to change both DB_NAME and DB_UNIQUE_NAME of a RAC database. Database Level: Change DB_NAME of a… Read More »How to Change Both DB_NAME and 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
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
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.