6 Installing Oracle Airlines Data Model on Oracle Cloud

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

Installing Oracle Airlines Data Model on Oracle Cloud

To install Oracle Airlines Data Model on Oracle Cloud, use the Oracle Database Cloud Service and the Oracle BI 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 Airlines Data Model on Oracle Cloud.

Oracle Database Cloud Service Requirements

Installing Oracle Airlines 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 Airlines 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 Level

Service level for the service instance

Mandatory

Oracle Database Cloud Service

Billing Frequency

Billing unit

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

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

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
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

Timezone

Timezone for the service instance

Mandatory

No Value

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

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

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

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 (_);

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

Backup Destination

Backup destination

Mandatory

No value

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 User Name

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 

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 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 figure shows details for OADM-Product Oracle Database Cloud Service instance:

Related Topics

Install Oracle Airlines Data Model on Oracle Cloud

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 OADM 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.

Related Topics

Install Oracle Airlines Data Model Shiphome

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

  1. Create oidm directory in oracle user home directory: 
    [oracle@DBCS_Service_Name ~]$ cd /home/oracle
[oracle@DBCS_Service_Name ~]$ mkdir oidm
  2. Change directory to oidm: 
    [oracle@DBCS_Service_Name ~]$ cd oidm
  3. Download the oidm_install.sh script from the cloud storage container:
  4. Modify the permissions for the oidm_install.sh script: 
    [oracle@DBCS_Service_Name oidm]$ chmod 755 oidm_install.sh
  5. Copy the downloaded Oracle Airlines 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 OADM_shiphome_path oracle@DBCS_VM_Public_IP_Address:/home/oracle/oidm

    Where: OADM_shiphome_path: is the file oadm.zip. When this is unzipped it creates the oadm directory.

  6. Connect to DBCS VM and run the oidm_install.sh script and include the required parameters. The following table shows Oracle Airlines Data Model configuration parameters:

    Table 6-3 Oracle Airlines Data Model Installation Configuration Parameters

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

    db_oidm_prod_name

    OIDM Product name

    Mandatory

    NONE

    OADM

    db_oidm_install_type

    Install Type

    Optional

    Airlines_Data_Model

    Airlines_Data_Model, Sample_Reports

    db_oidm_cl_strt_dt

    Calendar Start Date

    Optional

    "2015-01-01"

    YYYY-MM-DD

    db_oidm_cl_nbr_yrs

    Calendar Number of Years

    Optional

    "5"

    Number
  7. You can also pass Oracle Database parameters to the script. If you have multiple 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-4 Oracle Airlines 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.

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

Related Topics

Monitor Oracle Airlines Data Model Installation Status

The OADM “Airlines Data Model” installation takes about 15 minutes and the “Sample Reports” installation takes about 30 minutes. You can 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 OADM installation status: 
    /home/oracle/tmp/name.out [Only for Fresh DBCS Instance]
/home/oracle/oidm/oadm_install.sav
/u01/app/oracle/cfgtoollogs/oadm/oadm_timestamp.log
    After the installation completes, you should see one of the following messages in oadm_install.sav: 
    OADM "OADM_install_type" option Setup Completed Successfully.

OR

OADM "OADM_install_type" option Setup Completed With Errors.
Check OADM install config log at /u01/app/oracle/cfgtoollogs/oadm directory.

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


    Description of GUID-350B57FC-8C0F-42AD-ADD7-F2FFD1154D61-default.png follows
    Description of the illustration GUID-350B57FC-8C0F-42AD-ADD7-F2FFD1154D61-default.png

Unlock Oracle Airlines Data Model Database Accounts

The Airlines Data Model installation option creates the Oracle Database accounts: oadm_sys, oadm_user, and oadm_report. The Oracle Airlines Data Model Sample_Reports installation option creates the Oracle Database account: oadm_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@pdbname
  2. For the Airlines Data Model installation option enter the SYSTEM password when prompted and unlock the accounts and modify the passwords: 
    alter user oadm_sys account unlock identified by new_password;
