Initialization Parameters

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 Build 19c RAC - 4 of 4 - Creating a RAC Database

by Ed Chen
October 28, 2020January 19, 2023

After Oracle database 19c software has been installed, we can now create a RAC database by Database Configuration Assistant (DBCA). [oracle@primary01 ~]$ dbca We would… Read More »

How to Change SPFILE Location in Oracle

by Ed Chen
February 23, 2019February 25, 2023
2 Comments

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 Stop Data Guard Services

by Ed Chen
April 9, 2016December 11, 2022

Stop Data Guard Is Broker Enabled? First of all, you need to know whether the data guard broker is configured, started and controls over the… Read More »

How to Compare Two Databases After Migration (1/3) - Comparing Initialization Parameters

by Ed Chen
December 23, 2012October 16, 2019

Go Back to Overview - How to Compare Two Databases After Migration (0/3) - An OverviewThe initialization parameters of a standby database might deviate from… Read More »