6 Installing Oracle Communications Data Model on Oracle Cloud

Describes how to install Oracle Communications Data Model on Oracle Cloud.

Installing Oracle Communications Data Model on Oracle Cloud

To install Oracle Communications Data Model on Oracle Cloud, use the Oracle Database Cloud Service and the Oracle Business Intelligence Cloud Service.

See the following to obtain the required cloud services: http://docs.oracle.com/cloud/latest/trial_paid_subscriptions/index.html.

After the Oracle Cloud subscriptions are processed and the Oracle Cloud account is set up, you deploy Oracle Communications Data Model on Oracle Cloud.

Oracle Database Cloud Service Requirements

Installing Oracle Communications Data Model on Oracle Cloud requires a correctly configured Oracle Database Cloud Service instance.

Creating a Secure Shell (SSH) Public/Private Key Pair

Create an SSH key pair with a public key and a private key to access the Oracle Database Cloud Service instance.

The SSH public key is used when you request the Oracle Database Cloud Service instance. After the Oracle Database Cloud Service instance is created you can access the instance by authenticating with the SSH private key.
  1. By default, network access to the compute nodes associated with Oracle Database Cloud - Database as a Service is provided by Secure Shell (SSH). The first step to access the network is to create an SSH key pair.

See Also:

For more information, see Generating a Secure Shell (SSH) Public/Private Key Pair

Creating the Oracle Database Cloud Service Instance

If the subscription type allows you to create an Oracle Database Cloud Service instance, then create the Oracle Database Cloud Service instance from the Cloud My Services console.

If you are using a trial subscription, the Oracle Database Cloud Service instance is provided by Oracle and a service instance is provided in the My Services console.
  1. To create a Oracle Database Cloud Service Instance, see: Creating a Database Deployment.

Requirements for Service and Database Configuration Parameters

Specifies the service configuration and database configuration requirements for Oracle Communications Data Model installation.

Oracle Database Cloud Service Configuration

Check the following table for detailed service configuration parameter information:

Note:

There are several parameters that are mandatory for which you must provide input.

Table 6-1 Oracle Database Cloud Service Service Configuration Requirements

Parameter Name Parameter Description Mandatory/Optional Valid Values/Format

Service Name

Name of Oracle Database Cloud Service instance

Mandatory

Must not exceed 50 characters. Must start with a letter. Must contain only letters, numbers, or hyphens. Must not contain any other special characters. Must be unique within the identity domain.

Description

Free-form text that provides additional information about the service instance

Optional

No Value

Service Level

Service level for the service instance

Mandatory

Oracle Database Cloud Service

Metering Frequency

Metering frequency for chosen Service Level.

Mandatory

Hourly

Monthly

Software Release

Oracle Database software version

Mandatory

Oracle Database 12c Release 1

Software Edition

Database edition for the service instance

Mandatory

Enterprise Edition – High Performance

or

Enterprise Edition – Extreme Performance

Database Type

Database Type

Mandatory

Single Instance

Oracle Database Cloud Service Database Configuration

Note:

There are several parameters that are mandatory for which you must provide input.

Table 6-2 Oracle Database Cloud Service Database Configuration Requirements

Parameter Name Parameter Description Mandatory/Optional Default Value Valid Values/Format

DB Name (SID)

Database Name (sid) for the Database as a Service instance

Mandatory

ORCL

string

PDB Name

Pluggable Database Name for the Database as a Service instance.

Mandatory

PDB1

string

Administration Password

Password for Oracle Database administrator users sys and system.

Mandatory

No value

