VDB Config Templates

OBI does not support inbuilt VDB Config Templates. As an alternate approach, there are 2 ways to define init.ora parameters for OBI dSource / VDB.

Method 1

During dSource or VDB Creation, Click on Add button of “Customize init.ora parameters (Only generic parameters)” section and provide parameter name and value for the parameter. Multiple parameters can be added by clicking on Add button.

Screenshot

Only generic parameters can be specified here. Does not allow parameters with “/” in it name or value.

Method 2

During VDB Creation, Provide location of file which consists of init.ora parameters.

Screenshot

This file should reside on the VDB host and be accessible by Delphix users. You can specify multiple parameters in this file. There should be only 1 parameter on each line. The format of the parameter and value is as below (sample content)

sga_max_size=3G  
sga_target=2G  
*.pga_aggregate_target=1G

Please make sure, every parameter is in the format of NAME=VALUE and only 1 file can be specified here.

Note: Once the VDB is created, any changes in this parameter file are not reflected until the VDB is refreshed. You can make required parameter changes manually in pfile→spfile without a refreshing database. It is always recommended to make changes in both spfile and GUI parameter configuration settings to maintain continuity of the parameters.