2 Introduction to Oracle Communications Data Model Installation

Describes how to install Oracle Communications Data Model and other components you use to create an Oracle Communications Data Model data warehouse.

Using the Oracle Universal Installer you can perform different types of Oracle Communications Data Model installation.

Types of Installations Provided for Oracle Communications Data Model

Specifies the types of installation you can perform with the Oracle Communications Data Model installer.

Using the Oracle Universal Installer you can perform two types of Oracle Communications Data Model installation:

  • Installation of the Oracle Communications Data Model component. You must install this component to create an Oracle Communications Data Model data warehouse.

  • Installation of reports and schemas that you can use for ideas about how to design your own reports. Installing the reports is optional.

Different items are installed depending on whether you install the database objects or the reports.

Communications Data Model Installation

When you perform a Communications Data Model installation of Oracle Communications Data Model, the Oracle Universal Installer installs the Oracle Communications Data Model component without data. Specifically, the installer creates the following schema in the target database:

  • ocdm_sys which is the main schema for Oracle Communications Data Model. This schema contains all the relational and OLAP components of Oracle Communications Data Model, including the Oracle Communications Data Model data mining tables. This schema also contains all the mining components of Oracle Communications Data Model.

See Also:

For detailed information about all created objects in the ocdm_sys schema, see the Oracle Communications Data Model Reference.

There is no data in this schema. You need to populate data into the schema.

Sample Reports Installation

When you perform a Sample Reports installation of the Oracle Communications Data Model, the installer creates the Oracle Communications Data Model sample schema in the target database. Specifically, the installer installs:

  • The following files that provide the data for the reports:

    • ocdm_sample.dmp.zip which is a dump file of the schemas that contain the sample data for the relational and data mining components of Oracle Communications Data Model.

      Tip:

      The default user name for the schema is ocdm_sample.

  • The following files that define and create the sample reports:

    • ocdm.rpd

    • ocdmwebcat.zip

Oracle Communications Data Model Home Directory Structure

The installation image contains the following directories under ORACLE_HOME/ocdm:

  • adons: when you install Add-ons, this directory contains the files required for the selected optional adapters or analytics subproducts.

  • report: which contains the sample report files for Oracle Communications Data Model installation.

  • utl : which contains metadata and TM Forum KPI information. The TM Forum provides business-critical industry standards and expertise to enable the creation, delivery, and monetization of digital services. For more information on TM Forum, see

    http://www.tmforum.org/

  • pdm: which contains the physical schema dump, creation scripts, and lookup value population in subdirectories:


Table 2-1 PDM directory subdirectories

Subdirectory Description

relational

Relational schema installation scripts and relational related files

relational/ddl/ocdm/calendar

Calendar data population package

relational/ddl

Relational schema installation scripts

relational/flexible_hierarchy

Flexible hierarchy scripts

relational//ddl/ocdm/intra_etl

Intra-ETL and related files

relational/sample_schema

Physical sample schema

mining

Data mining scripts and related files

olap

OLAP scripts and related files


Overview of the Installation Process

Provides an overview of the installation steps, including preinstallation tasks, running the installer, and postinstallation tasks.

  1. Read Oracle Communications Data Model Release Notes to identify any last minute changes.

  2. Verify that your system is one of the supported platforms and that it satisfies the hardware and software requirements as described in Hardware and Software Requirements.

  3. Identify and perform any necessary preinstallation tasks, as described in Preinstallation Tasks.

  4. Install the Oracle Communications Data Model component or the Oracle Communications Data Model reports as described in Running the Installer.

    Tip:

    You can also perform a silent installation, see Installing Using a Silent Installation for more information.

  5. Identify and perform any necessary postinstallation tasks, as described in PostInstallation Tasks.

  6. Install the additional components that you need to create an Oracle Communications Data Model data warehouse or run the reports, as described in Installation of Additional Components

Note:

To deinstall Oracle Communications Data Model, follow the directions in Backup Recovery and Deinstallation of Oracle Communications Data Model.

Note:

You must deinstall Oracle Communications Data Model before you reinstall it over an existing version of Oracle Communications Data Model.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Postinstallation Tasks

Describes the postinstallation tasks that you perform after you install Oracle Communications Data Model, as appropriate for your particular installation.

After you install Oracle Communications Data Model, perform the following steps as appropriate for your particular installation:

After performing these tasks, install other components that are required for your particular Oracle Communications Data Model warehouse, as described in .Installation of Additional Components

Preinstallation Tasks

Describes the preinstallation tasks.

Before you install the Oracle Communications Data Model, perform the following tasks:

  • Back up the Oracle Database.

  • Perform the preinstallation steps:

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 2-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' ;