This topic describes how to customize Oracle and Oracle RAC virtual database (VDB) configuration settings, including settings that the Delphix Engine reserves and those that it removes from the database configuration file during the provisioning process.
When a VDB is provisioned in the browser, you can specify configuration parameters directly or copy them from a VDB Configuration Template. Once set, the Delphix Engine will use these parameters whenever the VDB is refreshed, even if you change the original template. With the command line interface (CLI), you can store a reference to the template with the VDB instead of copying the values. When using a template reference, subsequent refreshes will use the configuration settings from the template. In this case, changes to a template will appear in any VDBs when they are refreshed. If you delete a template while VDBs still refer to it, the template property will be unset for those VDBs and the current settings will be used when refreshed in the future.
It is important to know, however, that some configuration parameters cannot be customized. In addition, some configuration parameters are stripped out during the provisioning process but are customizable. The list of restricted and customizable parameters can be found below.
Creating a VDB Config Template
- Login to the Delphix Admin application using Delphix Admin credentials.
- Click Manage.
- Select VDB Config Templates. This opens the VDB Configuration Template Manager.
- Click the green Plus icon to add a parameter.
- Enter the name and value for the parameter.
- Repeat steps 4 and 5 for each parameter you want to add to the template.
- When you are done adding parameters, click Save Template.
Building Templates from Other Templates
- Open the VDB Configuration Template Manager, and then select a template.
- Click Create New Template.
- Enter a name for the template.
- Click OK.
A new template is created with the parameters from the selected template. You can now edit or add parameters as necessary. - Click Save Template.
Applying a VDB Config Template
You can apply a VDB Config Template to a VDB during the provisioning process. As described in the introduction, this copies the values from the template. Any subsequent changes to the template will not appear in the VDB, even when that VDB is refreshed.
- In the Target Environment screen of the Provision VDB wizard, click Advanced.
- From the VDB Configuration Templates table select a template.
- Click Next.
Dynamically Template Parameters on Refresh (CLI Only)
Select the target source.
delphix> source select vexampleUpdate the source.
delphix source "vexample"> updateSet the
configTemplateproperty using the name of your desired template.delphix source "vexample" update *> set configTemplate=ExampleTemplateCommit the result.
delphix source "vexample" update *> commit
You can also set the template reference during provisioning. See the CLI Cookbook: Provisioning a Single Instance Oracle VDB topic for more information.
Video
Restricted Parameters
These parameters are restricted for use by the Delphix Engine. Attempting to customize these parameters through the use of a VDB Config Template will cause an error during the provisioning process.
active_instance_countcluster_databasecluster_database_instancescluster_interconnectscontrol_filesdb_block_sizedb_create_file_destdb_create_online_log_dest_1db_create_online_log_dest_2db_create_online_log_dest_3db_create_online_log_dest_4db_create_online_log_dest_5db_file_name_convertdb_namedb_recovery_file_destdb_recovery_file_dest_sizedb_unique_namedg_broker_config_file1dg_broker_config_file2dg_broker_startfal_clientfal_serverinstance_nameinstance_numberlocal_listenerlog_archive_configlog_archive_destlog_archive_duplex_destlog_file_name_convertspfilestandby_archive_deststandby_file_managementthreadundo_tablespace__db_cache_size__java_pool_size__large_pool_size__oracle_base__pga_aggregate__sga_target__shared_io_pool_size__shared_pool_size__streams_pool_size
Customizable Parameters
The default value for these parameters is cleared during the provisioning process. They are removed from the VDB configuration file unless you set values for them through a VDB Config Template.
audit_file_destaudit_sys_operationsaudit_trailbackground_dump_destcore_dump_destdb_domaindiagnostic_destdispatchersfast_start_mttr_targetlog_archive_dest_1log_archive_dest_2log_archive_dest_3log_archive_dest_4log_archive_dest_5log_archive_dest_6log_archive_dest_7log_archive_dest_8log_archive_dest_9log_archive_dest_10log_archive_dest_11log_archive_dest_12log_archive_dest_13log_archive_dest_14log_archive_dest_15log_archive_dest_16log_archive_dest_17log_archive_dest_18log_archive_dest_19log_archive_dest_20log_archive_dest_21log_archive_dest_22log_archive_dest_23log_archive_dest_24log_archive_dest_25log_archive_dest_26log_archive_dest_27log_archive_dest_28log_archive_dest_29log_archive_dest_30log_archive_dest_31log_archive_dest_state_1log_archive_dest_state_2log_archive_dest_state_3log_archive_dest_state_4log_archive_dest_state_5log_archive_dest_state_6log_archive_dest_state_7log_archive_dest_state_8log_archive_dest_state_9log_archive_dest_state_10log_archive_dest_state_11log_archive_dest_state_12log_archive_dest_state_13log_archive_dest_state_14log_archive_dest_state_15log_archive_dest_state_16log_archive_dest_state_17log_archive_dest_state_18log_archive_dest_state_19log_archive_dest_state_20log_archive_dest_state_21log_archive_dest_state_22log_archive_dest_state_23log_archive_dest_state_24log_archive_dest_state_25log_archive_dest_state_26log_archive_dest_state_27log_archive_dest_state_28log_archive_dest_state_29log_archive_dest_state_30log_archive_dest_state_31remote_listeneruser_dump_dest
Related Topics
- Customizing Oracle VDB Environment Variables
- Automatic VDB Restart on Target Server After Reboot
- Customizing VDB File Mappings