Delphix Admin Training for Oracle

LAB GUIDE

Getting Started 1
© 2015 Delphix Corp. All rights reserved
Table of Contents
TABLE OF CONTENTS ......................................................................................................................................................................................... 2
GETTING STARTED ............................................................................................................................................................................................... 3
W ELCOME TO THE DELPHIX ADMIN TRAINING FOR ORACLE LAB GUIDE .................................................................................................................. 3
LAB REQUIREMENTS...................................................................................................................................................................................................................... 3
THE DELPHIX ADMIN TRAINING CLOUD LAB......................................................................................................................................................................... 3
IMPORTANT IP ADDRESSES ........................................................................................................................................................................................................ 4
CLOUD LAB USERNAMES AND PASSWORDS ........................................................................................................................................................................ 4
GUIDE LAYOUT........................................................................................................................................................................................................ 5
LAB EXERCISES ..................................................................................................................................................................................................... 6
EXERCISE 1 – LOGGING INTO THE DELPHIX ENGINE UI .................................................................................................................................................. 6
EXERCISE 2 – CREATE THE “DELPHIX_DB” USER .............................................................................................................................................................. 8
EXERCISE 3 – VALIDATE THE SOURCE AND TARGET ENVIRONMENT WITH HOSTCHECKER .............................................................................. 9
EXERCISE 4 – ADD A SOURCE ENVIRONMENT ................................................................................................................................................................. 13
EXERCISE 5 – LINK A DSOURCE ............................................................................................................................................................................................ 15
EXERCISE 6 – ADD TARGET ENVIRONMENTS ................................................................................................................................................................... 19
EXERCISE 7 – PROVISION A VDB ......................................................................................................................................................................................... 22
EXERCISE 8 – REFRESH A VDB ............................................................................................................................................................................................ 28
EXERCISE 9 – REWIND A VDB ............................................................................................................................................................................................... 31
EXERCISE 10 – SET A NEW RETENTION POLICY............................................................................................................................................................. 35
EXERCISE 11 – CREATE AND SAVE A HOOK OPERATION TEMPLATE ..................................................................................................................... 37
EXERCISE 12 – CREATE A VDB TEMPLATE ...................................................................................................................................................................... 39
EXERCISE 13 – PROVISION A VDB WITH HOOK AND VDB TEMPLATE ................................................................................................................... 40
OPTIONAL ADVANCED EXERCISE – DISCOVER AND LINK A 12C CONTAINER DATABASE DSOURCE .......................................................... 46
OPTIONAL ADVANCED EXERCISE – PROVISION A VIRTUAL PDB (VPDB) ............................................................................................................. 52
OPTIONAL ADVANCED EXERCISE – MEASURE NETWORK PERFORMANCE TEST THROUGH THE CLI ......................................................... 55
OPTIONAL ADVANCED EXERCISE – CONFIGURE DELPHIX REPLICATION............................................................................................................... 59

Getting Started 2
© 2015 Delphix Corp. All rights reserved
Getting Started
Welcome to the Delphix Admin Training for Oracle Lab Guide
This guide is a supplement to the Delphix Admin Training for Oracle course, and provides several
exercises to perform throughout the class. If you encounter any issues during the exercises, please
do not hesitate to ask your instructor for advice.
Lab Requirements
In order to perform these lab exercises, you will need:

✔ A modern HTML5 capable web browser (IE9+, Chrome, Firefox, Safari)

The Delphix Admin Training Cloud Lab
Your instructor should have provided you with a Class Name and a Student Number. In order to
access your lab server, point your web browser to: http://classname.agile.today/studentnumber

For example, if your Class Name is “acmetech” and your Student Number is 5, you would go to the
site: http://acmetech.agile.today/5

The Delphix Labs Login Dialog

At the login screen, enter the username and password: delphix/delphix

Once you have logged in, you will be connected to your lab server. This server contains everything
you will need to perform your lab exercises including:

• Terminal with SSH (or Putty) to connect to Linux source/target database servers
• Chrome Web Browser to connect to your Delphix Data Platform
• A copy of this lab guide
• Notepad for class notes
• Oracle SQL Developer for remote connections

Getting Started 3
© 2015 Delphix Corp. All rights reserved
IMPORTANT NOTE: Do not use the “Log Out” function on your lab server. If you do, it will break your
lab connection.

The Delphix Lab Server

Important IP Addresses
Delphix Data Platform 10.0.x.10
Linux Source 10.0.x.20
Linux Target 10.0.x.30

In the above IP addresses, the x denotes your Student Number. For example, if your student
number is 5, your Delphix Data Platform will be located at 10.0.5.10.
Cloud Lab Usernames and Passwords
Initial Delphix sysadmin password sysadmin
Initial Delphix admin password delphix
Source and Target delphix user password (via SSH) delphix
Source and Target oracle user password (via SSH) delphix

