ORACLE_HOME

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 Instant Client 19c on Linux

by Ed Chen
March 1, 2023February 15, 2023

Suppose that you have known the differences between Oracle client and Oracle instant client, and decide to install Oracle instant client for your machine. On… 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 »

Srvctl Modify Database Oracle Home

by Ed Chen
December 20, 2022March 13, 2023

New Oracle Home After cloning a new Oracle home for the RAC database, we should report the new Oracle Home to the cluster by command… 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 Install Oracle Database 21c on Windows

by Ed Chen
September 19, 2022March 20, 2023

For Oracle database 19c installation on Windows, you may go for it. Extract Oracle DB Home 21.3 Image Since release 18c, all database software installation… Read More »

How to Install Oracle Database 19c on Windows

by Ed Chen
April 6, 2022March 20, 2023

For Oracle database 21c installation on Windows, you may go for it. Extract Oracle DB Home 19.3 Image Since release 18c, all database software installation… Read More »

Where is Tnsnames.ora Location

by Ed Chen
January 19, 2022November 19, 2022

tnsnames.ora Suppose you have known the usage of TNSNAMES, now let's see where we can find it in this post. In fact, the location of… Read More »

Where is ORACLE_HOME Location

by Ed Chen
January 17, 2022November 6, 2022

What is ORACLE_HOME ORACLE_HOME is the location of Oracle database home directory path, which contains many important file relationship we may use them very often.… 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 »