> For the complete documentation index, see [llms.txt](https://dbi-services.gitbook.io/dmk-oracle-manual/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dbi-services.gitbook.io/dmk-oracle-manual/extension/dmk_dbcreate/installation-and-upgrade-and-de-installation.md).

# Installation & Upgrade & De-Installation

## Installation

This paragraph describes the installation

### Prerequisites

This paragraph describes all necessary steps which must be completed before you start the DMK\_DBCREATE installation.

* a successful installation of DMK as it’s the root component of DMK\_DBCREATE

### Software extraction

Based on the dbi services and OFA (Oracle Flexible Architecture) best practices extract the archive under ${ORACLE\_BASE}/local, as explained below: <img src="/files/38iIXM3MfVYJbuIZXx9a" alt="" data-size="line">

```
gzip --decompress dmk-xx-xx-xxxx.tar.gz
tar -xvf dmk-xx-xx-xxxx.tar
```

Typically, ${ORACLE\_BASE} match:

* “/u01/app/oracle ” on Linux/Unix
* “D:\oracle”on Microsoft Windows systems

### Install

To complete the installation you just need to re-source DMK. This can be either achieved by

* <img src="/files/gXXzRxYH3XRlL6WzINTZ" alt="" data-size="line"> restarting the PowerShell Console
* <img src="/files/PinApbQDlYP33rBp49eq" alt="" data-size="line"> sourcing DMK within your shell (alias dmk)

```
oracle@vmoraoel:/home/oracle/ [rdbms11202] dmk
oracle@vmoraoel:/home/oracle/ [rdbms11202] echo ${DMK_DBCREATE}
/u01/app/oracle/local/dmk_dbcreate
```

*Enjoy!*

### Upgrade

dbi services recommend to perform a backup of your DMK\_DBCREATE package before upgrading.

The upgrade process is similar to the installation except that the prerequisites are already fulfilled:

* Extract the software as explained in chapter 3.1.2 Software extraction
* Install DMK as explained in chapter 3.1.3 Install

:warning:**Upgrades of versions prior to the 12-10 require a reinstallation.**

That’s it!

### Upgrades of DBCA Templates

To use DBCA Templates from previous version the following has to be modified:

* In the header now the template version is specified under description:

```
<DatabaseTemplate name="dbi_template_Unix_asm_19" description="Template Version 19-09" version="19.3.0.0.0">
```

* Disabled Autoextend for the UNDOTBS1 tablespace and instead increased the allocation size:(modified values marked yellow)

```
<DatafileAttributes id="&lt;OMF_UNDOTBS1_DATAFILE_0>">
 <tablespace>UNDOTBS1</tablespace>
 <temporary>false</temporary>
 <online>true</online>
 <status>0</status>
 <size unit="MB">2048</size>
 <reuse>true</reuse>
 <autoExtend>false</autoExtend>
 <increment unit="KB">5120</increment>
 <maxSize unit="MB">2048</maxSize>
</DatafileAttributes>
```

* Added the following Oracle parameters:

```
<initParam name="archive_lag_target" value="1200"/>
<initParam name="audit_trail" value="DB"/>
<initParam name="control_file_record_keep_time" value="35"/>
<initParam name="db_files" value="1022"/>
```

* This DBCA template upgrade is now done automatically:

```
Upgrading DBCA template from version 00-00 to latest template version 19-09:
 - Backup Template to /u01/app/oracle/local/dmk_dbcreate/templates/dbca/database/dbi_template_fs_18_00-00.bak ...
 - Upgrading Template /u01/app/oracle/local/dmk_dbcreate/templates/dbca/database/dbi_template_fs_18.dbt ...
 - DONE
 - Below you'll find a simple file differences report:
--------------------------------------------------------------------------------------------------------------
file difference between:
- /u01/app/oracle/local/dmk_dbcreate/templates/dbca/database/dbi_template_fs_18_00-00.bak
+ /u01/app/oracle/local/dmk_dbcreate/templates/dbca/database/dbi_template_fs_18.dbt
--------------------------------------------------------------------------------------------------------------
- <DatabaseTemplate name="dbi_template_Unix_fs_18" description="" version="18.3.0.0.0">
+ <DatabaseTemplate name="dbi_template_Unix_fs_18" description="Template Version 19-09" version="18.3.0.0.0">
+ <initParam name="archive_lag_target" value="1200"/>
+ <initParam name="audit_trail" value="DB"/>
+ <initParam name="control_file_record_keep_time" value="35"/>
+ <initParam name="db_files" value="1022"/>
- <size unit="MB">1024</size>
+ <size unit="MB">2048</size>
- <autoExtend>true</autoExtend>
+ <autoExtend>false</autoExtend>
--------------------------------------------------------------------------------------------------------------
2019-11-11_16-47-44::dmk_dbcreate.pl::dmk_dbcreate.pl ::INFO ==> All scripts will be created in
/opt/oracle/admin/DB18/create with ORACLE_HOME=/opt/oracle/product/18c/dbhome_1
Do you want to continue=[Y/N]:
```

### Upgrade of Database Templates

To use Database Templates from the previous version the following has to be done:

* Add parameter AUDIT\_RETENTION\_DAYS = 31

## De-installation

This paragraph describes the de-installation of the DMK\_ DBCREATE toolkit.

<img src="/files/PinApbQDlYP33rBp49eq" alt="" data-size="line">For Linux:

```
rm -rf $DMK_DBCREATE
```

<img src="/files/gXXzRxYH3XRlL6WzINTZ" alt="" data-size="line"> For Windows:

```
Remove-Item $DMK_DBCREATE
```