Getting Started 4
© 2015 Delphix Corp. All rights reserved
Guide Layout
The Lab Exercises in this guide provide the full details needed to perform each operation.

• Bold text is used to highlight application names (e.g. Terminal), keywords found in the UI (e.g.
Add Environment) and also for words that are part of an action (e.g. Click Submit)

• Bold and Italicized text is used to highlight text that must be typed in the UI, rather than
selected (e.g. Enter devdb).

• Courier font is used to reference commands entered on the command line or in sqlplus
(e.g. Type sqlplus / as sysdba)

• Dark Red is used to emphasize Notes

Getting Started 5
© 2015 Delphix Corp. All rights reserved
Lab Exercises
Perform these exercises when instructed by your Delphix Instructor.

Exercise 1 – Logging into the Delphix Engine UI

In this exercise, you will:

• Access the Delphix Data Platform GUI as the Delphix admin user
• Access the Delphix Data Platform GUI as the sysadmin user

Steps
1. Connect to your Delphix Engine using Chrome on your lab server (see the Important IP
Addresses section of the Getting Started guide above). The IP address will be 10.0.x.10,
where “x” is your Student Number
2. Login to the Delphix Dynamic Data Platform using the username admin and password delphix
3. Click Log In

4. In order to become more familiar with what is available here, browse around the various
sections of the landing page.
5. Click admin on the upper right side and logout
6. Click Setup (Located under Password) to navigate to Delphix Setup login
7. Login to Delphix Setup using the username sysadmin and password sysadmin
8. Click Log In

Getting Started 6
© 2015 Delphix Corp. All rights reserved
 9. In order to become more familiar with what is available here, browse around the various
sections of the landing page.

Related Links

The admin and sysadmin User Roles

Setting Up the Delphix Data Platform

Getting Started 7
© 2015 Delphix Corp. All rights reserved
Exercise 2 – Create the “delphix_db” User

In this exercise, you will:

• Create a Delphix DB User on your source database

Steps
1. Use the Terminal app on your Jumpbox desktop to connect into your Linux Source (see the
Important IP Addresses section of the Getting Started guide above).
a. Type ssh 10.0.x.20 (where “x” is your Student Number)
2. Extract the hostchecker_linux_x86.tar file in your home directory
a. Type ls -ltr
b. Type tar -xvf hostchecker_linux_x86.tar
3. Navigate to the hostchecker directory
a. Type cd hostchecker
b. Type ls -ltr (observe the files present in this folder, as we will be using them again)
4. Set the Oracle environment variables below:
a. Type export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
b. Type export ORACLE_SID=orcl
Note: ". oraenv" can be used to set the environment variable rather than export commands
5. Run the script to create the delphix_db user
a. Type ./createDelphixDBUser.sh
6. Use the following details during the running of this script:
a. The user will be created in the default instance orcl. This is set by the environment
variable ORACLE_SID.
Press Enter to accept the default database instance orcl
b. Delphix DB User Username: delphix_db
c. Delphix DB User Password: delphix_db
d. Decline the SELECT ANY DICTIONARY privilege. This is a sweeping privilege that is
not required, but optional
e. Type: n and press Enter

The script should create the user without error.

Getting Started 8
© 2015 Delphix Corp. All rights reserved
Exercise 3 – Validate the Source and Target Environment with Hostchecker

In this exercise, you will:

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

Steps to Validate the Source Environment with Hostchecker

1. Connect to your Linux Source by opening Terminal on your Lab Server

a. Type ssh 10.0.x.20 (‘x’ will be your Student Number).
2. Set the Oracle environment variables below:
a. Type export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
b. Type export ORACLE_SID=orcl
c. Type export PATH=$ORACLE_HOME/bin:$PATH
3. Ensure you are inside the hostchecker location
a. Type cd /home/delphix/hostchecker
4. Run Hostchecker utility
a. Type ./hostchecker.sh
5. Indicate that this machine is a source
a. Type source
6. Review the available checks that can be run on this system
7. Type 1 and press Enter
a. The script will check homedir permissions and return SUCCESS and ALL OK

8. Type 3 and press Enter

a. Enter an IP address of: 10.0.x.10 (‘x’ will be your Student Number).
b. Enter the port: 8415
c. The script will test the port and return SUCCESS and ALL OK.
Getting Started 9
© 2015 Delphix Corp. All rights reserved
 9. Repeat option 3 for the following ports: 8341 and 873
