Server Parameter File (SPFILE)

How to Resolve ORA-32001: write to SPFILE requested but no SPFILE is in use

by Ed Chen
December 23, 2022November 17, 2022

ORA-32001 ORA-32001 means that it cannot write the server parameter file at this moment, you should make sure SPFILE is being used by the instance.… Read More »

How to Resolve ORA-09925: Unable to create audit trail file

by Ed Chen
August 20, 2021December 17, 2022

ORA-09925 There're two error scenarios of ORA-09925 in this post: Single-instance Databases RAC Databases Let's see some cases. A. Single-instance Databases Tried to startup a… Read More »

How to Resolve ORA-32002: cannot create SPFILE already being used by the instance

by Ed Chen
August 16, 2021October 23, 2021

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 Change DB_NAME of a RAC Database

by Ed Chen
January 30, 2021December 9, 2022

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 Both DB_NAME and DB_UNIQUE_NAME of a Single-Instance Database

by Ed Chen
January 23, 2021October 24, 2021

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 DB_UNIQUE_NAME of a Single-Instance Database

by Ed Chen
January 20, 2021July 12, 2021

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_NAME of a Single-Instance Database

by Ed Chen
January 16, 2021March 8, 2022

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 Resolve ORA-01565: error in identifying file

by Ed Chen
January 9, 2021December 9, 2022

In this post, I'll describe two error patterns for ORA-01565. Missing SPFILE Multitenant DB A. ORA-01565 for Missing SPFILE To create a plain-text parameter file,… Read More »

Srvctl Add Database Example

by Ed Chen
December 5, 2020December 15, 2022

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 »

How to Resolve ORA-29760: instance_number parameter not specified

by Ed Chen
December 4, 2020July 9, 2022
4 Comments

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 »