Skip to content

Files

Latest commit

DelphixEduDelphixEdu
Update TOC optional exercises
Jul 5, 2018
48ab414 · Jul 5, 2018

History

History
1466 lines (917 loc) · 55.6 KB

INSTRUCTIONS.md

File metadata and controls

1466 lines (917 loc) · 55.6 KB

Delphix Admin for Oracle Lab Guide

Table of Contents

Lab Exercises

Lab Solutions

Lab Exercises

Perform these exercises when instructed by your Delphix Instructor.

Optional Advanced Exercise - Perform a Storage Performance Test through the CLI

In this exercise, you will:

  • Log into the Delphix Data Platform prior to configuration via the Delphix Command Line Interface (CLI)
  • Perform a Storage Test
  • View the Storage Test results

Steps

As an advanced exercise, this lab has no corresponding Lab Solution. Instead, we will walk through the steps to get you acquainted with your lab system and the Delphix CLI.

  1. On your Lab Server desktop, double-click on Terminal
  2. Type: ssh sysadmin@10.0.x.10 ('x' is your Student Number assigned by your instructor)
    • If you receive a prompt asking you if you are sure you want to connect, enter: Yes
    • Enter the password: sysadmin
    • Escape to the standard CLI prompt by typing discard and then press the enter key
    • You are now at the root of the Delphix CLI as a System Administrator
  3. Create a storage test by typing: storage test create and press the enter key
    • List the default storage test parameters by typing: get
    • Override the duration and set it to 5 minutes: set duration=5
    • Begin the storage test by typing: commit

Note: The actual duration of the test may vary depending on the performance of the attached storage. It is expected that this test will take anywhere between 6 - 8 minutes to complete with duration set to 5.
images/download/attachments/90014954/worddav7d1b92b5995f4a0e72c9c086f21df7ea.png
Example Storage Test Configuration

  1. View the storage test results
    • Get back to the storage test section of the CLI by typing: storage test and press the enter key
    • Type the command list and press the enter key You should see the completed test listed.
    • Type select followed by the name of the test from the list. For example: select STORAGE_TEST-1
    • Enter the result command by typing: result
    • Then type: commit

images/download/attachments/90014954/worddav4cc92cfa22a23a274b16db2c2edc3fa2.png
Example Storage Test Results

Exercise 1 - Delphix Data Platform Configuration

In this exercise, you will:

  • Access the Delphix Data Platform GUI for the first time

  • Set up the Delphix SYSADMIN user

  • Configure Timezone Preferences

  • Configure Network Settings

  • Configure Storage

  • Complete the Delphix Data Platform configuration

  • Set up the DELPHIX_ADMIN user

Steps

  1. Connect to your Delphix Data Platform using Chrome on your lab server (see the Important IP Addresses section of the Getting Started guide above).

  2. Set the new sysadmin password to: delphix

  3. Configure the Delphix Data Platform with the following details:

    • NTP on using pool.ntp.org with your local timezone

    • Default network settings

    • Three 8GB volumes in the data pool

    • Uncheck the "Enable phone home service" box in the Serviceability tab

    • Default Authentication Service options

    • Registration is not required for this lab

    • Completed and saved System setup.

  4. Log in with the initial delphix_admin user credentials

  5. Set the new delphix_admin password to: delphix

You will know this is successful when you see the main Delphix UI screen with a single group (Untitled) on the left hand side.
Related Links
The delphix_admin and sysadmin User Roles
Setting Up the Delphix Data Platform

Exercise 2 - Create the "delphix_db" User

In this exercise, you will:

  • Create a Delphix DB User on your source database

Steps

  1. Use Terminal to SSH into your Linux Source (see the Important IP Addresses section of the Getting Started guide above).

  2. Untar the hostchecker_linux_x86.tar file in your home directory

  3. Inside the hostchecker folder run the createDelphixDBUser.sh command

    export ORACLE_SID= orcl
export ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_1
cd hostchecker 
./createDelphixDBUser.sh

  4. Use the following details during the running of this script:

    • Instance Name: orcl

    • Delphix DB User Username: delphix_db

    • Delphix DB User Password: delphix_db

    • Decline the SELECT ANY DICTIONARY privilege. This is a sweeping privilege that is not required, but optional.

The script should configure and create the user without error.

Exercise 3 - Validate the Source Environment with Hostchecker

In this exercise, you will:

  • Use the 'hostchecker' program to run validation tests on your Linux Source

Steps

  1. Use Terminal to SSH into your Linux Source (see the Important IP Addresses section of the Getting Started guide above).

  2. Go to the hostchecker directory created in the previous exercise and type: ./hostchecker.sh

Note: If you exited your session or created a new session after completing the previous exercise, you need to set your environment variables again.

export ORACLE_SID=orcl  
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
  1. Run hostchecker for a source and perform the following checks:
    • Check on the delphix homedir
    • Check the following ports on your Delphix Data Platform (10.0.x.10): 8415, 8341, 50001, and 873
    • Check the Oracle installation for your current $ORACLE_HOME value
    • Check the oratab file
    • Check all instances on the machine
    • Check for ssh connectivity
    • Check for sudo privileges as the delphix user
    • Check sshd_config for timeout
    • Check the toolkit path of: /u01/app/toolkit

Were all tests successful? If not, which ones failed and why?
Note : The sshd_config test will return a WARNING response, which is normal in a production installation due to permissions on the file. If hostchecker is run as root for this test, it will perform the test properly.

Exercise 4 - Add a Source Environment and Link a dSource

In this exercise, you will:

  • Connect Delphix to your Source Oracle Database server
  • Create an Oracle dSource by syncing with your Source Oracle Database
  • Create a Delphix Group to hold your dSource object

