Skip to content

Latest commit

 

History

History
233 lines (127 loc) · 6.93 KB

Setup.md

File metadata and controls

233 lines (127 loc) · 6.93 KB

Update January 22, 2018

Setup

This workshop requires several setups steps that are normally done in advance as part of an automated process prior to running the labs. In cases where a customer wishes to run through the workshop themselves on their own without the support of Global Services Engineering (GSE) they must first walk through the following steps.

STEP 1: Log into the Cloud Console and create DBCS_WorkshopImage

The following creates a new DBCS Enterprise instance with backup to cloud. Use your own SSH key or generate a new one.

  • Log into your identitity domain/trial account.

  • Select the appropriate account type and data center.

  • Customize dashboard if you do not see any current services.

  • Select show Database

  • Select Database, and then Open Service Console

  • Create Service

  • Enter Service Name and Software Release. Be sure to select Oracle Database 12c Release2.

  • Enter Administration passwords (Alpha2018_) and then select SSH Key

  • Select Create a New Key Pair.

  • Download the key pair and save to your hard drive. Extract the zip file afterwards.

  • Enter Backup and Recovery Configuration. Be sure to select Cloud Storage Only and use this URL for storage. Substitute your identity domain in the part below, and also replace us2 with your data center. Select create the storage container.

    • https://storage.us2.oraclecloud.com/v1/Storage-<IDENTITY DOMAIN>/oracle-data-storageg-1

  • Then select 'create'. This will take about 30 minutes to create.

STEP 2: Download the Oracle Backup Module and the Adobe Yum Repository

  • Go to the following site to download opc_installer.zip and save to your local download location: http://www.oracle.com/technetwork/database/availability/oracle-cloud-backup-2162729.html

  • Go to the following site and download the adobe repository: https://get.adobe.com/flashplayer/. Do not select the default - select download for a different operating system (Linux 64 bit).

  • Select the version YUM.

STEP 3: Create ppk private key

  • Go to the database console and retrieve the IP address. Note that this lab was updated with new screen shots and the IP address noted below will not be consistent throughout. We will reference two images: WorkshopImage (this one) and later a Alpha01A-DBCS instance and will call these out in the workshop documentation by name rather than by IP address.

  • Create a ppk (windows compatible) version of the existing downloaded keys. If you are on a Linux platform this is not necessary. Open Puttygen (free download from the Internet).

  • Go to the directory and select/import the private key. You must first unzip the key bundle.

  • Save Private key.

  • Save without a passphrase.

STEP 3: Copy files to the WorkshopImage

  • Open WinSCP (internet download) and log in to the IP address noted above from the Cloud Console with your private ppk key.

  • Ignore the warning.

  • Drag the following files from your download location to the oracle folder. First extract the sshkeybundle.zip file if you have not already done so.

STEP 4: Log into your WorkshopImage and run install scripts

  • Open Putty and log into the DBCS instance.

  • Select your SSH private privatekey.ppk key.

  • Log in as opc

  • Install packages for desktop and VNC, and then install Oracle database objects (this will take a few minutes). Enter the following:

sudo su -
rpm -ivh /home/oracle/adobe-release-x86_64-1.0-1.noarch.rpm
yum -y install git
exit
sudo su - oracle
git clone https://github.com/pcdavies/DatabaseCloudServiceForDBAs.git
mv /home/oracle/DatabaseCloudServiceForDBAs/workshops/dbcs-dba/install/install.zip .
unzip install.zip
/home/oracle/install.sh
exit
sudo su -
/home/oracle/yum.sh
exit

  • Start VNC Server. You can optionally adjust the geometry to match your screen (eg: vncserver -geometry 1280x720). You will be prompted to enter a password. Do not use the password that we have been specifying in other places in this lab document. VNC is open to the internet. Select your own secure password. Be sure you are sudo su to oracle user.

    • sudo su - oracle
    • vncserver

STEP 5: Open Port 5901 (VNC) and log into the desktop

  • Log back into the Cloud Console and select Database Service.

  • Select Access Rules on the right.

  • Create rule. Note you need to refresh your screen to see the new rule after selecting create.

  • Start your VNC Viewer and log in.

  • This is the WorkshopImage desktop. The background may be different across the screen shots.

  • We need to disable the screen saver to prevent a screen unlock prompt. Go to the system menu on the desktop and de-activate screen saver. If you delay in this step and the screen locks up you will need to kill the vncserver (vncserver -kill :1) and restart it (vncserver) in your terminal window.

STEP 6: Set up shortcut to SQLDeveloper and import connections

  • Right click on the desktop and create a new launcher on the desktop. Enter the Name and Command:

    • Name: SqlDeveloper
    • Command: /u01/app/oracle/product/12.2.0/dbhome_1/sqldeveloper/sqldeveloper/bin/sqldeveloper

  • Select the sqldeveloper icon from the following directory: /u01/app/oracle/product/12.2.0/dbhome_1/sqldeveloper/

  • Double click on the desktop icon to start sqldeveloper. Select no to import connections.

  • Right click on connections and select import connections.

  • Browse for connections file.