Deploying Siebel Demo Database to a Single Instance VM Using Oracle Compute Cloud Service

Purpose

This tutorial shows you how to deploy an Oracle 12c Siebel Demo database environment for Siebel CRM IP2015 on a single virtual machine in Oracle Compute Cloud Service (Dedicated).

Note that the information presented here is based on Siebel CRM IP2015, which is general availability since 2015.

Time to Complete

50 minutes

Background

Oracle Compute Cloud Service enables you to rapidly provision virtual machines (VMs) on Oracle Cloud with the necessary storage and networking resources.  After you’ve created your virtual machine instance, you can navigate and test out Siebel CRM IP2015 on the VM.

What Do You Need?

A subscription to Oracle Compute Cloud Service (Dedicated) is mandatory and you must be a user with the Compute_Operations and Storage Read Write Group roles.

For more details on creating Oracle Compute Cloud Service instances, see the following:

• How to Begin with Oracle Compute Cloud Service (Dedicated) Subscriptions in Using Oracle Compute Cloud Service (Dedicated)
• Creating a Single Instance Using the Oracle Compute Cloud Service Web Console.

To create the required Oracle Compute Cloud Service instance to deploy the Siebel CRM Demo Database, you will:

1. Generate an SSH key pair on your local system.
2. Upload the SSH public key to Oracle Compute Cloud Service.
3. Enable SSH.
4. Reserve a public IP address to associate with your database instance.
5. Create your Demo Database instance and associate the reserved public IP address with it, configure it for SSH access
6. Execute the Siebel CRM IP2015 Demo database startup script from the created instance

When you create your Oracle Compute Cloud Service instance, you must provide an SSH public key that will be used for authentication when you log in to the instance. Generate your SSH key pair and upload the SSH public key to the Oracle Compute Cloud Service before you start to create your instance.

Generating an SSH Key Pair on UNIX or UNIX-Like Systems Using ssh-keygen

1. Run the ssh-keygen command.

   ssh-keygen -b 2048 -t rsa

2. The command prompts you to enter the path to the file in which you want to save the key. A default path and file name are suggested in parentheses. For example: /home/user_name/.ssh/id_rsa. To accept the default path and file name, press Enter. Otherwise, enter the required path and file name, and then press Enter.
3. The command prompts you for a passphrase. Enter a passphrase.
   Note that the passphrase isn't displayed when you type it in. Remember the passphrase. If you forget the passphrase, you can't recover it.
4. When prompted, enter the passphrase again to confirm it.
   The command generates an SSH key pair consisting of a public key and a private key, and saves them in the specified path. The file name of the public key is created automatically by appending .pub to the name of the private key file. For example, if the file name of the SSH private key is id_rsa, then the file name of the public key would be id_rsa.pub.
5. Make a note of the path where you've saved the SSH key pair.
   When you create instances, you must provide the SSH public key. When you log in to an instance, you must specify the corresponding SSH private key and enter the passphrase when prompted.

Generating an SSH Key Pair on Windows Using the PuTTY Key Generator