Steps

  1. Log into the Delphix Data Platform as delphix_admin

  2. Add your Linux Source as an Environment with the following details:

    • Host OS: Unix/Linux
    • Server Type: Standalone
    • Environment Name: Source
    • Host Address: 10.0.x.20 ('x' will be your Student Number )
    • OS Username: delphix
    • OS Password: delphix
    • Toolkit Path: /u01/app/toolkit

Now, link the orcl dSource:

  1. Add the orcl dSource with the following details:
    • DB Username and Password: The username/password you created in Exercise 2
    • Use a new Group called: DB Sources
    • Accept defaults for the Loading Options and Hooks

You will know this is successful if the dSource completes in the Actions pane without Errors. Click on Actions in the top menu bar if you don't see this pane.

Exercise 5 - Validate the Target Environment with Hostchecker

In this exercise, you will:

  • Use the 'hostchecker' program to run validation tests on your Linux Target

Steps

  1. Use Terminal to SSH into your Linux Target A (see the Important IP Addresses section of the Getting Started guide above).

  2. Untar the hostchecker_linux_x86.tar file in your home directory

  3. Set the Oracle environment variables for the delphix os user as follows:

    export ORACLE_SID= orcl
export ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_1

  4. Run hostchecker for a target and perform the following checks:

    • Check on the delphix homedir
    • Check the following ports on your Delphix Data Platform (10.0.x.10): 8415, 873, 22, 80, 443
    • Check the Oracle installation for your current $ORACLE_HOME value
    • Check for ssh connectivity
    • Check the oratab file
    • Check for sudo privileges as the delphix user
    • Check sshd_config for timeout
    • Check the toolkit path of: /u01/app/toolkit

If you have completed all of the checks and they have returned SUCCESS and ALL OK, you have completed this exercise.
Note : The sshd_config test will return a WARNING response, which is normal in a production installation due to permissions on the file. If hostchecker is run as root for this test, it will perform the test properly.

Exercise 6 - Add Target Environments

In this exercise, you will:

  • Connect Delphix to your Target Oracle server

Steps

  1. Add your Linux Target Environment with the following details:

    • Environment Name: Target
    • Host Address: 10.0.x.30 ('x' will be your Student Number )
    • OS Username: delphix
    • OS Password: delphix
    • Toolkit Path: /u01/app/toolkit

You can verify that this is complete by waiting for the Create and discover environment "10.0.x.30" action to complete on the right hand side of the screen in the Actions pane. Once it is complete, the Target environment will appear on the left side of the Environments page.

Exercise 7 - Provision a VDB

In this exercise, you will:

  • Create a VDB called devdb

Steps

  1. Select the orcl dSource and Provision a VDB with the following details:

    • Destination Environment: Target
    • Database Unique Name: devdb
    • SID: devdb
    • Database Name: devdb
    • Mount Base: /mnt/provision

  2. Add the VDB to a new group called DB Targets

  3. Complete the VDB creation

It may take a couple minutes for the VDB creation to complete. You can monitor the progress on the left-hand side of the screen next to the devdb object in the DB Targets group. On the Actions pane on the right-hand side of the screen, you should see the Provision virtual database "devdb" item move to the Recently completed pane without error. Once the VDB is created, you can verify that the VDB is operational by:

  1. SSH to Linux Target as the delphix user

  2. Run the following commands:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1  
export ORACLE_SID=devdb  
export PATH=$ORACLE_HOME/bin:$PATH  
sqlplus / as sysdba  
select name from v$database;

Exercise 8 - Refresh a VDB

In this exercise, you will:

  • Create a new table on your source database

  • Snapshot the dSource

  • Refresh your VDB - devdb

  • Verify the new table appears on the VDB

Steps

  1. Connect to your Linux Source server as the delphix user via SSH

  2. Run the following commands:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1  
export ORACLE_SID=orcl  
export PATH=$ORACLE_HOME/bin:$PATH  
sqlplus / as sysdba  
create table sourcetab as select * from dba_objects;

  1. Go back to the Delphix Data Platform GUI

  2. Take a snapshot of the orcl dSource

  3. Select the devdb VDB and click the Refresh button

  4. Refresh the devdb VDB using the latest snapshot from the orcl dSource

Once the refresh has completed, you can log into devdb to confirm.

  1. Connect to your Linux Target server as the delphix user via SSH

  2. Run the following commands:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1  
export ORACLE_SID=devdb  
export PATH=$ORACLE_HOME/bin:$PATH  
sqlplus / as sysdba  
select count(*)
from sourcetab;

If this returns a count of rows, the snapshot/refresh was successful.

Exercise 9 - Rewind a VDB

In this exercise, you will:

  • Take a snapshot of the devdb VDB

  • Corrupt the devdb VDB to introduce a bootstrap error

  • Rewind the devdb VDB to recover from the error

Steps

  1. Take a snapshot of the devdb VDB and note the time

  2. Connect to your Linux Target server as the delphix user via SSH

  3. Run the following commands:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1  
export ORACLE_SID=devdb  
export PATH=$ORACLE_HOME/bin:$PATH  
sqlplus / as sysdba  
delete from sys.obj$;  
commit;  
shutdown abort;  
startup;

Note that the database is unable to come online due to a bootstrap error. The devdb database is now corrupted. Now we will rewind the VDB to the last good snapshot to fix this.

  1. Select the devdb VDB

  2. Select the snapshot associated with the date/time you recorded prior to corrupting your database.

  3. Rewind the VDB to the snapshot you took prior to the corruption.

Once the rewind operation is complete, you can confirm the rewind was successful by connecting to the server again and querying the database:

  1. Connect to your Linux Target server as the delphix user via SSH

  2. Run the following commands:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1  
