Delphix Products

We need to start an Oracle  VDB using Large pages.
We used a template to modify the configuration of the VDB
We tried to set
ORACLE_SGA_PGSZ=16m
in  delphix/.profile and in  /etc/environment.
VDB starts but Large pages are not used when provisioning VDB from the GUI.
If we shutdown immediate and restart the VDB with delphix user, Large pages are used.

Where is the best place to set ORACLE_SGA_PGSZ variable so it can be used by delphix user when Delphix engine  starts the VDB ?.

Marie,

Currently there is no option available to pass on the environmental variables to the Delphix VDB startup scripts. As you discovered already, the workaround is to bounce the database again to start up with the environment variables needed. There is a Delphix product request for enhancement on this without needing the workaround described above. Please let us know if the workaround is ok for the time being or not.

Thanks,
Phani

Hi Phani,

Thanks for your answer.
Maybe this workaround would be ok for my prospect but I would like to find a better one if I could.

If Delphix runs a non interactive shell, maybe can we try to set a BASH_ENV  that defines a file where we can set the environment variables we need.
What do you think ?

Thanks,
Marie

Marie,

Unfortunately, the only workaround at this time is to (re)start the database manually. The other workaround(using BASH_ENV) that you have mentioned will require changes on the Delphix side so that the scripts(non-interactive shell) used for starting the database will set the BASH_ENV variable. It is a possible solution for the Delphix enhancement that I had mentioned in the previous update. But there are ssh configurations where setting User level environment variables is prohibited over ssh and hence the above approach will not work there. Delphix Engineering is looking into a solution for this but there is no timeline yet on when this will be available though.

Hope that answers your question and please do not hesitate to get back to me if you need further clarifications.

Thanks,
Phani

 Phani,
It's very clear now.
Thanks you for your answer.

Marie