Installation & Upgrade & De-Installation

This chapter describes all installation/upgrade/de-installation steps.

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:

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

• restarting the PowerShell Console

• 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

⚠️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.

For Linux:

rm -rf $DMK_DBCREATE

For Windows:

Remove-Item $DMK_DBCREATE