export ORACLE_SID=devdb  
export PATH=$ORACLE_HOME/bin:$PATH  
sqlplus / as sysdba  
select count (*)
from dba_objects;

The count should come back clean, and the database is online

Exercise 10 - Set a New Retention Policy

There are four types of Policies in Delphix. In this exercise, you will:

  • Create a Retention Policy

  • Set the new policy to keep snapshots and logs for 30 days, along with 3 monthly snapshots

  • Apply the policy to the VDB we created in the previous exercise

Steps

  1. Navigate to Manage -> Policies

  2. Create a new retention policy for devdb with the following details:

    • Name: Long Term
    • 30 days of snapshot and log retention
    • 3 monthly snapshots taken on the 1st of the month

Exercise 11 - Create and Save a Hook Operation Template

In this exercise, you will:

  • Create a Hook Operation Template called Create APPUSER

  • Insert code into the template that will log into a database and add a user named appuser

Steps

  1. Create a new Hook Operation Template called: Create APPUSER

    • Type: Shell Command
    • Contents (enter exactly):
$ORACLE_HOME/bin/sqlplus / as sysdba << EOF  
create user appuser identified by appuser;  
grant connect, resource to appuser;  
exit;  
EOF

IMPORTANT: Make sure the carriage returns you see here are the same in the pasted contents.

  1. Finish and verify the Hook Operation Template appears in the list.

Exercise 12 - Create a VDB Template

In this exercise, you will:

  • Create a VDB Configuration template called 1G Template

  • Set a custom Oracle parameter for this template

Steps

  1. Navigate to Manage -> VDB Config Templates

  2. Create a new Template with the name: 1G Template

  3. Add a parameter to the template with the details:

    • Name: memory_target
    • Value: 1G

You can verify that this was successful by returning to the VDB Configuration Templates Wizard and clicking on the 1G Template item.

Exercise 13 - Provision a VDB with Hook and VDB Template

In this exercise, you will:

  • Create a VDB called qadb on Target

  • Use the VDB Configuration Template we created previously

  • Use the Hook Operation Template we created previously

  • Log into the VDB

  • Verify the VDB Configuration Template and Hook Operation Template were successful

Steps

  1. Select the orcl dSource and Provision a VDB with the following details:

    • Destination Environment: Target
    • Database Unique Name: qadb
    • SID: qadb
    • Database Name: qadb
    • Mount Base: /mnt/provision
    • Configuration Template: 1G Template
    • Group: DB Targets
    • Configure Clone hook: Create APPUSER

  2. Complete the VDB creation

It may take a couple minutes for the VDB creation to complete. You can monitor the progress on the left-hand side of the screen next to the qadb object in the DB Targets group. On the Actions pane on the right-hand side of the screen, you should see the Provision virtual database "qadb" item move to the Recently completed pane without error. Once the VDB is created, you can verify that the VDB is operational by:

  1. SSH to Linux Target as the delphix user

  2. Run the following commands:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1  
export ORACLE_SID=qadb  
export PATH=$ORACLE_HOME/bin:$PATH  
sqlplus / as sysdba  
show parameter memory_target  
connect appuser/appuser

This will verify that the VDB is online with the VDB Configuration Template we specified, and that the APPUSER user was created by our hook.

Optional Advanced Exercise - Measure Network Performance Test through the CLI

In this exercise, you will:

  • Log into the Delphix Data Platform CLI as delphix_admin

  • Perform a network latency test to Target

  • Perform a network throughput test to Target

Steps

As an advanced exercise, this lab has no corresponding Lab Solution. Instead, we will walk through the steps to get you acquainted the Delphix CLI for delphix_admin.

  1. On your Lab Server desktop, double-click on Terminal

  2. Type: ssh delphix_admin@10.0.x.10 ('x' is your Student Number assigned by your instructor)

    • If you receive a prompt asking you if you are sure you want to connect, enter: Yes
    • Enter the password: delphix
    • You are now at the root of the Delphix CLI as a Delphix Administrator

  3. Create a network latency test by typing: network test latency create

    • List the default/required parameters by typing: get
    • Set the remoteHost value to the TargetA environment IP address: set remoteHost=10.0.x.30 ('x' will be your Student Number )
    • Begin the test by typing: commit

images/download/attachments/90014970/worddav0139095d623cae0998262de02bb1691f.png
Example Network Latency Test Submission

  1. View the results of the latency test:
    • Get to the latency test section again by typing: network test latency
    • List the completed tests by typing: ls
    • Type "select" followed by the name of the test from the list. For example: select 10.0.1.30-2015-09-18T12:47:19.711Z
    • View the results of the test by typing: get

images/download/attachments/90014970/worddav5cd595732a91c4949a7d45cc11817a03.png
Example Network Latency Test Results

  1. Create a network throughput test
    • While still logged into the CLI, return to the root by typing: cd /
    • Begin a network throughput test by typing: network test throughput create
    • List the default/required parameters by typing: get
    • Set the remoteHost value to the TargetA environment IP address: set remoteHost=10.0.x.30 ('x' will be your Student Number )
    • Begin the test by typing: commit

images/download/attachments/90014970/worddave239dfc61608945149c6149c28b02a47.png
Example Network Throughput Test Submission

  1. View the results of the throughput test:

    • Get to the throughput test section again by typing: network test throughput

    • List the completed tests by typing: ls

    • Type "select" followed by the name of the test from the list. For example:
      select 10.0.1.30-2015-09-18T13:13:08.152Z

    • View the results of the test by typing: get

images/download/attachments/90014970/worddav9e53b8c32beb01659562abff9d1d08f2.png
Example Network Throughput Test Results

