Describes how to install 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.
Installing Oracle Airlines Data Model on Oracle Cloud requires a correctly configured Oracle Database Cloud Service instance.
SSH
key pair with a public key and a private key to access the Oracle Database Cloud Service instance.Create an SSH
key pair with a public key and a private key to access the Oracle Database Cloud Service instance.
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.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
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.
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 |
After the Oracle Database Cloud Service request is accepted, you can monitor the status of the Oracle Database Cloud Service instance.
Related Topics
SYSTEM
password in the wallet for the OADM installation.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.SYSTEM
Username and Password to the WalletConnect to the Oracle Database Cloud Service and set the SYSTEM
password in the wallet for the OADM installation.
Provides the steps required to run the install script to install the Oracle Airlines Data Model shiphome.
[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
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.
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.
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.
$ORACLE_HOME/oadm
directory on the Oracle Database 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.
Oracle Airlines Data Model installation copies product files to $ORACLE_HOME/oadm
directory on the Oracle Database Cloud Service instance.
Describes required modifications for the RPD file for Data Source Name, User Name, and Password for accessing the Oracle Airlines Data Model reports.
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
You upload the modified on-premise Oracle Airlines Data Model RPD 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.