10. Type 5 and press Enter
a. Type 5 to select the ORACLE_HOME associated with the ‘orcl’ database
(/u01/app/oracle/product/11.2.0/dbhome_1), and press Enter
b. The script will test the Oracle Home and return SUCCESS and ALL OK
11. Type 6 and press Enter
a. Type 3 to select the Oracle Instance associated with the ‘orcl’ database, and press
Enter
b. Provide the Oracle home path at the prompt:
/u01/app/oracle/product/11.2.0/dbhome_1
c. Enter the username and password of the Oracle database user created in exercise 2
Username: delphix_db
Password: delphix_db
Note: If you created a database user with different credentials from the one shown
above, you will enter it at the prompt instead.
d. The script will test the Oracle Instances and return SUCCESS and ALL OK
12. Type 7 and press Enter
a. The script will test the /etc/oratab file and return SUCCESS and ALL OK
13. Type 8 and press Enter
a. Enter a password of: delphix
b. The script will test the SSH connectivity to the host and return SUCCESS and ALL OK.
14. Type 9 and press Enter
a. The script will return a WARNING due to permissions. This is normal.
15. Type 10 and press Enter
a. Enter a password of: delphix
b. The script will test sudo privileges and return SUCCESS and ALL OK
16. Type 11 and press Enter
a. Enter a path of: /u01/app/toolkit
b. The script will test the path and return SUCCESS and ALL OK
17. Type quit to exit hostchecker.
Were all tests successful? If not, which ones failed and why?
Note: In a production installation, the sshd_config test will return a WARNING response due to
permissions on the file. If hostchecker is run as root, for this test, it will perform the test
properly.
Steps to Validate the Target Environment with Hostchecker

1. Connect to your Linux Target A by opening Terminal on your Lab Server

a. Type ssh 10.0.x.30 (‘x’ will be your Student Number).
2. Extract the hostchecker_linux_x86.tar file in your home directory
a. Type ls -ltr
b. Type tar -xvf hostchecker_linux_x86.tar
3. Ensure you are inside the hostchecker location
a. Type cd /home/delphix/hostchecker
Getting Started 10
© 2015 Delphix Corp. All rights reserved
4. Run Hostchecker utility
a. Type ./hostchecker.sh
5. Indicate that this machine is a target
a. Type target
6. Review the available checks that can be run on this system

7. Type 1 and press Enter

a. The script will check homedir permissions and return SUCCESS and ALL OK

8. Type 3 and press Enter

a. Enter an IP address of: 10.0.x.10 (‘x’ will be your Student Number).
b. Enter the port: 8415
c. The script will test the port and return SUCCESS and ALL OK.
9. Repeat option 3 for the following ports: 873, 22, 80 and 443
10. Type 5 and press Enter
a. Type option 4 select the current ORACLE_HOME value, and press Enter
b. The script will test the Oracle Home and return SUCCESS and ALL OK
11. Type 6 and press Enter
a. The script will test the /etc/oratab file and return SUCCESS and ALL OK
12. Type 7 and press Enter
a. Enter a password of: delphix
b. The script will test the SSH connectivity to the host and return SUCCESS and ALL OK.
13. Type 8 and press Enter
a. The script will return WARNING due to permissions. This is normal.
14. Type 9 and press Enter
a. Enter a password of: delphix
b. The script will test sudo privileges and return SUCCESS and ALL OK
15. Type 10 and press Enter
a. Enter a path of: /u01/app/toolkit
b. The script will test the path and return SUCCESS and ALL OK
16. Type quit to exit hostchecker.
Getting Started 11
© 2015 Delphix Corp. All rights reserved
If you have completed all of the checks and they have returned SUCCESS and ALL OK, you
have completed this exercise.

Note: In a production installation, the sshd_config test will return a WARNING response, due to
permissions on the file. If hostchecker is run as root, for this test, it will perform the test
properly.

Getting Started 12
© 2015 Delphix Corp. All rights reserved
Exercise 4 – Add a Source Environment

In this exercise, you will:

• Connect Delphix to your Source Oracle Database server
• Create a Source Environment

Steps
1. Log into the Delphix Data Platform UI as the admin user and the password that was set during
the Engine setup.

Note: If you forgot your admin password, please ask your lab administrator to reset it.

2. Click the Manage menu and select Environments from the list
3. Click the ellipses (…) next to Environments then choose Add Environment

4. On the Host and Server select the following:

a. Host OS: Unix/Linux
b. Server Type: Standalone

5. For Environment Settings, provide the following information

a. Environment Name: Source
b. Host Address: 10.0.x.20 (‘x’ will be your Student Number)
c. NFS Addresses: 10.0.x.20 (‘x’ will be your Student Number)
d. Leave the DSP fields blank
e. Set Login Type to Username and Password
f. OS Username: delphix
g. OS Password: Delphix

Note: Enter the Toolkit Path before Validating the Username and Password
Getting Started 13
© 2015 Delphix Corp. All rights reserved
 h. Toolkit Path: /u01/app/toolkit
i. Click Validate