Optional Advanced Exercise - Configure Delphix Replication

Note: This exercise is only possible if your classroom has been configured with 2 or more students.
In this exercise, you will:

  • Set up a replication profile

  • Replicate your entire Delphix Data Platform to another Delphix Data Platform

  • View the replicas in the target Delphix Data Platform

Steps

As an advanced exercise, this lab has no corresponding Lab Solution. Instead, we will walk through the steps to get you acquainted the Delphix Replication capability.

  1. In the Delphix GUI, select System and then Replication on the top menu bar

  2. Add a Replication Profile called DR Replica

1. Click the _plus sign_ next to Replication Profiles on the top left 

2. Enter a Replica Profile Name: **DR Replica**

3. For Target Engine, enter the Delphix Data Platform IP address for the next student in your classroom environment. If you are the last student, use the Delphix Data Platform IP address for Student 1. For example, in a class with 3 students: 

  1. Student 1 Delphix Data Platform is at 10.0.1.10, and they will replicate to 10.0.2.10 

  2. Student 2 Delphix Data Platform is at 10.0.2.10, and they will replicate to 10.0.3.10 

  3. Student 3 Delphix Data Platform is at 10.0.3.10, and they will replicate to 10.0.1.10 

  4. Ask your instructor if you have any questions or confusion about this configuration. 

4. Enter the User Name: **delphix_admin**

5. Enter the Password: **delphix**

6. Do not enable Automatic Replication or configure Traffic Options 

7. For the Objects Being Replicated, select: Entire Delphix Data Platform 

8. Click Create at the bottom when ready.

images/download/attachments/90014975/worddav892f37fcc41eec5642f2ce204a8ac523.png
Replication Profile Configuration

  1. Start the Replication by clicking the Replicate Now button on the top right of your screen.

  2. Click Replicate to confirm you are ready to begin.

  3. Once the initial full replication is complete, you will see a message stating "Last Replication Successful."

images/download/attachments/90014975/worddav8d798fb1b60e755ddef9b7fd43921cb4.png
Example Successful Replication

  1. Check the results on your target Delphix Data Platform
1. In your lab server browser, enter the IP address you used for the Target Engine in your replica profile. For example, if you are Student 1, your Delphix Data Platform is at 10.0.1.10, and your target would have been 10.0.2.10. 

2. Log in as user delphix_admin with the password delphix 

3. Observe the dropdown list under Datasets on the top left corner of your screen. It should have _Default_ _shown_ which is the default **Namespace** for Delphix replica targets. 

4. In order to see the replica objects, click on the dropdown list and select the second entry, which should reflect the hostname of the source Delphix Data Platform that sent the replica.

Note: The hostname shown in the labs is based on the default hostname given to the Delphix Data Platform in Amazon AWS, consisting of the prefix "ip" followed by the IP address separated by hyphens.
images/download/attachments/90014975/worddavd8dc04440e9526f5f74c484752534a9e.png
Example Received Replica

  1. While still logged into your target Delphix Data Platform, click on System and then Replication

  2. Observe the Received Replicas section at the bottom, indicating and verifying the target's receipt of replication data.

1. Note: The _Failover Now_ option will not work for these labs due to namespace collisions. This is an inherent outcome to plan for when using Active/Active replication.

Lab Solutions

Exercise 1 - Delphix Data Platform Setup

  1. Connect to your Delphix Data Platform using Firefox on your lab server. The IP address will be 10.0.x.10, where "x" is your Student Number.

  2. Review the Welcome page to understand the setup process

  3. Set an email address and new password for the sysadmin user and click Next.

  4. Configure Delphix to use NTP time with the pool.ntp.org NTP server. Change the timezone to your local timezone. Then click Next.

  5. Review the network configuration and click Next. Do not make any changes to this section.

  6. Review the disk layout and click Next. Do not make any changes to this section.

  7. Review the Serviceability options and uncheck the "Enable phone home service" box then click Next.

  8. Review the Authentication Service options and click Next. Do not make any changes to this section.

  9. Click Next on the Registration page without making any changes.

  10. Review the summary and click Submit to complete the System configuration.

images/download/attachments/90014980/worddav884803a671a3a90197b7d01229216b13.png
Figure 1 Delphix Setup Summary Screen

  1. Click Submit to save the configuration.

  2. Click OK to acknowledge completion

  3. Log in with credentials:

1. Username: delphix_admin 

2. Password: delphix

images/download/attachments/90014980/worddav7d861fd3e487a3858cfa4de610f1c8a4.png
Figure 2 Delphix Data Platform Login

  1. Set an email address and new password for the delphix_admin user

images/download/attachments/90014980/worddaveb7137980f717f6ec84593bf29eb5cd5.png
Figure 3 Delphix Data Platform Home Page

Exercise 2 - Create the "delphix_db" User

  1. Connect to your Linux Source by opening Terminal on your Lab Server and running: conn 10.0.x.20 ('x' will be your Student Number ).

  2. Observe the name and location of the hostchecker package by running the command: ls -ltr

  3. Expand the hostchecker package by running: tar -xvf hostchecker_linux_x86.tar

  4. Type: cd hostchecker

  5. Observe the files present in this folder, which we will be using again: ls -ltr

  6. Set the Oracle environment variables below:

1. export ORACLE_SID= **orcl**

2. export ORACLE_HOME= **/u01/app/oracle/product/11.2.0/dbhome_1**

  1. Run the command: ./createDelphixDBUser.sh

  2. Press Enter to accept the default instance name (orcl)

  3. Enter the Delphix DB User Username: delphix_db

  4. Enter the Delphix DB User Password: delphix_db

  5. Type 'n' and press enter to accept the default to grant SELECT ANY DICTIONARY

