Determining if an Oracle Home is Read-Only

Run the orabasehome command to determine if your Oracle home is a read/write or read-only Oracle home.

If the output of the orabasehome command is the same as %ORACLE_HOME%, then your Oracle home is in read/write mode. If the output displays the path ORACLE_BASE\homes\HOME_NAME, then your Oracle home is in read-only mode.

1. Set the ORACLE_HOME environment variable:

   C:\> set ORACLE_HOME=C:\app\oracle\product\18.0.0\dbhome_1
   

2. Go to the bin directory and run the orabasehome command:

   C:\> cd %ORACLE_HOME%\bin
   orabasehome
   
   C:\> C:\app\oracle\homes\OraDB18Home1

   In this example, the Oracle home is in read-only mode.