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
Server Parameter File (SPFILE)
How to Revert Read-Only Oracle Home 21c Linux
Read-Only Oracle Home After installing Oracle database 21c on Linux, we found that some features are different from our sense. That's because Read-Only ORACLE_HOME is… Read More »How to Revert Read-Only Oracle Home 21c Linux
Oracle Parameter SESSIONS, How and Why
In this post, we'd like to talk about the following topics for you to manage SESSIONS parameter better. Default Value of SESSIONS How to Check… Read More »Oracle Parameter SESSIONS, How and Why
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-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