images/download/attachments/90014984/worddavcc5beabba99812ed323b1a4c642a1f82.png
Figure 4 hostchecker createDelphixUser.sh

Exercise 3 - Validate the Source Environment with Hostchecker

  1. Connect to your Linux Source by opening Terminal on your Lab Server and running: conn 10.0.x.20 ('x' will be your Student Number ).

  2. Set the Oracle environment variables below:

1. export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 

2. export ORACLE_SID=devdb 

3. export PATH=$ORACLE_HOME/bin:$PATH

  1. Ensure you are inside the hostchecker location with the command: cd /home/delphix/hostchecker

  2. Run Hostchecker utility by typing1 the command: ./hostchecker.sh

  3. Indicate that this machine is a "source" by typing: source

  4. Review the available checks that can be run on this system

  5. Type "1" and press Enter. The script will check homedir permissions and return SUCCESS and ALL OK.

images/download/attachments/90014986/worddav69c02f4111ca93cfa86a348cb497e2c4.png
Figure 5 Hostchecker Options

  1. Type "3" and press Enter.
1. Enter an IP address of: 10.0.x.10 ('x' will be your **Student Number** ). 

2. Enter the port: 8415 

3. The script will test the port and return SUCCESS and ALL OK.

  1. Repeat the previous step for the following ports: 8341, 50001, and 873

  2. Type "5" and press Enter.

1. Type "1" to select the current ORACLE_HOME value, and press Enter 

2. The script will test the Oracle Home and return SUCCESS and ALL OK
  1. Type "6" and press Enter.
1. Type "0" to select all Oracle Instances, and press Enter 

2. The script will test the Oracle Instances and return SUCCESS and ALL OK

  1. Type "7" and press Enter. The script will test the /etc/oratab file and return SUCCESS and ALL OK

  2. Type "8" and press Enter.

1. Enter a password of: delphix 

2. The script will test the SSH connectivity to the host and return SUCCESS and ALL OK.
  1. Type "9" and press Enter.
1. The script will return a WARNING due to permissions. This is normal.
  1. Type "10" and press Enter.
1. Enter a password of: delphix 

2. The script will test sudo privileges and return SUCCESS and ALL OK
  1. Type "11" and press Enter.
1. Enter a path of: /u01/app/toolkit 

2. The script will test the path and return SUCCESS and ALL OK
  1. Type "quit" to exit hostchecker.

Exercise 4 - Add a Source Environment and Link a dSource

Add Source Environment

  1. If you are not already logged in, login to your Delphix Data Platform as delphix_admin using the password you set in the last exercise.

  2. In the top menu bar, click Manage and then Environments.

  3. Click on the fly-out menu next to Environments and select Add Environment.

  4. Provide the following details in the Add Environment Wizard

Host and Server

  1. 1. Host OS: **Unix/Linux**

2. Server Type: **Standalone**

Click Next

  1. On the Environment Settings tab, enter the following details
1. Environment Name: **Source**

2. Host Address: **10.0.x.20** ('x' will be your **Student Number** ) 

3. OS Username: **delphix**

4. OS Password: **delphix**

5. Toolkit Path: **/u01/app/toolkit** ![images/download/attachments/90014988/worddavc3796a976e24745bf4ac3024f9785ddd.png](images/download/attachments/90014988/worddavc3796a976e24745bf4ac3024f9785ddd.png)

Figure 6 Add Source Environment

  1. Click Submit

  2. You can view the status of the environment creation and discovery by clicking on the Actions menu on the top right-hand side of the page. Clicking on the job in the Actions pane will allow you to track its progress

images/download/attachments/90014988/worddav83163305f2e41324dae86bd4c1ddc762.png
Figure 7 Environment Creation Progress

  1. View the Environment details
1. Click on the Environment on the left on review information on the Details tab

images/download/attachments/90014988/worddavdf8f03c9636175dcbd6b8c44f66b55d1.png

  1. 1. Click on the Databases tab to view any discovered database installations and databases

images/download/attachments/90014988/worddava75f3fd10684bdddcb7734fc874bb0da.png
Create dSource:

  1. On the top menu bar, click Manage , then Datasets

  2. Click the plus sign next to the word Datasets on the top left portion of your screen and select the Add dSource option.

images/download/attachments/90014988/worddave4d3707d49d69a42344c9d73c7c6478c.png
Figure 8 Add dSource

  1. The Welcome page for the dSource Wizard will be displayed. Review the instructions to get an overview of the process and click Next.

  2. Enter the following information on the Source tab

1. Select the **_orcl_** database from Data Source list 

2. Choose delphix from the Environment User drop-down list (default) 

3. Enter the DB Username and Password: 

  1. DB Username: **delphix_db**

  2. DB Password: **delphix_db**

4. Click _Verify Credentials_

images/download/attachments/90014988/worddavd3e4a62eb517e9fd74c2bcb075f768ad.png

  1. Under the dSource Configuration tab we will provide a user-friendly name for the dSource and create a new Dataset Group to place it in.
1. Enter " **orcl** " for the dSource name 

2. Click on the Add Dataset Group link and enter " _DB Sources_ " in the Name field. ![images/download/attachments/90014988/worddavd3aa2dfac65d5d47a50341d99c62b2ef.png](images/download/attachments/90014988/worddavd3aa2dfac65d5d47a50341d99c62b2ef.png)

Figure 9 dSource Configuration

  1. Click Next

  2. On the Data Management tab, accept the default values and

  3. Click Next

  4. Accept the default policies

  5. Click Next

  6. No Hooks will be added at this point. Click Next

  7. Review the summary and click Submit

