How to Provision an Oracle SOA Cloud Service Environment – Database

Database Provisioning

The following steps detail how we provisioned an Oracle Database using the Oracle Database Cloud Service Console.
The database is required in our scenario for two purposes, for the SOA MDS repository and also to allow us to create a schema and a few tables to support our end to end SOA demo.

• Launch the Oracle Database Cloud Service instance creation wizard.
  • Sign in to the My Services application at https://cloud.oracle.com/sign_in . The My Services Dashboard appears. Select your availability zone, e.g. US Commercial (us2), and click on Sign In to My Services

  

  • Enter your Identity Domain and click Go

    

  • Then enter your username and password and click Sign In.

    Note: We recommend you to use complex passwords and store them all in a secured place where you don’t have to remember them but you can retrieve them anytime/anywhere, such as KeePass.
    For more information about KeePass refer to this website: http://keepass.info/

  • In the Oracle My Service dashboard, locate the Oracle Oracle Database Cloud Service and click on Service Console.

  

  • The Oracle Database Cloud Service Console page is displayed.

    

  • Click on Create Instance.

    

• Create the DBCS instance
  • Specify the desired Subscription Type and Billing Frequency. Then click Next. In my case I selected Oracle Database Cloud Service and Monthly billing.

    

  • Select the Software Release that you want. In my case I selected Oracle Database 12c Release. Then click Next.

    

  • Select the Edition that you want. In my case I chose Enterprise Edition, so that we can make use of Pluggable Multitenant DBs.

    

  • Specify the following on the Details page:
    • Service Configuration
      • Name and description: Give a sensible name description
      • Shape (Compute Capacity): Selects depending on your requirement. For this purpose I chose 1 OCPU.
      • Timezone: Select your region
      • SSH public key to access the VM (the key will be included in the .ssh/authorized_keys file): Enter the “public key” that you generated previously. If you have not created this key pair, refer to section How to create SSH key pair down in the Appendix of this document.

      

    • Database Configuration
      • Usable Database Storage (GB): Enter according to your needs. The minimum is 15 GB
      • Administration password: Enter a strong password and make sure to remember it. This will be your SYS password.
      • DB Name SID, PDB Name, character set, National Character set: Assign accordingly to your needs. In my case I left them all as the default values.

    

    • Backup configuration
      • Backup Destination: Set to ‘Both Cloud Storage and Block Storage‘
      • Cloud Storage Container (This is the container you created in the step above ‘Create a Storage Container in Oracle Storage Cloud Service’)

      The name, is in the form:

      Storage-/

      For example: Storage-
      auoracle02747/dafwaContainer1

      • Cloud Storage User name and Password: These are the OPC credentials to access the Cloud Storage Container
      • It will show you the estimated Monthly Storage. Also tick the option to also include backups for the Demos… I did not choose to select it.

      

• You complete configuration should look like this:

  

      If everything is ok, click on Next.

• Review all the settings you just provided and, when satisfied, click Create.

  

  After some time, your new DBCS instance will be ready to be used. If you look in the Oracle Database Cloud Service Console, you will see the status of the provisioning.

  

• Once the DB is fully provisioned, click the link of the newly created DBCS instance.

  

• The details of the selected DBCS instance show up. Take note of the following information as you may need it for subsequent steps:
• Public IP address: 129.152.133.133 (in this case, it will be different for you)
• Listener port: 1521
• SID: ORCL
• PDB Name: PDB1
  • This will help you get the actual service name, which is in the form:

    .. oraclecloud.internal

If you followed the above example, you should be able to successfully provision your database in the Oracle Public Cloud.

<< Previous              Next>>>

Author: David Reid

Cloud Platform Architect View all posts by David Reid