# Standalone variables

This table describes all the fields available in the YaK and their purpose when declaring your Oracle 2.1.0 **standalone** component.

{% tabs fullWidth="true" %}
{% tab title="Basic variables" %}

<table data-full-width="true"><thead><tr><th width="205">Name</th><th width="128" data-type="checkbox">Mandatory</th><th width="236">Purpose</th><th>Example</th></tr></thead><tbody><tr><td>Version of the Oracle instance</td><td>true</td><td>Version of the release update to install.<br><br>Default value: 19_26_250121_JVM_v0</td><td>19_26_250121_JVM_v0</td></tr><tr><td>Oracle Software Edition</td><td>true</td><td>Oracle Software Edition to install (Standard Edition or Enterprise Edition).</td><td>SE2</td></tr><tr><td>Instance name (oracle_sid)</td><td>true</td><td>This is the Oracle SID.</td><td>CDB1</td></tr><tr><td>Instance unique name</td><td>true</td><td>Unique name of the database.</td><td>CDB1_SITE1</td></tr><tr><td>Domain name</td><td>true</td><td>Fully qualified name of the domain (db_domain).</td><td>example.com</td></tr><tr><td>Character Set</td><td>true</td><td>Character Set of the database.<br><br>Default value: AL32UTF8</td><td>AL32UTF8</td></tr><tr><td>National Character Set</td><td>true</td><td>National Character Set of the database.<br><br>Default value: AL16UTF16</td><td>AL16UTF16</td></tr><tr><td>RMAN connect string</td><td>true</td><td>Connect string to use for RMAN backups.<br><br>Default value: /</td><td>/</td></tr></tbody></table>

#### PDB Configuration

<table><thead><tr><th width="203">Name</th><th width="133" data-type="checkbox">Mandatory</th><th width="237">Purpose</th><th>Example</th></tr></thead><tbody><tr><td>PDB (Max. 3)</td><td>false</td><td>List of PDBs to be created. A maximum of 3 PDBs is allowed without the corresponding license and on Cloud providers other than OCI</td><td><ul><li>PDB1</li><li>PDB2</li><li>PDB3</li></ul></td></tr><tr><td>PDB Admin username</td><td>true</td><td>Admin user for all the PDBs.<br><br>Default value: PDBADMIN</td><td>JOHN</td></tr><tr><td>PDB Admin password</td><td>true</td><td>Password for the PDB admin user.<br><br>Default value: manager</td><td><h4>6CZCkjfM</h4></td></tr></tbody></table>
{% endtab %}

{% tab title="Advanced variables" %}

#### OFA

<table><thead><tr><th>Name</th><th data-type="checkbox">Mandatory</th><th width="234">Purpose</th><th>Example</th></tr></thead><tbody><tr><td>Oracle base directory</td><td>true</td><td><p>Base directory for Oracle software.</p><p></p><p>Default value: /u01/app/oracle</p></td><td>/u00/app/oracle</td></tr><tr><td>Oracle inventory directory</td><td>true</td><td>Directory for Oracle inventory (oraInventory).<br><br>Default value: /u01/app/oraInventory</td><td>/u00/app/oraIventory</td></tr><tr><td>Data files directory</td><td>true</td><td>Directory for Oracle data files.<br><br>Default value: /u02/oradata</td><td>/oradata</td></tr><tr><td>Redo log files directory</td><td>true</td><td>First location for Oracle redo log files and control file.<br><br>Default value: /u03/oradata</td><td>/u02/oradata</td></tr><tr><td>Second Redo log files directory</td><td>true</td><td>Second location for Oracle redo log files and control file (multiplexing).<br><br>Default value: /u04/oradata</td><td>/u90/fast_recovery_area</td></tr><tr><td>Fast Recovery Area (FRA) directory</td><td>true</td><td>/u90/fast_recovery_area</td><td>/u99/fra</td></tr></tbody></table>

#### TNS configuration

<table><thead><tr><th>Name</th><th data-type="checkbox">Mandatory</th><th width="234">Purpose</th><th>Example</th></tr></thead><tbody><tr><td>Default domain for TNS alias</td><td>false</td><td>Domain name to use in TNS alias.<br><br>By default, db_domain will be used.</td><td>example.com</td></tr><tr><td>Hostname for TNS alias</td><td>true</td><td>Hostname to use in TNS alias.<br><br>Default value: localhost</td><td>localhost</td></tr><tr><td>Protocol for TNS alias</td><td>true</td><td>Protocol to use in TNS alias.<br><br>Default value: TCP</td><td>TCP</td></tr><tr><td>Port for TNS alias</td><td>true</td><td>Port to use in TNS alias.<br><br>Default value: 1521</td><td>1521</td></tr></tbody></table>

#### SQL\*NET configuration