Starts with a letter;Between 8 and 30 characters long;Contains letters, at least one number, and optionally, any number of these special characters: dollar sign ($), pound sign (#), and underscore (_);

Usable Database Storage

Storage volume size for data. Default value is 25GB. Minimum allowed size is 15GB. Maximum allowed size is 500GB if backup destination is specified and 1000GB if no backup destination is specified.

Mandatory

25

15 to 500

Compute Shape

Desired compute shape. A shape defines the number of Oracle Compute Units (OCPUs) and amount of memory (RAM)

Mandatory

 
oc3: 1 OCPU, 7.5 GB memory

oc3: 1 OCPU, 7.5 GB memory
oc4: 2 OCPUs, 15 GB memory
oc5: 4 OCPUs, 30 GB memory
oc6: 8 OCPUs, 15 GB memory
oc1m: 1 OCPU, 15 GB memory
oc2m: 2 OCPUs, 30 GB memory
oc3m: 4 OCPUs, 60 GB memory
oc4m: 8 OCPUs, 120 GB memory

SSH Public Key

Public key for the secure shell (SSH). This key will be used for authentication when connecting to the Database as a Service instance using an SSH client. You generate an SSH public-private key pair using a standard SSH key generation tool.

Mandatory

No Value

No Value

Requirements for Backup and Recovery Configuration Parameters

Specifies the backup and recovery configuration requirements for Oracle Communications Data Model installation.

Oracle Database Cloud Service Backup and Recovery Configuration

Note:

There are several parameters that are mandatory for which you must provide input.

Table 6-3 Oracle Database Cloud Service Database Backup and Recovery Requirements

Parameter Name Parameter Description Mandatory/Optional Default Value Valid Values/Format

Backup Destination

Backup destination

Mandatory

Both Cloud Storage and Local Storage

  • Both Cloud Storage and Local Storage

  • Cloud Storage Only

  • None

Cloud Storage Container

Name of the Oracle Storage Cloud Service container used to provide storage for your service instance backups. Use the following format to specify the container name: <storageservicename>-<storageidentitydomain>/<containername>

Provide when Backup Destination is not set to None

No Value 

No Value 

Cloud Storage Username

Username for the Oracle Storage Cloud Service administrator.

Provide when Backup Destination is not set to None

No Value 

 No Value

Cloud Storage Password

Password for the Oracle Storage Cloud Service administrator

Provide when Backup Destination is not set to None

No Value 

No Value 

Create Cloud Storage Container

This item is a check box. Check this option if you want to create a new container with the information specified above.

Provide when Backup Destination is not set to None

No Value 

No Value 

Monitoring Oracle Database Cloud Service Status

After the Oracle Database Cloud Service request is accepted, you can monitor the status of the Oracle Database Cloud Service instance.

To monitor the status of the Oracle Database Cloud Service instance view the console (https://dbaas.oraclecloud.com/dbaas).
  1. The following figure shows the Oracle Database Cloud Service instance creation with status “In Progress”:

    It takes about 20 minutes to create the Oracle Database Cloud Service instance.

  2. Click the service name to show the details of the service such as Public IP, SQL *NetPort, SID, PDB Name, Connect String. The following figure shows details for OCDM-Product Oracle Database Cloud Service instance:

Related Topics

Install Oracle Communications Data Model on Oracle Cloud

Install Oracle Communications Data Model on Oracle Database Cloud Service after you complete the configuration. Oracle Communications Data Model shiphome for the on-premise install is the same as the Cloud version.

Connect to Oracle Database Cloud Service VM

Connect to the Oracle Database Cloud Service VM.

  1. From a Linux machine, connect to the existing Oracle Database Cloud Service instance with SSH as oracle user: 
    SSH: ssh oracle@DBCS_VM_Public_IP_Address -i ssh_private_key

Related Topics

Adding the SYSTEM Username and Password to the Wallet

Connect to the Oracle Database Cloud Service and set the SYSTEM password in the wallet for the Oracle Communications Data Model installation.

  1. Oracle Database Cloud Service instance comes with default wallet, db_wallet. Add SYSTEM username and password to db_wallet: 
    mkstore –wrl /u01/app/oracle/admin/Container_DB_Name/db_wallet -createCredential TNS_Alias_of_PDB SYSTEM SYSTEM_password

    Where: Container_DB_Name: is the SID of the Database.

    Note:

    Enter the Container_DB_Name, SID name in the same case as you provided while requesting the Oracle Database Cloud Service instance.

Related Topics

Install Oracle Communications Data Model Shiphome

Provides the steps required to run the install script to install the Oracle Communications Data Model shiphome.

  1. Download the shiphome from eDelivery (https://edelivery.oracle.com). Rename the downloaded file to ocdm.zip.
  2. Create oidm directory in oracle user home directory: 
    [oracle@DBCS_Service_Name ~]$ cd /home/oracle
[oracle@DBCS_Service_Name ~]$ mkdir oidm
  3. Change directory to oidm: 
    [oracle@DBCS_Service_Name ~]$ cd oidm
  4. Download the oidm_install.sh script from the cloud storage container:
  5. Modify the permissions for the oidm_install.sh script: 
    [oracle@DBCS_Service_Name oidm]$ chmod 755 oidm_install.sh
  6. Copy the downloaded Oracle Communications Data Model shiphome from your Linux machine to /home/oracle/oidm directory on the Oracle Database Cloud Service instance. Ensure you are in the shell of your Linux machine, not the Oracle Database Cloud Service VM shell: 
    [user@your_linux_host_name current_directory_name]$ scp -i ssh_private_key OCDM_shiphome_path oracle@DBCS_VM_Public_IP_Address:/home/oracle/oidm

    Where: OCDM_shiphome_path: is the file ocdm.zip. When this .zip file is unzipped it creates the ocdm directory.

  7. Connect to Oracle Database Cloud Service VM and run the oidm_install.sh script and include the required parameters. The following table shows Oracle Communications Data Model configuration parameters:

    Table 6-4 Oracle Communications Data Model Installation Configuration Parameters

    Parameter Name Parameter Description Mandatory/Optional Default Value Valid Values or Format

    db_oidm_prod_name

    OIDM Product name

    Mandatory

    NONE

    OCDM

    db_oidm_install_type

    Install Type

    Optional

    Communications_Data_Model

    Communications_Data_Model, Sample_Reports

    db_oidm_cl_strt_dt

    Calendar Start Date

    Optional

    "2016-01-01"

    YYYY-MM-DD

    db_oidm_cl_nbr_yrs

    Calendar Number of Years

    Optional

    5

    Number

    db_oidm_intvl_prtn_start_dt

    Interval Partition Start Date

    Optional

    No value

    YYYY-MM-DD

    db_oidm_nbr_of_hash_prtn_org

    Number of Hash Partitions for Organization

    Optional

    4

    Number

    db_oidm_nbr_of_hash_prtn_cust

    Number of Hash Partitions for Customer

    Optional

    4

    Number

    db_oidm_nbr_of_hash_prtn_accs_mthd

    Number of Hash Partitions for Access Method

    Optional

    4

    Number

    db_oidm_nbr_of_hash_prtn_acct

    Nuymber of Hash Partitions for Account

    Optional

    4

    Number

    db_oidm_nbr_of_hash_prtn_agrmnt

    Number of Hash Partitions for Agreement

    Optional

    4

    Number
  8. You can also pass Oracle Database parameters to the script. If you have multiple pluggable databases (PDBs) in your container database, then you must pass the PDB name. The following table shows the Oracle Database parameters that you can pass to oidm_install.sh script:

    Table 6-5 Oracle Communications Data Model Database Installation Parameters

    Parameter Name Parameter Description

    ohome

    Oracle Database Home

    obase

    Oracle Base

    datafile_loc

    Data file Location

    sid

    Container Database Identifier

    pdb_name

    Pluggable Database Name

    system_passwd

    SYSTEM user password.

    Note:

    It is not recommended to pass the SYSTEM password from command line for security reasons. It is recommended to store the SYSTEM password in the DB wallet. The script retrieves the password from the default wallet.

Note:

Enter the pdb_name in the same case as you provided while requesting the Oracle Database Cloud Service instance.

For example:

[oracle@DBCS_Service_Name oidm]$ ./oidm_install.sh db_oidm_prod_name=OCDM pdb_name=PDBORCL db_oidm_install_type=Communications_Data_Model

Related Topics

Monitor Oracle Communications Data Model Installation Status

The “Communications Data Model” installation takes about fifteen minutes; the “Sample Reports” installation takes about 30 minutes. Check the progress of the installation in the log files.

  1. Connect to Oracle Database Cloud Service instance using SSH: 
    ssh oracle@DBCS_VM_Public_IP_Address -i ssh_private_key
  2. Check the log files to monitor OCDM installation status: 
    /home/oracle/tmp/name.out [Only for Fresh DBCS Instance]
/home/oracle/oidm/ocdm_install.sav
/u01/app/oracle/cfgtoollogs/ocdm/ocdm_timestamp.log
    After the installation completes, check the messages in ocdm_install.sav: 
    OCDM "OCDM_install_type" option Setup Completed Successfully.

OR

OCDM "OCDM_install_type" option Setup Completed With Errors.
Check OCDM install config log at /u01/app/oracle/cfgtoollogs/ocdm directory.

    If you see the first message, then the Oracle Communications Data Model installation completed successfully, otherwise the installation completed with errors.


    Description of GUID-F317B9C1-9930-44E2-8CB4-E8D836D7283F-default.png follows
    Description of the illustration GUID-F317B9C1-9930-44E2-8CB4-E8D836D7283F-default.png

Unlock Oracle Communications Data Model Database Accounts

The Communications Data Model installation option creates the Oracle Database accounts: ocdm_sys, ocdm_user, and ocdm_report. The Sample_Reports installation option creates the Oracle Database account: ocdm_sample. The accounts are locked. Depending on the installation type, unlock the accounts and set the passwords.

  1. Log in as SYSTEM account: 
    sqlplus system@pdb_name
  2. For the Communications Data Model installation option enter the SYSTEM password when prompted and unlock the accounts and modify the passwords: 
    alter user ocdm_sys account unlock identified by new_password;
alter user ocdm_user account unlock identified by new_password;
alter user ocdm_report account unlock identified by new_password;
  3. For the Sample_Reports installation option enter the SYSTEM password when prompted and unlock the account and modify the password: 
    alter user ocdm_sample account unlock identified by new_password;
Description of GUID-73BB0FE8-3A73-4468-9351-45C1C81970F8-default.png follows
Description of the illustration GUID-73BB0FE8-3A73-4468-9351-45C1C81970F8-default.png

Oracle Business Intelligence Cloud Service Requirements

Installing Oracle Communications Data Model on Oracle Cloud requires a configured Oracle Business Intelligence Cloud Service instance.

The Oracle Communications Data Model product includes the OCDM reports RPD and catalog. To use the out of the box sample reports, upload the RPD and catalog to Oracle Business Intelligence Cloud Service instance. If you already have the Oracle Business Intelligence Cloud Service instance, skip the first step.

Creating the Oracle Business Intelligence Cloud Service Instance

If the subscription type allows you to create an Oracle Business Intelligence Cloud Service instance, you create the Oracle Business Intelligence Cloud Service instance from the Cloud My Services console. If you are using a trial subscription, the instance is provided by Oracle and a service instance is provided in the My Services console.

  1. To create a Oracle Business Intelligence Cloud Service Instance, see: Creating a Service Instance.

Downloading Oracle Communications Data Model RPD and Catalog

Oracle Communications Data Model installation copies product files to $ORACLE_HOME/ocdm directory on the Oracle Database Cloud Service instance.

  1. Listing the OCDM installation directory shows the contents, including the report directory that contains the Catalog and RPD files.
  2. Download ocdm.rpd and ocdm.catalog from Oracle Database Cloud Service instance to your local windows machine. You can find those files in the $ORACLE_HOME/ocdm/report directory on the Oracle Database Cloud Service instance:
Description of GUID-8D814888-9D37-4F8A-80BD-B1CD790B390E-default.png follows
Description of the illustration GUID-8D814888-9D37-4F8A-80BD-B1CD790B390E-default.png

Modifying Oracle Communications Data Model RPD

Describes required modifications for the RPD file for Data Source Name, User Name, and Password for accessing the Oracle Communications Data Model reports.

After you download the RPD ocdm.rpd to the windows machine, ensure that the Oracle Business Intelligence Developer Client tool is installed on the windows machine. If you do not have the Client tool, download it from OTN and install:
  1. Open Oracle Business Intelligence Developer Client Tool and open the RPD in offline mode. The RPD is password protected, so contact Oracle Support for the RPD password. After you enter the RPD password, modify the following properties of Connection Pool object of all databases in RPD physical layer:
    1. Modify Data Source Name, TNS string of Oracle Database Cloud Service instance PDB, where OCDM is installed.
      For example: 
      (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <DBCS VM Public IP>)(PORT = <DB Port>)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = <PDB name in Upper Case>.<Cloud Identity Name>.oraclecloud.internal) ) )
    2. Modify User Name, the OCDM database user name.
      For example:. ocdm_sys for “Communications Data Model” install type and ocdm_sample for “Sample Reports”.
    3. Modify Password, the OCDM database user password.
  2. After modifying the connection pool properties for the servers in the RPD physical layer, save the RPD. When you click OK, Oracle BI Administration Tool prompts to check Global Consistency:
  3. Click Yes and check for errors.

