The Read-Only Oracle Home feature was introduced in Oracle 18c. This feature moves log files and configuration files located in the ORACLE_HOME directory-such as listener.ora, sqlnet.ora, spfile.ora, and others-to subdirectories under ORACLE_BASE.
In Oracle versions 18c and 19c, this feature is not enabled by default. However, it became enabled by default starting with version 21c:
[oracle@RAC3 ~]$ /oracle21c/home/bin/orabasehome /oracle21c/base/homes/OraDB21Home1 
In version 23ai, however, this feature was disabled again:
[oracle@OEL9 ~]$ /oracle23.6/home/bin/orabasehome /oracle23.6/home 
As you can see, the homes folder under ORACLE_BASE is no longer present by default in version 23ai. However, you can enable this feature manually:
[oracle@OEL9 ~]$ cd /oracle23.6/home/bin/ [oracle@OEL9 bin]$ ./roohctl -enable Enabling Read-Only Oracle home. Update orabasetab file to enable Read-Only Oracle home. Orabasetab file has been updated successfully. Create bootstrap directories for Read-Only Oracle home. Bootstrap directories have been created successfully. Bootstrap files have been processed successfully. Bootstrap files have been processed successfully. Read-Only Oracle home has been enabled successfully. Check the log file /oracle23.6/base/cfgtoollogs/roohctl/roohctl-241112AM110738.log for more details. [oracle@OEL9 bin]$ ./orabasehome /oracle23.6/base/homes/OraDB23Home1 To disable the Read-Only Oracle Home, you can run the following command:
[oracle@OEL9 bin]$ ./roohctl -disable Disabling Read-Only Oracle home. Update orabasetab file to disable Read-Only Oracle home. Orabasetab file has been updated successfully. Read-Only Oracle home has been disabled successfully. Check the log file /oracle23.6/base/cfgtoollogs/roohctl/roohctl-241112AM110944.log for more details. [oracle@OEL9 bin]$ ./orabasehome /oracle23.6/home Vahid Yousefzadeh
Oracle Database Administrator
✉vahidusefzadeh@gmail.com
Telegram channel :https://t.me/oracledb
Top comments (0)