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
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