6. Click Next
7. Click Submit
8. 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 jobs lower right corner, in the
Actions pane, will allow you to track its progress

Getting Started 14
© 2015 Delphix Corp. All rights reserved
Exercise 5 – Link a dSource

In this exercise, you will:

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

Steps

1. View the Environment details

a. Click on the Environment on the left on review information on the Details tab

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

Getting Started 15
© 2015 Delphix Corp. All rights reserved
3. Link the orcl database
a. On the top menu, click the Manage menu and then Datasets
b. Click the + next to Datasets on the top left portion of your screen and then select Add
dSource

4. The Welcome page for the dSource Wizard will be displayed. Review the instructions to get an
overview of the process and click Next
5. Enter the following information on the Source tab
a. Select the orcl database from Data Source list
b. Choose delphix from the Environment User drop-down list (default)
c. Enter the DB Username and Password you created in Exercise 2:
i. DB Username: delphix_db
ii. DB Password: delphix_db
iii. Click Validate (if this step fails check that you have completed exercise 2 with
the correct information)
d. Click Next
6. 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.
a. Enter orcl for the dSource Name
b. Click on the Add Dataset Group link and enter Source DB in the Name field.

Getting Started 16
© 2015 Delphix Corp. All rights reserved
7. Click Next
8. On the Data Management tab accept the defaults
a. Initial Load: Immediately
b. LogSync: Enable
Archive + Online Redo
c. Click Next
9. Accept the Default SnapSync and Retention policy setting
10. Click Next
11. Accept defaults for the Hooks. No Hooks will be used.
12. Click Next
13. Review the Summary and click Submit.

Getting Started 17
© 2015 Delphix Corp. All rights reserved
 14. Wait for the dSource to be created

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. Also, the dSource state will change to Active

Getting Started 18
© 2015 Delphix Corp. All rights reserved
Exercise 6 – Add Target Environments

In this exercise, you will:

• Connect Delphix to your Target Oracle server

Steps
1. Log into the Delphix Data Platform UI as the admin user and the password that was set during
the Engine setup.
Note: If you forgot your admin password, please ask your lab administrator to reset it.
2. In the top menu bar, click Manage and then Environments.
3. Click the ellipses (…) next to Environments then choose Add Environment.
4. Provide the following details in the Add Environment Wizard
Host and Server
a. Host OS: Unix/Linux
b. Server Type: Standalone
Click Next
5. On the Environment Settings tab, enter the following details
a. Environment Name: Target
b. Host Address: 10.0.x.30 (‘x’ will be your Student Number)
c. NFS Addresses: 10.0.x.30 (‘x’ will be your Student Number)
d. Leave the DSP fields blank
e. OS Username: delphix
f. OS Password: delphix
g. Toolkit Path: /u01/app/toolkit (The Toolkit Path must be entered prior to clicking
Validate)
h. Click Validate
6. Click Next

Getting Started 19
© 2015 Delphix Corp. All rights reserved
7. Click Submit

Getting Started 20
© 2015 Delphix Corp. All rights reserved
8. 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.
9. View the Environment details
a. Click on the Environment Name (Target) on the left and review information on the
Details tab
b. Click on the Databases tab to view any discovered database installations and
databases

Getting Started 21
© 2015 Delphix Corp. All rights reserved
Exercise 7 – Provision a VDB

In this exercise, you will:

• Create a VDB called devdb

Steps
1. Click the Manage menu and then Datasets
2. Expand the Source DB group and click the orcl dSource from the Datasets panel on the left.
This will reveal the Timeflow for the dSource by default.
3. On the Timeflow tab of the dSource select the most recent (topmost) Snapshot. The
Provision VDB icon will appear along with the Open LogSync icon to the right.
4. Click on the Provision VDB icon to open the Provision VDB wizard

5. On the Target Environment tab click Target from the list of Environments
6. On the Target Environment tab, use the following information
a. Verify that the Installation Home is set to /u01/app/oracle/product/11.2.0/dbhome_1
(11.2.0.1.0)
b. Ensure that the Environment User is set to delphix
c. Click Next

Getting Started 22
© 2015 Delphix Corp. All rights reserved
7. Enter the details below on the Target Configuration tab , we will provide a user-friendly name
for the VDB as well as assign it to a new group.
a. Click Add Dataset Group
i. Type DB Targets for the Group Name
ii. Click Add
b. Verify that DB Target is selected as the Target Group
c. Mount Base: Type /mnt/provision
d. Oracle Database Name: Type devdb
e. VDB Name: Type devdb
f. Oracle Database Unique Name: Type devdb
g. Oracle SID: devdb
h. Click Next

Getting Started 23
© 2015 Delphix Corp. All rights reserved
8. On the Advanced tab
a. Confirm that Open Database After Provision is selected
b. Confirm that Enable Archivelog Mode is selected
c. Check the box next to Enabled for Auto VDB Restart
d. Click Next