alter user oadm_user account unlock identified by new_password;
alter user oadm_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 oadm_sample account unlock identified by new_password;

Description of GUID-CD8FDD25-9F5F-4D15-B6F1-1653AE9205FE-default.png follows
Description of the illustration GUID-CD8FDD25-9F5F-4D15-B6F1-1653AE9205FE-default.png

Oracle BI Cloud Service Requirements

Installing Oracle Airlines Data Model on Oracle Cloud requires a configured Oracle BI Cloud Service instance.

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

  • Creating the Oracle BI Cloud Service Instance
    If the subscription type allows you to create an Oracle BI Cloud Service instance, you create the Oracle BI 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.
  • Downloading Oracle Airlines Data Model RPD and Catalog
    Oracle Airlines Data Model installation copies product files to $ORACLE_HOME/oadm directory on the Oracle Database Cloud Service instance.
  • Modifying Oracle Airlines Data Model RPD
    Describes required modifications for the RPD file for Data Source Name, User Name, and Password for accessing the Oracle Airlines Data Model reports.

Creating the Oracle BI Cloud Service Instance

If the subscription type allows you to create an Oracle BI Cloud Service instance, you create the Oracle BI 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 BI Cloud Service Instance, see: Creating a Service Instance.

Downloading Oracle Airlines Data Model RPD and Catalog

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

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

Description of GUID-DE33D53B-A66F-4868-8035-1CC464756AD4-default.png follows
Description of the illustration GUID-DE33D53B-A66F-4868-8035-1CC464756AD4-default.png

Modifying Oracle Airlines Data Model RPD

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

After you download the RPD oadm.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:

http://download.oracle.com/otn/nt/bi/111190/biee_client_install_x64.zip

or

http://download.oracle.com/otn/nt/bi/1221/Setup_BI_Client_12.2.1.0.0_Windows.X64.zip

  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 OADM 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 OADM database user name.
      For example:. oadm_sys for “Airlines Data Model” install type and oadm_sample for “Sample Reports”.
    3. Modify Password, the OADM 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 Airlines Data Model RPD to Oracle BI Cloud Service

You upload the modified on-premise Oracle Airlines Data Model RPD to Oracle BI Cloud Service.

You should already have an Oracle BI Cloud Service instance. To determine the Oracle BI Cloud Service instance URL, go to My Services (http://myservices.us.oraclecloud.com) console, click the Oracle BI Cloud Service instance, and then find the Service Instance URL
  1. Open the Oracle BI 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, oadm.rpd.
  4. Browse to select oadm.rpd. Enter the RPD password, and click OK.
    The Oracle BI Cloud Service console shows a message if the RPD uploads successfully. Otherwise the display shows an error message.

Uploading Oracle Airlines Data Model Catalog to Oracle BI Cloud Service

After you create an Oracle BI Cloud Service instance and upload the modified on-premise Oracle Airlines Data Model RPD to Oracle BI Cloud Service, then upload the OADM catalog.

You should already have an Oracle BI Cloud Service instance. To determine the Oracle BI Cloud Service instance URL, go to My Services (http://myservices.us.oraclecloud.com) page, click the Oracle BI Cloud Service instance, then find the Service Instance URL.
  1. Open the Oracle BI 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 OADM in the Company Shared folder.
  4. Upload the OADM catalog file (oadm.catalog). Click the OADM folder in Folders pane, and then click Unarchive in the Tasks pane.
  5. In the Unarchive dialog click Browse to select oadm.catalog. In the Replace field select None and click OK.
  6. Navigate to Shared Folders -> Welcome to OADM -> Dashboards folder to open Welcome to OADM dashboard.
The Welcome to OADM dashboard has links to Oracle Airlines Data Model out of the box dashboards and links are organized by business area.