Oracle OFA - Directory Architecture
Last updated: Sep 19, 2022
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:
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:
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:
A separate directory is created for each database.
Full path to the database directory.
- 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.