Skip Headers

Oracle® Communications Data Model Installation Guide 11g Release 2 (11.2) Part Number E15887-08 |
Home | Book List | Contents | Index | Contact Us

Previous | Next
| PDF · Mobi · ePub

# 5 Backup, Recovery, and Deinstallation of Oracle Communications Data Model

This chapter explains how to deinstall Oracle Communications Data Model:

- Backing Up and Recovering Oracle Communications Data Model

- Pre-Deinstallation Tasks

- Deinstallation Script Execution

- Post-Deinstallation Tasks

## Backing Up and Recovering Oracle Communications Data Model

Backing up and recovering Oracle Communications Data Model involves a two-step process to 1) backup or recover the relational objects, and 2) backup or recover the analytic workspace that is part of Oracle Communications Data Model. These steps are outlined in the following topics:

- Exporting Oracle Communications Data Model

- Importing Oracle Communications Data Model

### Exporting Oracle Communications Data Model

Take the following steps to backup Oracle Communications Data Model:

1. Backup the `OCDM_SYS` and `OCDM_MINING` schemas by executing the `expdp` utility.

   This utility exports all physical tables containing the data and trained mining models. For more information, see Oracle Database Utilities.

2. Backup the analytic workspace that is part of the Oracle Communications Data Model. The analytic workspace is backed up as an EIF file, named `OCDM_BAK.EIF`, which is generated under the `ORACLE_HOME``/ocdm/pdm/olap` directory.

   1. Connect to the Database with `ocdm_sys`.

   2. Issue the following SQL statements.

          exec dbms_aw.execute('AW ATTACH OCDM');
          exec dbms_aw.execute('CDA OCDM_OLAP_DIR');
          exec dbms_aw.execute('EXPORT ALL TO EIF FILE ', 'OCDM_BAK.EIF', ' NOTEMPDATA');
          exec dbms_aw.execute('AW DETACH OCDM');

### Importing Oracle Communications Data Model

Take the following steps to restore Oracle Communications Data Model from the backup files:

1. Restore the `OCDM_SYS` and `OCDM_MINING` schemas by executing the `impdp` utility.

   This utility imports all physical tables containing the data and trained mining models. For more information, see Oracle Database Utilities.

2. Connect to the Database with `ocdm_sys`, and import the analytic workspace that was saved as an EIF file, named `OCDM_BAK.EIF`, under the `ORACLE_HOME``/ocdm/pdm/olap` directory.

       exec dbms_aw.execute('IMPORT ALL TO EIF FILE ','OCDM_BAK.EIF');

## Overview: Deinstalling Oracle Communications Data Model

To deinstall Oracle Communications Data Model, you do not simply run Oracle Universal Installer in deinstall mode. Instead, you perform the following tasks:

1. Backup Oracle Communications Data Model, as described in "Exporting Oracle Communications Data Model".

2. Stop any sessions that use the Oracle Communications Data Model schemas, as described in "Pre-Deinstallation Tasks".

3. Execute the deinstallation script, as described in "Deinstallation Script Execution".

4. If you are deinstalling the sample reports, perform the tasks described in "Post-Deinstallation Tasks".

   Note:

   To deinstall Oracle Communications Data Model, you do not simply run the Oracle Universal Installer in deinstall mode.

## Pre-Deinstallation Tasks

The deinstallation script removes the `ocdm_sys` and `ocdm_mining` schemas. Consequently, before you run the deinstallation script, ensure that there are no active sessions that connect to either the `ocdm_sys` schema or the `ocdm_mining` schema.

Identifying if the ocdm_sys or ocdm_mining schemas are active

To identify if there are active sessions connecting to these schemas take the following steps:

1. Sign in as DBA.

2. Execute the following SQL statements:

       select SID,SERIAL# from v$session where USERNAME='OCDM_SYS';
       select SID,SERIAL# from v$session where USERNAME='OCDM_MINING';

If either of these queries returns a session ID, then there is an active session.

Ending an active ocdm_sys or ocdm_mining schema session

To end an active session, execute the following statements in which you replace `sid` and `serial` are the session ID and serial number returned by the earlier queries.

    alter system kill session 'sid,serial' ;

## Deinstallation Script Execution

To execute the Oracle Communications Data Model deinstallation script:

1. Set the ORACLE_HOME to the location of the Database on which to deinstall Oracle Communications Data Model.

   For example, suppose that Oracle Home is in the directory `/loc/app/oracle/product/11.2.4/`

   In a Bourne, Bash, or Korn shell, use these commands to set ORACLE_HOME:

       $ ORACLE_HOME=/loc/app/oracle/product/11.2.4/
       $ export ORACLE_HOME

   In a C shell, use this command to set ORACLE_HOME

       % setenv ORACLE_HOME /loc/app/oracle/product/11.2.4/

2. Execute the Oracle Communications Data Model deinstallation script:

   `$ORACLE_HOME/ocdm/ocdm_deinstall.sh`

3. When prompted, enter the SYSTEM password.

   The script de-configures Oracle Communications Data Model and executes the Oracle Universal Installer in deinstall silent mode.

If you are deinstalling the sample reports, after the deinstallation script runs, perform the tasks described in "Post-Deinstallation Tasks".

## Post-Deinstallation Tasks

If you are deinstalling the Oracle Communications Data Model sample reports, follow these steps to perform additional cleanup:

1. Delete `ocdm.rpd` in the directory `BIHome``/Server/Repository`.

2. Delete the `ocdmwebcat` folder in `BIDataHome``/web/catalog`.

3. Delete the following line from `BIHome``/Server/Config/NQSConfig.INI`:

       Star    =    ocdm.rpd, DEFAULT