Getting Started 24
© 2015 Delphix Corp. All rights reserved
9. On the Policies tab, accept the defaults and click Next
10. On the Masking tab, confirm that Mask this VDB is not checked
11. Accept the defaults on the Hooks tab and click Next
12. Verify the summary information
13. Click Submit to complete the VDB creation

Getting Started 25
© 2015 Delphix Corp. All rights reserved
It may take a couple minutes for the VDB creation to complete. You can monitor the status 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. devdb’s status
will be set to VDB - Running.

Getting Started 26
© 2015 Delphix Corp. All rights reserved
 Once the VDB is created, you can verify that the VDB is operational by:

14. Using Terminal on your lab server, use SSH to connect to your Linux Target server
a. Type ssh 10.0.x.30 (‘x’ will be your Student Number).
15. Enter the username: delphix
16. Enter the password: delphix
17. Run the following commands on the target server command line:
a. Type export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
b. Type export ORACLE_SID=devdb
c. Type export PATH=$ORACLE_HOME/bin:$PATH
d. Type sqlplus / as sysdba
e. Type select name from v$database;

18. Type quit to exit

Getting Started 27
© 2015 Delphix Corp. All rights reserved
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. Open Terminal on your Lab Server desktop
a. Type ssh [email protected] (‘x’ will be your Student Number)
2. Enter the username: delphix
3. Enter the password: delphix
4. Run the following commands:
a. Type export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
b. Type export ORACLE_SID=orcl
c. Type export PATH=$ORACLE_HOME/bin:$PATH
d. Type sqlplus / as sysdba
e. Type create table sourcetab as select * from dba_objects;
5. Go back to the Delphix Data Platform in your browser (click the Delphix logo to go back to
the main screen if required)
6. Click on the orcl dSource object on the left side of your screen (expand DB Source group if
needed)
7. Click the Camera Icon on the top-right to take a snapshot
8. Click on the devdb VDB on the left side of your screen
9. Click the Timeflow tab
10. Click the Refresh button on the top right next to the snapshot icon.

11. There are two options for refreshing the VDB, choose the Faster option to refresh from the
most recent snapshot from the orcl dSource
12. Click Next
Getting Started 28
© 2015 Delphix Corp. All rights reserved
13. Click Submit

Once the refresh has completed, a new VDB snapshot will be generated and reflected in the
Timeflow.

Log into devdb to confirm.

14. Open Terminal on your Lab Server desktop

a. Type ssh [email protected] (‘x’ will be your Student Number)
15. Enter the username: delphix
16. Enter the password: delphix
17. Run the following commands:
a. Type export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
b. Type export ORACLE_SID=devdb
c. Type export PATH=$ORACLE_HOME/bin:$PATH
Getting Started 29
© 2015 Delphix Corp. All rights reserved
d. Type sqlplus / as sysdba
e. Type select count(*) from sourcetab;

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

Getting Started 30
© 2015 Delphix Corp. All rights reserved
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. 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

3. A new snapshot card will be created on the devdb Timeflow. Make a note of the date/time for
the latest snapshot card.
4. Open Terminal on your Lab Server desktop
a. Type: ssh [email protected] (‘x’ will be your Student Number)
5. Enter the username: delphix
6. Enter the password: delphix
7. Run the following commands:
a. Type export ORACLE_SID=devdb
b. Type sqlplus / as sysdba
c. Type delete from sys.obj$;
d. Type commit;
e. Type shutdown abort;
f. Type startup;

Getting Started 31
© 2015 Delphix Corp. All rights reserved
 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.

8. In the Delphix Data Platform (web browser), click on the devdb VDB if it is not already
selected
9. 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.
10. Hover over the Snapshot to reveal the Rewind button.
11. Click the Rewind VDB button on the Timeflow

Getting Started 32
© 2015 Delphix Corp. All rights reserved
12. Confirm that you wish to rewind the VDB by clicking Rewind.

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

13. Open Terminal on your Lab Server desktop

14. Type ssh [email protected] (‘x’ will be your Student Number)
15. Enter the username: delphix
16. Enter the password: delphix
17. Run the following commands:
a. Type export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
b. Type export ORACLE_SID=devdb
c. Type export PATH=$ORACLE_HOME/bin:$PATH
Getting Started 33
© 2015 Delphix Corp. All rights reserved
d. Type sqlplus / as sysdba
e. Type select count(*) from sourcetab;

Getting Started 34
© 2015 Delphix Corp. All rights reserved
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. In the top menu bar, click on Manage and then Policies
2. Click the Retention tab, click +Retention

3. Provide the following details:

a. Policy Name: Long Term
b. Keep Logs for: 30 days
c. Keep Snapshots for: 30 days
4. Click the Show advanced link

