Read-Only Oracle Homes on Oracle 18c

Starting with Oracle Database 18c, you can configure an Oracle home in read-only mode.

In a read-only Oracle home, all the configuration data and log files reside outside of the read-only Oracle home. This feature allows you to use the read-only Oracle home as a software image that can be distributed across multiple servers.

Apart from the traditional ORACLE_BASE and ORACLE_HOME directories, the following directories contain files that used to be in ORACLE_HOME:

• ORACLE_BASE_HOME
• ORACLE_BASE_CONFIG

SYNTAX

[oracle@localhost lib]$ roohctl -help
Usage: roohctl [<flag>] [<command> <option>]
Following are the possible flags:
-help

Following are the possible commands:
-enable Enable Read-only Oracle Home
[-nodeList List of nodes in a cluster environment]

To print the ORACLE_BASE_HOME path, run the orabasehome command from the $ORACLE_HOME/bin directory:

[oracle@localhost bin]$ ./orabasehome
/u01/app/oracle/homes/OraDB18Home1
[oracle@localhost bin]$ ./orabaseconfig
/u01/app/oracle

View the contents of the orabasetab file.

[oracle@localhost lib]$ cat $ORACLE_HOME/install/orabasetab
#orabasetab file is used to track Oracle Home associated with Oracle Base
/u01/app/oracle/product/18.0.0.0/db_1:/u01/app/oracle:OraDB18Home1:N:

Enabling a Read-Only Oracle Home

[oracle@localhost lib]$ roohctl -enable -force
Enabling Read-Only Oracle home.
The Oracle Home is configured with databases 'UPG18C,UPG18C,orcl,test'.
The Oracle Home is configured with listeners 'LISTENER_18C'.
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.
Read-Only Oracle home has been enabled successfully.
Check the log file /u01/app/oracle/cfgtoollogs/roohctl/roohctl-180226AM032438.log.

View the contents of the orabasetab file.

[oracle@localhost lib]$ cat $ORACLE_HOME/install/orabasetab
#orabasetab file is used to track Oracle Home associated with Oracle Base
/u01/app/oracle/product/18.0.0.0/db_1:/u01/app/oracle:OraDB18Home1:Y:

Disabling a Read-Only Oracle Home

[oracle@localhost lib]$ roohctl -disable -force
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 /u01/app/oracle/cfgtoollogs/roohctl/roohctl-180226AM032503.log.

View the contents of the orabasetab file.

[oracle@localhost lib]$ cat $ORACLE_HOME/install/orabasetab
#orabasetab file is used to track Oracle Home associated with Oracle Base
/u01/app/oracle/product/18.0.0.0/db_1:/u01/app/oracle:OraDB18Home1:N:

Stay tuned for more articles on Oracle 18c 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp