Oracle OFA - Directory Architecture

Last update: Apr 3, 2024
Views: 31
Author: Admin

WE ARE ON YOUTUBE

Colleagues hello to all.

In today's article we will talk about which directories are needed for Oracle software products.

There is a standard for an optimal and flexible architecture that helps organize Oracle databases so that multiple databases of different versions owned by different users can coexist on the same server. If everything is done optimally, then the flexible architecture helps to identify ORACLE_BASE using its automatic diagnostic repository (ADR). When you install Oracle RDBMS, its universal installer places Oracle database components in directories, assigning default permissions in accordance with Best Flexible Architecture guidelines.

Proper directory organization as well as consistent filenames for database files gives you an advantage in Oracle database administration. You must create all directories under special accounts, such as oracle or grid.

Mount point name.

When mounting a point to the Linux file system where we will install our Oracle DBMS, then such a point is usually called:

/u01

/u02

/u03

/disk01

/disk02

/disk03

Name of the base directory.

After the mount point, we need to create the following directory for Oracle Base. The Oracle Base directory is the top-level directory that is used to install various Oracle software products, not just the database. You can use the same base directory for multiple Oracle installations. The base directory name should be called:

/u01/app/oracle

Database directory name.

After creating the base directory, the next step is to create a directory for the database itself. The directory name is usually called, for example:

dbhome_1

dbhome_2

db_home3

A separate directory is created for each database.

Full path to the database directory.

/u01/app/oracle/product/19/dbhome_1

product - Any Oracle software to be installed.
19 - Product version.
dbhome_1 - The name of the product, in our case the database.

Examples directories for other Oracle products.

/u01/app/oracle/product/19/dbhome_1 - Oracle Database
/u01/app/oracle/product/19/grid - Oracle Grid Infrastructure
/u01/app/oracle/product/19/client_1 - Oracle Client
/u01/app/oracle/product/19/gateway - Oracle Database Gateway

Thank you all, I hope that my article helped you in some way.