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
Initialization Parameters
NLS_DATE_FORMAT, How and Why
NLS_DATE_FORMAT defines the display format of a datetime string, which can be set at various levels to meet business requirements. That is to say, NLS_DATE_FORMAT… Read More »NLS_DATE_FORMAT, How and Why
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 Build 19c RAC - 4 of 4 - Creating a RAC Database
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 Build 19c RAC - 4 of 4 - Creating a RAC Database
How to Change SPFILE Location in Oracle
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 Change SPFILE Location in Oracle
How to Stop Data Guard Services
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 Stop Data Guard Services
How to Compare Two Databases After Migration (1/3) - Comparing Initialization Parameters
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 »How to Compare Two Databases After Migration (1/3) - Comparing Initialization Parameters