<table><thead><tr><th>Name</th><th data-type="checkbox">Mandatory</th><th width="234">Purpose</th><th>Example</th></tr></thead><tbody><tr><td>SQL*Net default domain</td><td>false</td><td>Domain name to append to any unqualified service name (usually same as db_domain).<br><br>By default, db_domain will be used.</td><td>example.com</td></tr><tr><td>SQL*Net server side encryption (SQLNET.ENCRYPTION_SERVER)</td><td>true</td><td>Enable server side encryption.<br><br>Default value: TRUE</td><td>N/A</td></tr><tr><td>SQL*Net client side encryption (SQLNET.ENCRYPTION_CLIENT)</td><td>true</td><td>Enable client side encryption.<br><br>Default value: TRUE</td><td>N/A</td></tr><tr><td>SQL*Net server side crypto checksum (SQLNET.CRYPTO_CHECKSUM_SERVER)</td><td>true</td><td>Enable server side crypto checksum.<br><br>Default value: TRUE</td><td>N/A</td></tr><tr><td>SQL*Net client side crypto checksum (SQLNET.CRYPTO_CHECKSUM_CLIENT)</td><td>true</td><td>Enable client side crypto checksum.<br><br>Default value: TRUE</td><td>N/A</td></tr></tbody></table>

### Listener configuration

<table><thead><tr><th width="154">Name</th><th data-type="checkbox">Mandatory</th><th width="234">Purpose</th><th>Example</th></tr></thead><tbody><tr><td>Listener name</td><td>true</td><td>Name of the Oracle Listener (usually 'LISTENER' for the first Listener).<br><br>Default value: LISTENER</td><td>LISTENER</td></tr><tr><td>Listener hostname FQDN</td><td>false</td><td>Hostname to set in the Oracle Listener.<br><br>By default, the hostname of the server will be used.</td><td>linux_srv.example.com</td></tr><tr><td>Listener protocol</td><td>true</td><td>Listener port protocol to use.<br><br>Default value: TCP</td><td>TCP</td></tr><tr><td>Listener port</td><td>true</td><td>Listener port to use.<br><br>Default value: 1521</td><td>1521</td></tr></tbody></table>

### RMAN backups notifications

<table><thead><tr><th width="154">Name</th><th data-type="checkbox">Mandatory</th><th width="234">Purpose</th><th>Example</th></tr></thead><tbody><tr><td>SMTP Server</td><td>false</td><td>IP or Hostname of the SMTP server or relay host dmk_dbbackup notifications.</td><td>smtp_server.example.com</td></tr><tr><td>Mail from</td><td>false</td><td>Email address from which the notifications are send.</td><td>oracle_server@example.com</td></tr><tr><td>Mail to</td><td>false</td><td>Comma separated list of email addresses to which the notifications are send.</td><td>dba@example.com, infra@example.com, admin@example.com</td></tr><tr><td>Mail subject prefix</td><td>false</td><td>Prefix to use for the mail subject.</td><td>dbi</td></tr><tr><td>Send notification on failure only</td><td>false</td><td>0 : always send notifications<br><br>1 : send notifications on failure only</td><td>1</td></tr></tbody></table>
{% endtab %}

{% tab title="Features variables" %}

### Deploy A New Oracle Single Instance

<table><thead><tr><th width="154">Name</th><th data-type="checkbox">Mandatory</th><th width="234">Purpose</th><th>Example</th></tr></thead><tbody><tr><td>Golden Image (optional)</td><td>false</td><td><p>This is the golden image that will be used to install the Oracle binaries. It must be same version as the version of Oracle defined in the component.</p><p></p><p>The golden image must be located in the artifact repository and the full path must be specified. If not specified, the base release 19.3 will be used. </p></td><td>rdbms/oracle/gold_images/19c/LINUX.X64_19_21_231017_JVM_v0_db_home.zip</td></tr></tbody></table>

### Patch An Existing Oracle Single Instance

<table><thead><tr><th width="154">Name</th><th data-type="checkbox">Mandatory</th><th width="234">Purpose</th><th>Example</th></tr></thead><tbody><tr><td>Oracle version</td><td>true</td><td>Target version to upgrade the Oracle database to.<br><br>Default value: 19_26_250121_JVM_v0</td><td>19_26_250121_JVM_v0</td></tr><tr><td>Golden Image (optional)</td><td>false</td><td><p>This is the golden image that will be used to install the Oracle binaries. It must be same version as the version of Oracle selected above.</p><p></p><p>The golden image must be located in the artifact repository and the full path must be specified. If not specified, the base release 19.3 will be used. </p></td><td>rdbms/oracle/gold_images/19c/LINUX.X64_19_21_231017_JVM_v0_db_home.zip</td></tr><tr><td>Version to remove</td><td>false</td><td>Version of the Oracle home to remove after the patching is done. The home should not be removed if there are still databases assigned to it.</td><td>19_25_241015_JVM_v0</td></tr><tr><td>Force patching (AT YOUR OWN RISKS)</td><td>true</td><td>By default the patching will fail if there are invalid SYS or SYSTEM objects. Checking this checkbox will allow the patching even if there are invalid SYS/SYSTEM objects.<br><br>Default value:<br>FALSE</td><td>N/A</td></tr></tbody></table>
{% endtab %}
{% endtabs %}