Getting Started 35
© 2015 Delphix Corp. All rights reserved
5. Click the checkbox next to Keep 3 Snapshot(s) on 1st of every month
6. Click Next
7. On the Datasets tab click the checkbox for the devdb
8. Click Submit

Expand the policies menu to validate that the new Long Term policy has been applied to the
devdb VDB.

Getting Started 36
© 2015 Delphix Corp. All rights reserved
Exercise 11 – Create and Save a Hook Operation Template

In this exercise, you will:

• Create a Hook Template called Create APPUSER
• Insert code into the template that will log into a database and add a user named appuser

Steps
1. In the top menu bar, click Manage, then Hook Templates
2. Click the plus sign to the right of the word Templates in the Hook 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

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

Getting Started 37
© 2015 Delphix Corp. All rights reserved
6. Click Create
7. Verify the Create APPUSER Hook Operation Template is in the list, then click Close

Getting Started 38
© 2015 Delphix Corp. All rights reserved
Exercise 12 – Create a VDB Template

In this exercise, you will:

• Create a VDB Configuration template called Small DB Template
• Set a custom Oracle parameter for this template

Steps
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 1G Template under VDB Config Templates

6. Click the pencil icon on the top right of the VDB Configuration Templates screen
7. Click the plus sign on the top right to add a new parameter
a. Double-click the row to enter a new value
8. In the row that is now highlighted, enter the following information:
a. Name: memory_target
b. Value: 1G
9. Click the checkmark to save the Template.

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

Getting Started 39
© 2015 Delphix Corp. All rights reserved
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. 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:
a. Select DB Targets from the Datasets Group drop-down list,
b. Mount Base: /mnt/provision (this should already be filled in)
c. Database Name: qadb
d. Database Unique Name: qadb
e. SID: qadb
f. Click Configure VDB Parameters checkbox under VDB Database Parameters
g. Click Next
7. On the Advanced tab, click the Enabled checkbox under Auto VDB Restart
8. Click Next
9. On the VDB Configure Parameters tab, click the 1G Template that we created earlier from
the Select template drop-down list
10. Click Next

Getting Started 40
© 2015 Delphix Corp. All rights reserved
11. On the Policies tab, accept Default Snapshot Policy and Click Next
12. On the Masking tab, leave Mask this VDB unchecked. Click Next
13. Select DB Targets from the Datasets Group drop-down list, then click Next
14. Accept the default policies and click Next
15. On the Hooks tab with Configure Clone already selected on the left side of the Provision
VDB Wizard, click the plus sign to the right of the words Hook Points and select Create
from Template from the drop-down list

Getting Started 41
© 2015 Delphix Corp. All rights reserved
16. Enter a Name QA APPUSER for the Hook Operation
17. Click on the Create APPUSER template we created earlier
18. Click the Create button

Getting Started 42
© 2015 Delphix Corp. All rights reserved
19. Click Next

Getting Started 43
© 2015 Delphix Corp. All rights reserved
20. Click Next
21. Verify the summary information, and click Submit

Note: 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:

22. Using Terminal on your lab server, use SSH to connect to your Linux Target server
a. Type ssh 10.0.x.30 (‘x’ will be your Student Number).
23. Enter the username: delphix
24. Enter the password: delphix
25. Run the following commands:
a. Type export ORACLE_SID=qadb
b. Type export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
c. Type export PATH=$ORACLE_HOME/bin:$PATH
Getting Started 44
© 2015 Delphix Corp. All rights reserved
 d. Type sqlplus / as sysdba
e. Type show parameter memory_target
f. Type 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.

Note: 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:

Getting Started 45
© 2015 Delphix Corp. All rights reserved
Optional Advanced Exercise – Discover and Link a 12c Container Database dSource

In this exercise, you will:

• Using the createDelphixDBUser script to create the c##delphix_db user in CDB$Root.
• Using the createDelphixDBUser script to create the delphix_db user in the PDB WINTERFELL
• Discover the 12C Database to identify pluggable database WINTERFELL
• Add a dSource for the PDB WINTERFELL

Steps
We will walk through the steps to get you acquainted with discovering 12C PDB’s and creating a
dSource from them.

1. Using the Terminal icon on the Lab desktop connect to the Linux Source Server
a. Type ssh 10.0.x.20 (‘x’ will be your Student Number).
b. Enter the password delphix
2. Set the appropriate environment variables for the 12c Database and cd to the hostchecker
directory :
a. Type export ORACLE_HOME=/u02/app/oracle/product/12.2.0/dbhome_1
b. Type export ORACLE_SID=gotcdb
c. Type export PATH= $ORACLE_HOME/bin:$PATH
d. Type cd hostchecker