images/download/attachments/90014988/worddavf2df57af70118181aec443407a2d7375.png
Figure 10 Add dSource Summary

  1. Wait for the dSource to be created

images/download/attachments/90014988/worddave89d449f4724681413577b38c45eab54.png
Figure 11 Completed dSource

Exercise 5 - Validate the Target Environment with Hostchecker

  1. Connect to your Linux Target A by opening Terminal on your Lab Server and running: conn 10.0.x.30 ('x' will be your Student Number ).

  2. Observe the name and location of the hostchecker package by running the command: ls -ltr

  3. Expand the hostchecker package by running: tar -xvf hostchecker_linux_x86.tar

  4. Type: cd hostchecker

  5. Run hostchecker.jar with the command: ./hostchecker.sh

  6. Indicate that this machine is a "target" by typing: target

  7. Review the available checks that can be run on this system

  8. Type "1" and press Enter. The script will check homedir permissions and return SUCCESS and ALL OK.

images/download/attachments/90014998/worddav6886302ffb660551c4940da4f14632d8.png
Figure 12 Hostchecker Target Options

  1. Type "3" and press Enter.
1. Enter an IP address of: 10.0.x.10 ('x' will be your **Student Number** ). 

2. Enter the port: 8415 

3. The script will test the port and return SUCCESS and ALL OK.

  1. Repeat the previous step for the following ports: 873, 22, 80, 443

  2. Type "5" and press Enter.

1. Type "1" to select the current ORACLE_HOME value, and press Enter 

2. The script will test the Oracle Home and return SUCCESS and ALL OK

  1. Type "6" and press Enter. The script will test the /etc/oratab file and return SUCCESS and ALL OK

  2. Type "7" and press Enter.

1. Enter a password of: delphix 

2. The script will test the SSH connectivity to the host and return SUCCESS and ALL OK.
  1. Type "8" and press Enter.
1. The script will return WARNING due to permissions. This is normal.
  1. Type "9" and press Enter.
1. Enter a password of: delphix 

2. The script will test sudo privileges and return SUCCESS and ALL OK
  1. Type "10" and press Enter.
1. Enter a path of: /u01/app/toolkit 

2. The script will test the path and return SUCCESS and ALL OK
  1. Type "quit" to exit hostchecker.

Exercise 6 - Add Target Environment

  1. If you are not already logged in, login to your Delphix Data Platform as delphix_admin using the password you set in the last exercise.

  2. In the top menu bar, click Manage and then Environments.

  3. Click on the fly-out menu next to Environments and select Add Environment.

  4. Provide the following details in the Add Environment Wizard

Host and Server

  1. 1. Host OS: Unix/Linux 

2. Server Type: Standalone

Click Next

  1. On the Environment Settings tab, enter the following details
1. Environment Name 

2. Host Address: 10.0.x.30 ('x' will be your **Student Number** ) 

3. OS Username: delphix 

4. OS Password: delphix 

5. Click Validate 

6. Toolkit Path: /u01/app/toolkit ![images/download/attachments/90015000/worddavb03522a9c56f481e4d8c97d5363ccc53.png](images/download/attachments/90015000/worddavb03522a9c56f481e4d8c97d5363ccc53.png)

Figure 13 Add Target Environment

  1. Click Submit

  2. You can view the status of the environment creation and discovery by clicking on the Actions menu on the top right-hand side of the page. Clicking on the job in the Actions pane will allow you to track its progress.

  3. View the Environment details

1. Click on the Environment Name on the left on review information on the Details tab

images/download/attachments/90015000/worddav3ed706f710a17f6500b5fb4222895be8.png

  1. 1. Click on the Databases tab to view any discovered database installations and databases

images/download/attachments/90015000/worddav700443e673fbfa191ffbfd0e690470d1.png

Exercise 7 - Provision a VDB

  1. Go the Datasets Home page by Clicking on the Manage menu and selecting Datasets

  2. Expand the DB Source group and click on the orcl dSource object. This will reveal the Timeflow for the dSource by default.

  3. Hovering over the Timeflow snapshot will reveal icons to provision a VDB, view LogSync and other information.

Click on the Provision VDB icon images/download/attachments/90015004/worddav91efaac4bb798dddfe0bd8e7bade7c37.png
images/download/attachments/90015004/worddav989c427644b4991a211f98289a04819d.png
Figure 14 Provision VDB

  1. On the Target Environment tab, use the following information
1. Choose _Target_ under the list of Environments 

2. Verify that the Installation Home is set to  /u01/app/oracle/product/11.2.0/dbhome_1 (11.2.0.1.0) 

3. Ensure that the Environment User is set to delphix 

4. Click Next

images/download/attachments/90015004/worddaveb19d81e3200d1a3f524dffb40482c11.png
Figure 15 Provision VDB - Target Environment

  1. Enter the details below on the Target Configuration tab
1. Database Unique Name: **devdb**

2. Database Name: **devdb**

3. SID: **devdb**

4. Mount Base: **/mnt/provision**

images/download/attachments/90015004/worddav8e509b20735b750221a4029655e89848.png
Figure 16 Provision VDB - Target Configuration

  1. Click Next

  2. On the Configuration tab, we will provide a user-friendly name for the VDB as well as assign it to a new group.

1. VDB Name: **devdb**

2. Click Add Dataset Group 

  1. Enter _DB Targets_ for the Group Name 

  2. Click Add 

3. Verify that the _DB Targets_ Group is selected 

4. Masking Job should be set to None 

5. Check the box next to Enabled for _Auto VDB Restart_

6. Click _Next_

images/download/attachments/90015004/worddavd52bd451ed02c87a21986691c5d674c1.png
Figure 17 Provision VDB - Configuration

  1. On the Policies tab, accept the defaults and click Next

  2. Accept the defaults on the Hooks tab and click Next

  3. Verify the summary information, and click Submit

