6 Installing Oracle Utilities Data Model on Oracle Cloud

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

Installing Oracle Utilities Data Model on Oracle Cloud

To install Oracle Utilities 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 Utilities Data Model on Oracle Cloud.

Oracle Database Cloud Service Requirements

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

Purchase subscription of Database Cloud Service (DBCS). Oracle Cloud offers following types of subscriptions:

  • Metered Subscription

  • Non-metered Subscription

Related Topics

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.

Related Topics

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 Utilities 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 25 GB. Minimum allowed size is 15 GB. Maximum allowed size is 1200 GB if backup destination is specified and 2048 GB 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 Utilities 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 OUDM-Product Oracle Database Cloud Service instance:

Related Topics

Install Oracle Utilities Data Model on Oracle Cloud

Install Oracle Utilities Data Model on Oracle Database Cloud Service after you complete the configuration. Oracle Utilities 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 Utilities 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 you used when you made the request for the Oracle Database Cloud Service instance.

Related Topics

Install Oracle Utilities Data Model Shiphome

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

  1. Download the shiphome from eDelivery (https://edelivery.oracle.com). Rename the downloaded file to oudm.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 Utilities 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 OUDM_shiphome_path oracle@DBCS_VM_Public_IP_Address:/home/oracle/oidm

    Where: OUDM_shiphome_path: is the file oudm.zip. When this .zip file is unzipped it creates the oudm 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 Utilities Data Model configuration parameters:

    Table 6-4 Oracle Utilities 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

    OUDM

    db_oidm_install_type

    Install Type

    Optional

    Utilities_Data_Model

    Utilities_Data_Model, Sample_Reports

    db_oidm_base_tbs

    Tablespace for BASE tables

    Optional

    USERS

    Existing tablespace name

    db_oidm_ref_tbs

    Tablespace for REFERENCE tables

    Optional

    USERS

    Existing tablespace name

    db_oidm_lookup_tbs

    Tablespace for LOOKUP tables

    Optional

    USERS

    Existing tablespace name

    db_oidm_derived_tbs

    Tablespace for DERIVED tables

    Optional

    USERS

    Existing tablespace name

    db_oidm_aggr_tbs

    Tablespace for AGGREGATE tables

    Optional

    USERS

    Existing Existing tablespace name tablespace name

    db_oidm_base_idx_tbs

    Tablespace for BASE indexes

    Optional

    USERS

    Existing tablespace name

    db_oidm_ref_idx_tbs

    Tablespace for REFERENCE indexes

    Optional

    USERS

    Existing tablespace name

    db_oidm_lookup_idx_tbs

    Tablespace for LOOKUP indexes

    Optional

    USERS

    Existing tablespace name

    db_oidm_derived_idx_tbs

    Tablespace for DERIVED indexes

    Optional

    USERS

    Existing tablespace name

    db_oidm_aggr_idx_tbs

    Tablespace for AGGREGATE indexes

    Optional

    USERS

    Existing tablespace name

    db_oidm_mv_tbs

    Tablespace for Materialized Views

    Optional

    USERS

    Existing tablespace name

    db_oidm_olap_tbs

    Tablespace for OLAP objects

    Optional

    USERS

    Existing tablespace name

    db_oidm_default_tbs

    Default tablespace for OUDM_SYS schema

    Optional

    USERS

    Existing tablespace name

    db_oidm_default_temp_tbs

    Default temporary tablespace for OUDM_SYS schema

    Optional

    TEMP

    Existing tablespace name

    db_oidm_sample_tbs

    Tablespace for OUDM_SAMPLE schema

    Note:

    Provide when db_oidm_install_type is set to “Sample_Reports”

    Optional

    USERS

    Existing tablespace name

    db_oidm_sample_temp_tbs

    Temporary tablespace for OUDM_SAMPLE schema.

    Note:

    Provide when db_oidm_install_type is set to “Sample_Reports”

    Optional

    TEMP

    Existing tablespace name

    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

    "2016-01-01"

    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_prty

    Number of Hash Partitions for Party

    Optional

    4

    Number

    db_oidm_nbr_of_hash_prtn_acct

    Number of Hash Partitions for Account

    Optional

    4

    Number

    db_oidm_nbr_of_hash_prtn_agrmnt

    Number of Hash Partitions for Agreement

    Optional

    4

    Number

    db_oidm_nbr_of_hash_prtn_mtr_rdng

    Number of Hash Partitions for MeterReading

    Optional

    4

    Number

    db_oidm_nbr_of_hash_prtn_init_rdng

    Number of Hash Partitions for InitialReading

    Optional

    4

    Number

    db_oidm_nbr_of_hash_prtn_fnl_rdng

    Number of Hash Partitions for FinalReading

    Optional

    4

    Number

    db_oidm_nbr_of_hash_prtn_srvc_qnty

    Number of Hash Partitions for ServiceQuantity

    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 Utilities 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=OUDM pdb_name=PDB1 db_oidm_install_type=Utilities_Data_Model

Related Topics

Monitor Oracle Utilities Data Model Installation Status

The Utilities 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 OUDM installation status: 
    /home/oracle/tmp/name.out [Only for Fresh DBCS Instance]
/home/oracle/oidm/oudm_install.sav
/u01/app/oracle/cfgtoollogs/oudm/oudm_timestamp.log
    After the installation completes, check the messages in oudm_install.sav: 
    OUDM "OUDM_install_type" option Setup Completed Successfully.

OR

OUDM "OUDM_install_type" option Setup Completed With Errors.
Check OUDM install config log at /u01/app/oracle/cfgtoollogs/oudm directory.

    If you see the first message, then the Oracle Utilities 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

Note:

When installation completes with errors, report the errors to Oracle Support.

Unlock Oracle Utilities Data Model Database Accounts

The Utilities Data Model installation option creates the Oracle Database accounts: oudm_sys, oudm_user, and oudm_report. The Sample_Reports installation option creates the Oracle Database account: oudm_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 Utilities Data Model installation option enter the SYSTEM password when prompted and unlock the accounts and modify the passwords: 
    alter user oudm_sys account unlock identified by new_password;
alter user oudm_user account unlock identified by new_password;
alter user oudm_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 oudm_sample account unlock identified by new_password;
  4. Log in to sqlplus as oudm account, the login prompts to modify the password. The password of all accounts is the account name in lower case, for example, oudm_sys is the password for oudm_sys account.

Oracle Business Intelligence Cloud Service Requirements

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

The Oracle Utilities Data Model product includes the OUDM 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 Utilities Data Model RPD and Catalog

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

  1. Listing the OUDM installation directory shows the contents, including the report directory that contains the Catalog and RPD files.
  2. Download oudm.rpd and oudm.catalog from Oracle Database Cloud Service instance to your local windows machine. You can find those files in the $ORACLE_HOME/oudm/report directory on the Oracle Database Cloud Service instance:

Modifying Oracle Utilities Data Model RPD

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

After you download the RPD oudm.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; 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 OUDM 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 OUDM database user name.
      For example:. oudm_sys or oudm_report for “Utilities Data Model” install type and oudm_sample for “Sample Reports”. The oudm_report user is a less privileged user created to access data in oudm_sys schema.
    3. Modify Password, the OUDM 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 Utilities Data Model RPD to Oracle Business Intelligence Cloud Service

You upload the modified on-premise Oracle Utilities 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, oudm.rpd.
  4. Browse to select oudm.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 Utilities 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 Utilities Data Model RPD to Oracle Business Intelligence Cloud Service, then upload the OUDM 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 OUDM in the Company Shared folder.
  4. Upload the Oracle Utilities Data Model catalog file (oudm.catalog). Click the OUDM folder in Folders pane, and then click Unarchive in the Tasks pane.
  5. In the Unarchive dialog click Browse to select oudm.catalog. In the Replace field select None and click OK.
  6. Navigate to dahsboards/reports: Shared Folders folder to open Welcome to OUDM dashboard.