ORACLE_BASE

How to Install Oracle Database 19c on Linux

by Ed Chen
March 2, 2023March 13, 2023

We supposed that you already have installed Oracle Linux 8, Red Hat Enterprise Linux 8 or its derivatives like AlmaLinux for your database server. There're… Read More »

How to Install Oracle Database 19c on Solaris

by Ed Chen
January 24, 2023March 13, 2023

There're 2 phases of the installation of Oracle database 19c (19.3) as below. OS Configuration Installation Please note that, if you want your database server… Read More »

How to Clone Oracle Home

by Ed Chen
December 19, 2022February 13, 2023

Cloning Database Home Cloning an Oracle database home to another place by clone.pl might be more complicated than you thought, especially in a RAC environment.… Read More »

How to Resolve DIA-48448: This command does not support multiple ADR homes

by Ed Chen
February 16, 2022December 13, 2021

DIA-48448 Tried to purge trace files in ADRCI, but it failed with DIA-48448 adrci> purge -age 10080 DIA-48448: This command does not support multiple ADR… Read More »

AUDIT_FILE_DEST (ADUMP)

by Ed Chen
January 7, 2022October 22, 2022

Audit File Location The audit file location AUDIT_FILE_DEST, also known as ADUMP, is the parameter that specifies the destination of audit files in a database.… Read More »

Where is DBCA Log Location

by Ed Chen
December 31, 2021April 22, 2022

DBCA Log Location Two locations that you can see the trace log of Database Configuration Assistant (DBCA). DBCA log location The file path and name… Read More »

Where is xdb_wallet

by Ed Chen
November 5, 2020January 31, 2023

There're two possible locations for xdb_wallet. Single-instance Databases The root entry of xdb_wallet is $ORACLE_BASE for single-instance databases. $ORACLE_BASE/admin/$ORACLE_SID/xdb_wallet/ RAC Databases The root entry of… Read More »

How to Move ORACLE HOME

by Ed Chen
January 23, 2019February 13, 2023

Allow me to ask you a question before going further: why would you like to move ORACLE HOME to another place? You may leave your… Read More »

How to Build 18c RAC - 1 of 4 - Preparing Two Database Servers

by Ed Chen
December 15, 2018February 13, 2023
4 Comments

For 19c, you may refer to: How to Build 19c RAC - 1 of 4 - Preparing Two Database Servers. Network Design for RAC Let's… Read More »

TNS_ADMIN, How and Why

by Ed Chen
March 25, 2018December 11, 2022
4 Comments

There're 4 sections we'll talk about TNS_ADMIN in this post. TNS_ADMIN in Oracle Software Registry Basics of TNS_ADMIN How to Define TNS_ADMIN What About %PATH%… Read More »