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

  • 0
  • 1
  • Question
  • Updated 12 months ago
  • Answered
How to modify the initialization parameter value of a VDB(Oracle) in the Delphix Engine configuration after provisioning the VDB ?
Photo of Madhusudhan Malepati Rao

Posted 12 months ago

  • 0
  • 1
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb
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 
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.
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb
Yep that it :)