1. Find puttygen.exe in the PuTTY folder on your computer and double-click it. (If you do not have PuTTY.exe on your computer you can find it on web here http://www.putty.org/)
2. Accept the default key type, SSH-2 RSA, and set the Number of bits in a generated key to 2048, if it is not already set. Then click Generate.

   

3. Move your mouse around the blank area to generate randomness. The SSH key pair is generated.

   

4. Save your private key.
   1. The key comment is the name of the key. You can keep the generated key comment or create your own.
   2. Enter a passphrase in the Key passphrase and the Confirm passphrase fields.

      Note: Remember the passphrase. You can't recover a passphrase if you forget it.

   3. To save the private key in the PuTTY PPK format, click Save private key. Enter the same name as you used for the key comment so that you know which public key to use this private key with. The private key is saved in PuTTY's Private Key (PPK) format, which is a proprietary format that works only with the PuTTY toolset. You can use this key whenever you use PuTTY for SSH.

      

5. Next, save your SSH public key.
   1. To save the public key, in the PuTTY Key Generator, select all of the characters in the Public key for pasting into OpenSSH authorized_keys file field.

      Note: Make sure you select all the characters, not just the ones you can see in the narrow window. If there is a scroll bar next to the characters, you aren't seeing all the characters.

   2. Right-click somewhere in the selected text and select Copy from the menu.

      

   3. Open a text editor and paste the characters. Ensure that you paste the text at the first character in the text editor, and don't insert any line breaks.
   4. Save the key using the same root name that you used for the private key. Add a .pub extension. You can give it any extension you want, but .pub is a useful convention to indicate that this is a public key.
   5. Exit PuTTY Key Generator.
6. Make a note of the public and private key names and where they are saved.
   When you create instances, you must specify the SSH public key. When you log in to an instance, you must provide the path to the corresponding SSH private key and enter the passphrase when prompted.

1. Sign in to the Oracle Cloud My Services application at https://cloud.oracle.com/sign_in.
   The My Services Dashboard page is displayed.
2. Using the Cloud Account drop-down menu, choose your data center and then click My Services.
3. Enter your Identity Domain, and click Go.
4. Enter your User Name and Password, and click Sign In.
5. Click the menu at the upper left corner of the page and select Oracle Compute Cloud Service.
   The Oracle Compute Cloud Service console is displayed.
6. Click the Network tab.
7. From the menu on the left, select SSH Public Keys.
   The SSH Public Keys page is displayed.
8. Click Add SSH Public Key.
9. In the Add SSH Public Key dialog box, enter a name and the value of the SSH public key you generated, and then click Add.

   Note. Paste the key value exactly as it was generated. Don't append or insert any extra characters, line breaks, or spaces.

   Your SSH public key is added to Oracle Compute Cloud Service.

   

You must enable SSH to enable communications to the environment.

1. If you are already signed into Oracle Cloud, skip to step 7, if you are not signed in, complete steps 2-6 below.
2. Sign in to the Oracle Cloud My Services application at https://cloud.oracle.com/sign_in.
   The My Services Dashboard page is displayed.
3. Using the Cloud Account drop-down menu, choose your data center and then click My Services.
4. Enter your Identity Domain, and click Go.
5. Enter your User Name and Password, and click Sign In.
6. Click the menu at the upper left corner of the page and select Oracle Compute Cloud Service.
   The Oracle Compute Cloud Service console is displayed.
7. Click the Network tab.
8. From the menu on the left, select Security Lists.
   The Security Lists page is displayed.
9. Click Create Security List.
10. Fill in the following fields:
    
• Name: Enter a name for the new security list. For the purpose of this tutorial, enter open_putty. Note this name as you will use it later in this tutorial.
• Inbound Policy: Accept the default option, Deny (Drop packets, no reply).
• Outbound Policy: Select Permit (Allow packets).
• Description: Enter a description for the new security list if desired.
11. Click Create.

When the screen re-draws, your new security list appears, but the Associated Instances field is blank.




Next, we must add the instance to the security list.

12. Click the Instances tab, and then click the Instances tile.
13. From the list of instances displayed, click menu icon to the right of the SEBLMTVM1 instance name and choose View.
14. On the resulting page, click Add to Security List. The Add to Security List dialog box appears.


15. Select the open_putty security list that you created earlier and click Add. The instance is attached to the security list.

Now we must create a security Rule to enable port 22.

16. Click the Network tab and then Security Rules.
17. Click Create Security Rule.
18. In the Create Security Rule dialog box, select or enter the following information:


• Name: Enter an appropriate name for the rule. For the purpose of this tutorial, enter putty.
• Status: Select Enabled.
• Security Application: Select all.

Note: Many of the commonly used protocol and port combinations are provided as predefined security applications in Oracle Compute Cloud Service. However, if you wish to specify a particular protocol-port mapping that is not in the list of predefined security applications, you can create the required security application by going to the Security Applications tile.

• Source: In the Security List drop-down menu, choose default. From the Security IP Lists drop-down menu, choose public-internet.
• Destination: Select the open_putty security list that you created earlier.
• Description: Enter a description for the rule (for example, Allow SSH traffic to instances on port 22).
19. Click Create

Next, create an IP address reservation. Later in this tutorial, you'll associate this IP address to your instance when you create it.

1. On the Oracle Compute Cloud Service web console, click the Network tab.
2. Click the IP Reservations tile, and then click Create IP Reservation.
3. In the Create Public IP Reservation dialog box, enter a name for the IP address reservation, and then click Create.

   Note. Do not select an instance from the For Instance list. You'll use this IP address for the instance that you are about to create.

   

   Note. Make a note of this public IP address. You'll use it to access your instance using SSH later on.

1. Go to the Oracle Cloud Marketplace at https://cloud.oracle.com/marketplace/.
2. Click on the PRODUCTS drop-down menu and select INFRASTRUCTURE (IaaS) > Compute Cloud
3. Enter 'siebel' in the search field and click Go.
4. Drill down on the Marketplace item Siebel CRM IP2015 Demo Database image and click the Get App button to start the flow that will move the associated machine image into your Compute account.
   
5. Accept the terms and conditions.
   
6. Specify your compute account name and click Install.
   
7. A notification that the application has successfully installed appears. Click on Start Compute Console.
   
8. Enter your compute account domain to which you moved your image and click Go.
   
9. Login with your credentials and proceed with instance creation.
   

1. The Compute screen appears. Click Private Images on the left.
2. Select to the right of your newly created image. The button text changes from Select to Selected to indicate your selection. Click the > button at the top right to continue creating the instance.
   
3. Select a shape (number of CPUs and Memory). For the purpose of this tutorial, select oc3 (OCPUs: 1, Memory: 7.5 GB) and then click > to continue creating the instance.
   
4. Complete the Instance fields as described below.
   
5. In the Instance page, select or enter the following information, and then click >:
   • Name: Enter an appropriate name. If you don’t specify a name, the instance name will be generated automatically. For the purpose of this tutorial, enter Siebel_SingleDEMODB_Instance_VM
   • Label: Enter a description to help identify the instance, which is SEBL-VM in this example. If you provide a label, the label is used to list the instance on the Overview page.
   • Description: Enter a description of this instance.
   • Tags: If required, specify a tag to help identify your instance.
   • SSH Keys: Select the key you created. If it is not on the list, click Add SSH Public Key to add it.
   • Custom Attributes: If needed, add any custom attributes within the brackets ().
6. When done configuring the Instance page, it should resemble this:



7. Click > to continue configuring the instance.
8. In the Network page, select or enter the following information, and then click >:
   • DNS Hostname Prefix: Enter a string that will be used as a prefix in the domain host name for your instance. For the purpose of this tutorial, enter a value for the DNS Hostname Prefix, such as SBLDDBVM1.
   • Network Options: Check the box for Shared Network and clear the box for IP Network.
   • Public IP Address: Select Persistent Public IP Reservation, and from the list, select the IP reservation that you created earlier, for example ip-res-db.
   • Security Lists: Select the Open_Putty security list created earlier.

   

9. In the Storage page, use only the volume created for your instance. Use the Remove command (in the menu on the right side) on any other volumes. Click > to continue configuring the instance.

   

10. In the Review page, verify the information that you've entered and then click Create. Your instance is created.

    

11. Check the status of the Compute Service instance using the Instances list of the Overview tab. In this example the status is Preparing initially and changes to Initializing.

    

    

12. When the Status has changed to Running, you can click the view link to get details of the instance.

    

13. Instance details.

    

Logging In From a UNIX or UNIX-Like System

1. Enter the following command:

   ssh -o ServerAliveInterval=5 -o ServerAliveCountMax=1 $HOST -i/path/to/<private_key_name> opc@<public ip address of instance>

   Note. If you don't know the public IP address of your instance, you can find it by going to the Instances tile on the Oracle Compute Cloud Service console and clicking your instance to get to the details page.

   Important! The command text ServerAliveInterval=5 –o ServerAliveCountMax=1 $HOST is mandatory to prevent the SSH connection from receiving a timeout while running the Siebel DPK.

2. If you entered a passphrase when creating your SSH key pair, enter the passphrase when prompted.
3. The first time you connect to your instance, the ssh utility prompts you to confirm the public key. In response to the prompt, enter yes.

Logging In From a Windows System

1. Start PuTTY. The PuTTY Configuration window is displayed, showing the Session panel.
2. In the Host Name (or IP address) field, enter the public IP address of your instance.

   Note. If you don't know the public IP address of your instance, you can find it by going to the Instances tile on the Oracle Compute Cloud Service console and clicking your instance to get to the details page.

3. In the Connection type field, select SSH if it is not already selected.

   

4. In the Category pane, expand Connection, and then click Data. The Data panel is displayed.
5. In the Auto-login username field, enter opc. Confirm that the When username is not specified option is set to Prompt.

   

6. In the Category pane, click Connection. Enter 5 in the Seconds between keepalives (0 to turn off) text box.
   Ensure that the Enable TCP keepalives (SO_KEEPALIVE option) check box is selected.

   

7. In the Category pane, expand SSH, and then click Auth. The Auth panel is displayed.
8. In the Private key file for authentication field, click Browse and select the private key file that you saved earlier, rsa-key-1.ppk in this example.

   

9. In the Category tree, click Session.
   The Session panel is displayed.
10. In the Saved Sessions field, enter a name for this connection configuration, and then click Save.
11. Click Open to open the connection.
    The PuTTY Configuration window is closed and the PuTTY window is displayed.
12. Enter the passphrase you had provided for your SSH key pair.
13. The first time you connect to your instance, the PuTTY Security Alert window is displayed, prompting you to confirm the public key. Click Yes to continue.

1. After you login to the VM, execute the following commands:
• sudo su
• mount /dev/xvdb4 /data
• exit
• /app/scripts/Configure_DB.sh
2. Siebel CRM IP2015 Demo database starts and you get the database details. Example below.

Please wait while we configure this DB instance for you. This may take few minutes...
Your DB has been successfully configured. Below are the details. Please use local user oracle to perform db administration.
DB Version: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
DB env: /app/scripts/db.env
DB Admin Username\Password: sys\manager
DB Instance Name: siebel
DB Port Number: 1521
DB Service name: siebel
DB Table Owner Name: siebel
DB Table Owner Username\Password: siebel\siebel
DB Username\Password for siebel URLs: sadmin\sadmin
DB tnanames.ora
    (DESCRIPTION =
     (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = efc7df)(PORT = 1521))
     )
     (CONNECT_DATA =
          (SERVICE_NAME = siebel)
     )
    )
DB Utility to start database: /data/scripts/db_startup.sh (to be run as local user oracle)
DB Utility to shutdown: /data/scripts/db_shutdown.sh (to be run as local user oracle)

• Search for Siebel Bookshelf in My Oracle Support