Note: If the hostchecker directory doesn’t exist, untar the hostchecker_linux_x86.tar file
(Type tar -xvf hostchecker_linux_x86.tar)

3. Run the createDelphixDBUser Script to first create the c##delphix_db user in the CDB
a. Type ./createDelphixDBUser.sh
b. Enter the Database Instance enter : gotcdb
c. When prompted to verify if you want to create the user in CDB#ROOT press Enter
d. Enter the DB User name: c##delphix_db
e. Enter password : delphix
f. When prompted for select any dictionary privileges : n

The script will create the c##delphix_db user with necessary privileges.

4. Run the createDelphixDBUser script again to create the delphix_db user in the PDB
WINTERFELL
a. ./createDelphixDBUser.sh
b. When Prompted for the Database Instance enter gotcdb
c. When Prompted for pluggable database name enter winterfell
d. When Prompted for the Database User enter delphix_db
e. When Prompted for the password use : delphix
f. When prompted for select any dictionary privileges : n

The script will now create delphix_db user in the PDB winterfell with the necessary
privileges.

Getting Started 46
© 2015 Delphix Corp. All rights reserved
Discover the CDB

If not already connected connect to your Delphix Engine as Delphix Admin.

1. Navigate to Manage -> Environments Page
2. Select the Source Dataset and click on the Databases Tab.
3. Scroll down to find the home /u01/app/oracle/product/12.2.0/dbhome_1
4. Click on Discover CDB to discover the PDB’s in the CDB

5. On the Discover CDB wizard Popup Enter the following details

a. Username: c##delphix_db
b. Password: delphix
6. Click on OK
7. Click and monitor the Actions tab to ensure it completes without error.

Once complete, PDB WINTERFELL should be discovered and displayed under the 12c home

Getting Started 47
© 2015 Delphix Corp. All rights reserved
Link an Oracle 12c dSource

1. Click on the Add dSource button to add a dSource from this database
2. On the Add dSource Wizard make sure the PDB WINTERFELL is selected.
3. Scroll down and add db user details
a. DB Username: delphix_db
b. DB Password: delphix
4. Click on Verify credentials to verify the give details.
5. Click Next

Getting Started 48
© 2015 Delphix Corp. All rights reserved
6. On the dSource Configuration tab of the Add dSource wizard Click on Add Dataset Group
7. On the Add Dataset Group pop up, add a new group with the name Ora12C Sources.
8. Click Add.
9. Make sure the new dataset group is selected and click Next.
10. Review and Accept the defaults on the Data Management tab by clicking Next
11. Review the defaults on the Policies tab and click on Next.
12. We will not be configuring hooks at this time. Click on Next.
13. Review Summary and Click Submit.

14. Click on Actions on the top right-hand corner if Actions Pane is hidden to monitor progress of
the Action and ensure it completes without error.

Getting Started 49
© 2015 Delphix Corp. All rights reserved
15. Once the dSource creation is completed Navigate to Manage -> Datasets.
16. Expand the Ora12c Sources group to explore the DB’s under it. You should see both the CDB
gotcdb and the PDB WINTERFELL listed under it.

Note the Different icons used to represent CDB and PDB’s

Also note there is no timeflow available for the container database gotcdb.

Getting Started 50
© 2015 Delphix Corp. All rights reserved
17. Click on the PDB WINTERFELL to see the Timeflow, Status and Configurations under the
respective tabs.

Getting Started 51
© 2015 Delphix Corp. All rights reserved
Optional Advanced Exercise – Provision a Virtual PDB (vPDB)

In this exercise you will:

• Provision a VPDB from a 12c dSource.

Steps

As an advanced exercise, this lab has no corresponding Lab Solution. Instead, we will walk through
the steps to get you acquainted with provisioning a PDB from a 12c dSource.
1. Login to the Delphix Engine if not already logged in.
2. Navigate to Manage -> Datasets
3. Expand Ora12C Sources Group and click on WINTERFELL PDB
4. Hover on the latest snapshot card and click on Provision a VDB.

5. On the Provision vPDB Wizard

a. Click on Target under Environments.
b. And click the check box for Create a New Container Database.
c. Click Next.
6. On the Target Configuration tab click Add Dataset Group
7. On the Add Dataset Group Wizard create a new group with the name Ora12C Targets.
8. Click Add
9. Back on the Target Configuration page make sure the new Dataset group Ora12C Targets is
selected.
10. Add the following details. (Database Name and SID limited to 8 characters).
a. Pluggable Database Name : devPDB
b. vPDB Name : devPDB
c. Database Name: VCWINTER
d. vCDB Name : VCWINTER
e. Database Unique Name: VCWINTER
f. SID: VCWINTER
11. Click Next.

Getting Started 52
© 2015 Delphix Corp. All rights reserved
12. On the Advanced page click the Auto vCDB Restart Enabled checkbox
13. Click Next
14. Accept the Default policies. Click Next
15. We will not be configuring hooks now. Click Next.
16. Review the summary page and click Submit.

