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
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="<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.
Remove-Item $DMK_DBCREATE
