DMK Oracle
release_2.2.0
release_2.2.0
  • Introduction
  • Release 2 note
  • ⚙️Installation and configuration
    • Installation & Upgrade & De-installation (Unix)
    • Installation & Upgrade & De-installation (Windows)
    • Functionalities & Features
    • Advanced Configuration
    • Variables and aliases
    • Migration to DMK
  • 🗄️Structure
    • Structure
    • Oracle Grid Infrastructure & DMK
    • Oracle Database Multitenant – DMK features
  • 📃Scripts
    • Status script
    • O.S Start/Stop script integration
      • O.S Start/Stop script integration until Red Hat/Oracle Linux 6
      • O.S Start/Stop script integration since Red Hat/Oracle Linux 7
    • dmk.sh / dmk-core.pl
    • service_start_stop.ksh
    • database.ksh
    • db_crs.ksh
    • listener.ksh
    • listener_vcs.ksh
    • fsdisc.ksh
    • emctlagent.ksh
    • emctlgrid.ksh
    • opmnctl.ksh
    • goldengate.ksh
    • dgobserver.ksh
    • version.ksh|version
    • housekeeping.{ksh|cmd }
    • odiagentctl.{ksh}
    • Libraries
      • DMK_ENV.pm
      • DMK_STATUS.pm
  • ℹ️Appendix
  • 🧩Extension
    • dmk_dbbackup
      • Introduction
      • Release notes
      • Installation
      • Functionalities & Features
      • Structure
      • dmk_rman.{ksh|cmd}
      • dmk_dtpump.{ksh|cmd}
      • dmk_backup_report.{ksh|cmd}
      • Appendix
    • dmk_dbcreate
      • Introduction
      • Release notes
      • Installation & Upgrade & De-Installation
      • Functionalities & Features
      • Database creation
      • Structure
      • Bug fix :DMK-14-10 and Oracle 12c
      • Appendix
    • dmk_dbduplicate
      • Introduction
      • Release notes
      • Installation & Upgrade & De-Installation
      • Functionalities & Features
      • Database duplicates/clones
      • Structure
      • Scheduling
      • Example
      • Appendix
    • dmk_ha
      • Introduction
      • Release notes
      • Installation & Upgrade & De-Installation
      • Functionalities & Features
      • Structure
      • Scripts
      • Data Guard : archivelog management strategy (Oracle 10g/11g)
      • Data Guard monitoring
      • DMK_HA virtual IP solution for Unix/Linux
      • DMK_HA virtual IP solution for Microsoft Windows
      • Oracle GoldenGate with Oracle Active Data Guard
      • Appendix
    • dmk_sql
      • Introduction
      • Installation & Upgrade & De-installation
      • Functionalities & Features
      • Structure
      • References
      • Scripts
      • Generate Report
      • Search
  • 📄OFA
    • Introduction
    • OFA Naming guidelines
    • OFA directory structure
Powered by GitBook
On this page
  • Installation
  • Prerequisites
  • Software extraction
  • Install
  • Upgrade
  • De-installation
  1. Extension
  2. dmk_sql

Installation & Upgrade & De-installation

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

PreviousIntroductionNextFunctionalities & Features

Last updated 5 months ago

Installation

This paragraph describes the installation.

Prerequisites

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

The DMK_SQL doesn’t require any specific action. It can be installed regardless of DMK.

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:

  • “/u00/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_SQL}
/u00/app/oracle/local/dmk_sql

Your shell automatically expands the SQLPATH variable with the DMK_SQL scripts.

Enjoy!

Upgrade

dbi services recommend to perform a backup of your DMKSQL 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_SQL as explained in chapter 3.1.3 Install

That’s it!

De-installation

This paragraph describes the de-installation of the DMK_HA toolkit.

rm -rf $DMK_SQL
Remove-Item $DMK_SQL

For Linux:

For Windows

🧩