Delphix Products

 View Only
  • 1.  Oracle VDBs in /etc/oractab file

    Posted 08-28-2023 06:01:00 AM


    I would like to ask, is there a requirement for putting entries into oratab file for provisioned virtual databases?

    Does anyone have such experiences around needing or not needing puttting a manual entry into oratab file for a provisioned VDB?

    Since Delphix is registering a VDB to the listener during the provision operation I believe it is not a "must" but would like to hear about your feedback as well.


    Rahim Cetinel
    Lead Dataops Architect | Delphix Blackbelt

  • 2.  RE: Oracle VDBs in /etc/oractab file
    Best Answer

    Posted 08-28-2023 06:29:00 AM

    Hi Rahim,

         It is not a requirement or mandatory to add VDBs to oratab for provisioning.  Oratab is used to set environment variables when using dbstart / dbstop or your own DB startup / stops scripts to handle boot / reboots of the server.

         Delphix has a feature for auto restart of a vdb for this specific purpose but in my experience best to list all databases in oratab whether they are all physical, all virtual or a blend of both.  Since the Y and N flags are meaningful, one workaround maybe to put the letter V for VDB and allow Delphix to handle the auto startup when it detects the server was offline.

         Once consideration, in my experience, is there maybe routine maintenance on the OS or DB binaries itself where you do not want the VDBs to constantly auto start and would need to disable the VDBs beforehand and re-enable after.  Your own start / stop scripts could also have the logic to handle Y / N / V and treat everything the same.

    Hope this helps!

    Robert Henning
    Principal Solutions Engineer