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

Describes the deinstallation steps for Oracle Communications Data Model.

Includes information on backing up and recovering Oracle Communications Data Model and steps for deinstalling.

Backing Up and Recovering Oracle Communications Data Model

Backing up and recovering Oracle Communications Data Model involves:

Exporting Oracle Communications Data Model

Do the following to backup Oracle Communications Data Model:

  • Backup the OCDM_SYS schema by executing the expdp utility.

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

Importing Oracle Communications Data Model

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

  • Restore the OCDM_SYS schema by executing the impdp utility.

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

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 "Performing Predeinstallation Tasks".

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

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

    Note:

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

Performing Predeinstallation Tasks

The deinstallation script removes the ocdm_sys schema. Consequently, before you run the deinstallation script, ensure that there are no active sessions that connect to the ocdm_sys schema.

Identifying if the ocdm_sys schema is active

To identify if there are active sessions connecting to the schema 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'; 
    

If this query returns a session ID, then there is an active session.

Example 5-1 Ending an active ocdm_sys schema session

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

alter system kill session 'sid,serial' ;

Running the Deinstallation Script

Describes the steps to run 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/dbhome

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

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

    In a C shell, use this command to set ORACLE_HOME

    % setenv ORACLE_HOME /loc/app/oracle/product/dbhome
    
  2. Execute the Oracle Communications Data Model deinstallation script:

    $ORACLE_HOME/ocdm/ocdm_deinstall.sh

  3. When prompted, enter the SYSTEM password.

    The script deconfigures 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 "Performing Post-Deinstallation Tasks".

Performing 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/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository.
  2. Delete the ocdmwebcat folder in BIHome/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog.
  3. Delete the following line from BIHome/instances/instance1/config/OracleBIServerComponent/coreapplication_obis1/NQSConfig.INI:
    Star    =    ocdm.rpd, DEFAULT