ORADIM Create Services and Registries
ORADIM In an active/passive cluster, we usually install Oracle software and configure listener in the redundant server, then stop. This is because we don't need… Read More »ORADIM Create Services and Registries
Parameter File (PFILE)
How Oracle Backup SPFILE
Timings to Backup SPFILE In case that we need to restore SPFILE to the original state at a later time, we should backup SPFILE in… Read More »How Oracle Backup SPFILE
How to Resolve ORA-32001: write to SPFILE requested but no SPFILE is in use
ORA-32001 ORA-32001 means that the database cannot write SPFILE at this moment, you should make sure that it has been using by the instance. Let's… Read More »How to Resolve ORA-32001: write to SPFILE requested but no SPFILE is in use
How to Resolve ORA-32016: parameter "db_name" cannot be updated in SPFILE
ORA-32016 Tried to change DB_NAME in SPFILE when the instance is running, but it failed with ORA-32016. Let's see current value of DB_NAME. SQL> show… Read More »How to Resolve ORA-32016: parameter "db_name" cannot be updated in SPFILE
How to Resolve ORA-09925: Unable to create audit trail file
ORA-09925 There're two error scenarios of ORA-09925 in this post: Single-instance Databases RAC Databases Let's see some cases. Single-instance Databases Tried to startup a test… Read More »How to Resolve ORA-09925: Unable to create audit trail file
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 DB_NAME of a RAC Database
In previous post, we have talked about how to change DBID of a RAC database. In this post, we will talk about how to change… Read More »How to Change DB_NAME of a RAC Database
How to Change Both DB_NAME and DB_UNIQUE_NAME of a Single-Instance Database
In previous post, we have talked about how to change DB_UNIQUE_NAME of a single-instance database. In this post, we will talk about how to change… Read More »How to Change Both DB_NAME and DB_UNIQUE_NAME of a Single-Instance Database
How to Change DB_UNIQUE_NAME of a Single-Instance Database
In previous post, we have talked about how to change DB_NAME of a single-instance database. In this post, we will talk about how to change… Read More »How to Change DB_UNIQUE_NAME of a Single-Instance Database
How to Change DB_NAME of a Single-Instance Database
In previous post, we have talked about how to change DBID of a single-instance database. In this post, we will talk about how to change… Read More »How to Change DB_NAME of a Single-Instance Database