Delphix Products

Back to discussions
Expand all | Collapse all

Initialization parameter change of a VDB (Oracle) in Delphix Engine

  • 1.  Initialization parameter change of a VDB (Oracle) in Delphix Engine

    Posted 05-24-2017 01:31:00 PM
    How to modify the initialization parameter value of a VDB(Oracle) in the Delphix Engine configuration after provisioning the VDB ?

    #Virtualization


  • 2.  RE: Initialization parameter change of a VDB (Oracle) in Delphix Engine
    Best Answer

    Posted 05-24-2017 01:43:00 PM
    Hi,

    If you have used a config template, it only gets used during Provision or Refresh. If you want to change any Oracle parameters in a VDB with no donfig template, just do it via sqlplus/spfile/etc as you would for a non-Delphix database or use a hooks with the alter command or better assign a new template to it via CLI https://docs.delphix.com/docs/delphix-administration/oracle-environments-and-data-sources/provisioni....

    Regards,

    Mouhssine 





  • 3.  RE: Initialization parameter change of a VDB (Oracle) in Delphix Engine

    Posted 05-24-2017 02:15:00 PM
    Hi Mouhssine,

    Thank you for your update.

    I found a solution using CLI method that we can change the init parameter file in DE and able to complete the change in DE and it will be effective after the VDB refresh only.

    Below are the steps followed and it worked fine.

    login to DE CLI as delphix_admin

    source "db_name"

    update

    set configParams.<name>=<value> 

    commit

    Regards,
    Madhusudhan Rao.


  • 4.  RE: Initialization parameter change of a VDB (Oracle) in Delphix Engine

    Posted 05-24-2017 02:18:00 PM
    Yep that it :)