Uploading Oracle Communications Data Model RPD to Oracle Business Intelligence Cloud Service

You upload the modified on-premise Oracle Communications Data Model RPD to Oracle Business Intelligence Cloud Service.

You should already have an Oracle Business Intelligence Cloud Service instance. To determine the Oracle Business Intelligence Cloud Service instance URL, go to My Services (http://myservices.us.oraclecloud.com) console, click the Oracle Business Intelligence Cloud Service instance, and then find the Service Instance URL
  1. Open the Oracle Business Intelligence Cloud Service instance URL in your browser:
  2. From the home page, navigate to Console -> Snapshots and Models Click Console -> Snapshots and Models to show the Snaphot System State:
    Description of GUID-AA34A536-27F6-482B-99B6-0151C3182D53-default.png follows
    Description of the illustration GUID-AA34A536-27F6-482B-99B6-0151C3182D53-default.png

    Description of GUID-361E267A-C0A2-4933-915C-6A21AE26C921-default.png follows
    Description of the illustration GUID-361E267A-C0A2-4933-915C-6A21AE26C921-default.png
  3. Click Replace Data Model to upload the modified on-premise repository, ocdm.rpd.
  4. Browse to select ocdm.rpd. Enter the RPD password, and click OK.
    The Oracle Business Intelligence Cloud Service console shows a message if the RPD uploads successfully. Otherwise the display shows an error message.

Uploading Oracle Communications Data Model Catalog to Oracle Business Intelligence Cloud Service

After you create an Oracle Business Intelligence Cloud Service instance and upload the modified on-premise Oracle Communications Data Model RPD to Oracle Business Intelligence Cloud Service, then upload the OCDM catalog.

You should already have an Oracle Business Intelligence Cloud Service instance. To determine the Oracle Business Intelligence Cloud Service instance URL, go to My Services (http://myservices.us.oraclecloud.com) page, click the Oracle Business Intelligence Cloud Service instance, then find the Service Instance URL.
  1. Open the Oracle Business Intelligence Cloud Service instance URL in your browser. From the home page, navigate to Catalog.
  2. Click the Company Shared folder in the Folders pane.
  3. By default, the Company Shared folder contains the Sample App folder of the Sample App catalog. Create a new folder OCDM in the Company Shared folder.
  4. Upload the Oracle Communications Data Model catalog file (ocdm.catalog). Click the OCDM folder in Folders pane, and then click Unarchive in the Tasks pane.
  5. In the Unarchive dialog click Browse to select ocdm.catalog. In the Replace field select None and click OK.
  6. Navigate to dahsboards/reports: Shared Folders folder to open Welcome to OCDM dashboard.