images/download/attachments/90015004/worddava1ce2c267131273f14a4411a4c34dff4.png
Figure 18 Provision VDB Summary
It may take a couple minutes for the VDB creation to complete. You can monitor the progress on the left hand side of the screen next to the devdb object in the DB Targets group. On the Actions pane on the right hand side of the screen, you should see the Provision virtual database "devdb" item move to the Recently completed pane without error.
Once the VDB is created, you can verify that the VDB is operational by:

  1. Using Terminal on your lab server, SSH to your Linux Target server at 10.0.x.30 ('x' will be your Student Number ).

  2. Enter the username: delphix

  3. Enter the password: delphix

  4. Run the following commands:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1  
export ORACLE_SID=devdb  
export PATH=$ORACLE_HOME/bin:$PATH  
sqlplus / as sysdba  
select name from v$database;

images/download/attachments/90015004/worddav778ba7ea300ef97f096a94007d8263f3.png
Figure 19 Validate VDB

Exercise 8 - Refresh a VDB

  1. Open Terminal on your Lab Server desktop and type: ssh delphix@10.0.x.20 ('x' will be your Student Number )

  2. Enter the username: delphix

  3. Enter the password: delphix

  4. Run the following commands:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1  
export ORACLE_SID=orcl  
export PATH=$ORACLE_HOME/bin:$PATH  
sqlplus / as sysdba  
create table sourcetab as select * from dba_objects;

  1. Go back to the Delphix Data Platform in your browser (click the Delphix logo to go back to the main screen if required)

  2. Click on the orcl dSource object on the left side of your screen (expand DB Source group if needed)

  3. Click the Camera Icon on the top-right to take a snapshot

images/download/attachments/90015012/worddav1e2715ebc1af0cb0f3ed12c9f73a33a6.png
Figure 20 Snapshot dSource

  1. Click on the devdb VDB on the left side of your screen

  2. Click the Timeflow tab

  3. Click the Refresh button on the top right next to the snapshot icon.

  4. There are two options for refreshing the VDB, choose the "Faster" option to refresh from the most recent snapshot and click Next.

images/download/attachments/90015012/worddav39620dd80c9e65dff3a32083ab8f6477.png
Figure 21 Refresh VDB

  1. Click the Submit button

images/download/attachments/90015012/worddav563e9fc2b32b04a4a50e75ec6e968432.png
Figure 22 Refresh VDB from dSource
Once the refresh has completed, a new VDB snapshot will be generated and reflected in the Timeflow.
images/download/attachments/90015012/worddav7df25fdd3dbcc04ee889b719a02c0aa9.png
Figure 23 VDB Refresh - Post Refresh
Log into devdb to confirm.

  1. Open Terminal on your Lab Server desktop and type: ssh delphix@10.0.x.30 ('x' will be your Student Number )

  2. Enter the username: delphix

  3. Enter the password: delphix

  4. Run the following commands:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1  
export ORACLE_SID=devdb  
export PATH=$ORACLE_HOME/bin:$PATH  
sqlplus / as sysdba  
select count (*)
from sourcetab;

images/download/attachments/90015012/worddav6ca36a61e719ef0579cd3dee626b0fb7.png
Figure 24 Validate Refresh
If this returns a count of rows, the snapshot/refresh was successful.

Exercise 9 - Rewind a VDB

  1. On the Delphix main screen, select the devdb VDB

  2. Click the Camera icon on the top right to take a snapshot of the VDB

images/download/attachments/90015018/worddav6491094f2b9c725dd7e347cd35c52fe6.png
Figure 25 Snapshot VDB

  1. A new snapshot card will be created on the devdb Timeflow. Make a note of the date/time for the latest snapshot card.

  2. Open Terminal on your Lab Server desktop and type: ssh delphix@10.0.x.30 ('x' will be your Student Number )

  3. Enter the username: delphix

  4. Enter the password: delphix

  5. Run the following commands:

export ORACLE_SID=devdb  
sqlplus / as sysdba  
delete from sys.obj$;  
commit;  
shutdown abort;  
startup;

images/download/attachments/90015018/worddav1a870f563672c4eb83819214421fe5f9.png
Figure 26 Corrupt VDB
Note that the database is unable to come online due to a bootstrap error. The devdb database is now corrupted. Now we will rewind the VDB to the last good snapshot to fix this.

  1. In the Delphix Data Platform (web browser), click on the devdb VDB if it is not already selected

  2. Click on the Timeflow tab and select the snapshot associated with the date/time you recorded prior to corrupting your database. This will most likely be the latest snapshot.

  3. Hover over the snapshot to reveal the Rewind button.

  4. Click the Rewind VDB button on the Timeflow

images/download/attachments/90015018/worddaveeaed3b3e48c0485fe1799716c0ee02c.png
Figure 27 Rewind VDB

  1. Confirm that you wish to rewind the VDB by clicking Rewind.

images/download/attachments/90015018/worddavd091785c07b9e696c21c15421e23369a.png
Figure 28 Rewind VDB Dialog
Once the rewind operation is complete, you can confirm the rewind was successful by connecting to the server again and querying the database:

  1. Open Terminal on your Lab Server desktop and type: ssh delphix@10.0.x.30 ('x' will be your Student Number )

  2. Enter the username: delphix

  3. Enter the password: delphix

  4. Run the following commands:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1  
export ORACLE_SID=devdb  
export PATH=$ORACLE_HOME/bin:$PATH  
sqlplus / as sysdba  
select count
from dba_objects;