Note: Once Submitted, the Action will show a working screen for a few seconds. You can
choose to let the Action run in the background.

17. Monitor the Actions Pane by clicking on the Actions button on the top right-hand corner. You
can get more details about the action by clicking on the currently running action to expand it.

Note: Once Action is completed you can see the vCDB we added and the VPDB just
provisioned listed under the new Dataset group Ora12C Targets. Expand the group if
necessary, to view the objects under it. Note that there is no timeflow for the vCDB.
Getting Started 53
© 2015 Delphix Corp. All rights reserved
18. Click on devPDB and review Timeflow, Status and configuration details under the respective
tabs.

19. Using the Terminal icon on your lab desktop connect to the target server. (Refer to the
Important IP Addresses section of the labguide)
a. Click on the Terminal icon on the lab desktop
b. Type ssh 10.0.x.30 (replace # with the student number assigned to you).
20. Set up the environment variables for 12C
a. Type export ORACLE_SID=VCWINTER
b. Type export ORACLE_HOME=/u02/app/oracle/product/12.2.0/dbhome_1
c. Type export PATH=$ORACLE_HOME/bin:$PATH
21. Connect to sqlplus and verify the CDB and PDB details
a. Type sqlplus / as sysdba
22. At the SQL> prompt type
a. select name from v$database;
b. alter session set container=DEVPDB;
c. show CON_NAME

Getting Started 54
© 2015 Delphix Corp. All rights reserved
Optional Advanced Exercise – Measure Network Performance Test through the CLI

In this exercise, you will:

• Log into the Delphix Data Platform CLI as 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 admin.

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

2. Type: ssh [email protected] (‘x’ is your Student Number assigned by your instructor)
a. If you receive a prompt asking you if you are sure you want to connect, enter: Yes
b. Enter the password: delphix
c. 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
a. List the default/required parameters by typing: get
b. Set the remoteHost value to the TargetA environment IP address: set
remoteHost=10.0.x.30 (‘x’ will be your Student Number)
c. Begin the test by typing: commit

Figure 48 Example Network Latency Test Submission

4. View the results of the latency test:

a. Get to the latency test section again by typing: network test latency
b. List the completed tests by typing: ls
c. 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
d. View the results of the test by typing: get

Getting Started 55
© 2015 Delphix Corp. All rights reserved
5. Create a network throughput test
a. While still logged into the CLI, return to the root by typing: cd /
b. Begin a network throughput test by typing: network test throughput create
c. List the default/required parameters by typing: get
d. Set the remoteHost value to the TargetA environment IP address: set
remoteHost=10.0.x.30 (‘x’ will be your Student Number)
e. Begin the test by typing: commit

Getting Started 56
© 2015 Delphix Corp. All rights reserved
6. View the results of the throughput test:
a. Get to the throughput test section again by typing: network test throughput
b. List the completed tests by typing: ls
c. 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

d. View the results of the test by typing: get

Getting Started 57
© 2015 Delphix Corp. All rights reserved
 Getting Started 58
© 2015 Delphix Corp. All rights reserved
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
a. Click the plus sign next to Replication Profiles on the top left
b. Enter a Replica Profile Name: DR Replica
c. 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:
i. Student 1 Delphix Data Platform is at 10.0.1.10, and they will replicate to
10.0.2.10
ii. Student 2 Delphix Data Platform is at 10.0.2.10, and they will replicate to
10.0.3.10
iii. Student 3 Delphix Data Platform is at 10.0.3.10, and they will replicate to
10.0.1.10
iv. Ask your instructor if you have any questions or confusion about this
configuration.
d. Enter the User Name: admin
e. Enter the Password: delphix
f. Do not enable Automatic Replication or configure Traffic Options
g. For the Objects Being Replicated, select: Entire Delphix Data Platform
h. Click Create at the bottom when ready.

Getting Started 59
© 2015 Delphix Corp. All rights reserved
 Figure 52 Replication Profile Configuration

3. Start the Replication by clicking the Replicate Now button on the top right of your screen.
4. Click Replicate to confirm you are ready to begin.
5. Once the initial full replication is complete, you will see a message stating Last Replication
Successful.

Figure 53 Example Successful Replication

Getting Started 60
© 2015 Delphix Corp. All rights reserved
6. Check the results on your target Delphix Data Platform
a. 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.
b. Log in as user admin with the password delphix
c. 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.
d. 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.

7. While still logged into your target Delphix Data Platform, click on System and then
Replication
8. Observe the Received Replicas section at the bottom, indicating and verifying the target’s
receipt of replication data.
a. 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.

Getting Started 61
© 2015 Delphix Corp. All rights reserved