images/download/attachments/90015018/worddav0bc5f85f988526df169c88ee2c1d76da.png
Figure 29 Validate VDB Rewind

Exercise 10 - Set a New Retention Policy

  1. In the top menu bar, click on Manage and then Policies

  2. Click the Retention tab, click +Retention

  3. Provide the following details:

1. Policy Name: **Long Term**

2. Keep Logs for: **30 days**

3. Keep Snapshots for: **30 days**

  1. Click the Show a dvanced link

  2. Click the checkbox next to Keep 3 Snapshot(s) on 1 st of every month

images/download/attachments/90015024/worddave2f1002a30fe0f11542ce0595fc2fe20.png
Figure 30 Create Retention Policy

  1. Click Next

  2. On the Datasets tab click the checkbox for the devdb

  3. Click Submit

images/download/attachments/90015024/worddavfe351459ddc92242ccc386ab4ae6676e.png
Figure 31 Apply Retention Policy
Expand the policies menu to validate that the new Long Term policy has been applied to the devdb VDB.
images/download/attachments/90015024/worddavd0368a84bb343d0bb229d9ff5b37909a.png
Figure 32 Retention Policy Settings

Exercise 11 - Create and Save a Hook Operation Template

  1. In the top menu bar, click Manage , then Operation Templates

  2. Click the plus sign under the word Templates in the Hook Operation Templates Wizard

  3. Provide the Name : Create APPUSER

  4. Ensure Type is set to: System Shell Command

  5. Under Contents , enter the following code:

$ORACLE_HOME/bin/sqlplus / as sysdba << EOF
create user appuser identified by appuser;
grant connect, resource to appuser;
exit;
EOF
images/download/attachments/90015028/worddav61896caeb79d4fe0ed7906fc6d1286c8.png
Figure 33 Create Hook Operation Template

  1. Click Create

  2. Verify the Hook Operation Template is in the list, then click Close

images/download/attachments/90015028/worddavc67c614cf40ab88039d43969df0ab068.png
Figure 34 Hook Template

  1. Figure Verify Hook Operation Template

Exercise 12 - Create a VDB Template

  1. In the top menu bar, click Manage , then VDB Config Templates

  2. Click the plus sign next to the word VDB Config Templates and select New Template from the drop-down.

  3. Name: 1G Template

  4. Click Create

  5. Click the pencil icon on the top right of the VDB Configuration Templates screen

  6. Click the plus sign on the top right to add a new parameter

1. Double-click the row to enter a new value
  1. In the row that is now highlighted, enter the following information:
1. Name: **memory_target**

2. Value: **1G**
  1. Click the checkmark to save the Template.

images/download/attachments/90015031/worddav3c33aac4d97f34b4d862fb8068a134b2.png
Figure 35 Create VDB Configuration Template

Exercise 13 - Provision a VDB with Hook and VDB Template

  1. Return to the Delphix home screen by clicking the Delphix logo on the top left of the screen

  2. Click on the orcl dSource object in the Datasets panel

  3. Select the latest Snapshot, click the Provision button

  4. On the left hand side of the Target Environment tab, click the Target environment Target

  5. Click Next

  6. On the Target Configuration tab, enter the following details:

1. Database Unique Name: **qadb**

2. SID: **qadb**

3. Database Name: **qadb**

4. Mount Base: **/mnt/provision** (this should already be filled in)
  1. Click the Show advanced link and check the box next to Configure VDB Config Templates

images/download/attachments/90015033/worddavae596b706fa619afdb84d4baaad680fa.png
Figure 36 Provision VDB w/ Config Template

  1. Click Next

  2. Click the 1G Template that we created earlier from the Select template drop-down list

images/download/attachments/90015033/worddav6102cae626377b6055d24ab01d0b5b9d.png
Figure 37 Apply VDB Config Template

  1. Click Next

  2. Accept the default VDB Name - qadb

  3. Select DB Targets from the Datasets Group drop-down list, then click Next

  4. Accept the default policies and click Next

  5. On the Hooks tab with Configure Clone already selected on the left side of the Provision VDB Wizard , click the plus sign on the right hand side of the wizard and select "Create New from Template" from the drop-down list

  6. Enter the name QA APPUSER for the Hook Operation and click the Create button

images/download/attachments/90015033/worddav7803f21c6a8565d2dada17c7b1e6446e.png
Figure 38 Add Hook Template

  1. Click on the Create APPUSER template we created earlier, then click Import

images/download/attachments/90015033/worddava8380050555bf3d5d16dca6dc82597b5.png
Figure 39 Configure Clone Hook Operation Template

  1. Click Next

images/download/attachments/90015033/worddav4b552b06226adda4792d6b73429f3aa4.png
Figure 40 Provision VDB Summary

  1. Verify the summary information, and click Submit

It may take a couple minutes for the VDB creation to complete. You can monitor the progress on the left-hand side of the screen next to the qadb object in the DB Targets group. On the Actions pane on the right-hand side of the screen, you should see the Provision virtual database "qadb" item move to the Recently completed pane without error.
Once the VDB is created, you can verify that the VDB is operational by:

  1. Using Terminal on your lab server, SSH to your Linux Target server at 10.0.x.30 ('x' will be your Student Number ).

  2. Enter the username: delphix

  3. Enter the password: delphix

  4. Run the following commands:

export ORACLE_SID=qadb  
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1  
export PATH=$ORACLE_HOME/bin:$PATH  
sqlplus / as sysdba  
show parameter memory_target  
connect appuser/appuser

This will verify that the VDB is online with the VDB Configuration Template we specified, and that the APPUSER user was created by our hook.
images/download/attachments/90015033/worddav577a9fc094da1d2e2115572064923b12.png
Figure 41 View VDB Parameters