Student Name: Weight: 2.
3%
Student ID: Marks: Pass/Fail
Lab: Installing Oracle and Loading Course Databases
Instructions
1. This lab is completed individually. There is one lab period scheduled for the completion
of this lab.
2. In this assignment you will install the latest version of Oracle and load the JustLee
Bookstore Database which will be used in class at a later date.
3. You will need the zipped data files which are found in Brightspace under Course
Resources->Database:
a. JustLee Bookstore
b. Really Cheap Vacations
4. See Brightspace for exact due date.
5. To verify the installation, you will upload a copy of the spool file that contains the results
and the commands executed within the Oracle script provided.
6. Upload your spool file to Brightspace by the scheduled due date.
Exercise Tasks
Part A – Install and Configure Oracle
1. Download the latest Express Edition of Oracle
(https://www.oracle.com/database/technologies/xe-downloads.html). You will be prompted
to create an Oracle Technology Network (OTN) Account and validate it before you are
allowed to download the software. Download the version for your machine. If you are
running a Windows laptop, select the “Windows x64” version. You will need to extract the
files from the zip and run setup.exe as an Adminstrator by Right-Clicking on setup.exe and
“Run as Admin...”.
2. During installation, you will be required to set a password for the SYSTEM and SYS
account. Record the password below:
SYSTEM/SYS password: ____________
Note: Passwords are case sensitive. A password must begin with an alphabetic character.
Passwords can contain only alphanumeric characters and the underscore (_), dollar sign
($), and pound sign (#). Passwords may not contain the "@" character.
© 2022, Southern Alberta Institute of Technology 1
3. Create a folder called c:\cprg250s to store database scripts associated with this class. It is
important to place this in the root folder so that it will be easy to express an absolute
pathname for the spool files.
Part B – Create the CPRG250 Account
1. OPEN SQL*Plus.
a. Under Start->Oracle->SQL*Plus
i. Find the files new_user.sql and build_JLDB.sql in Brightspace under Course
Resources->Database->JustLee Bookstore
ii. Download both files into a new directory called c:\cprg250s
2. Connect to the system account.
a. Command: CONNECT SYSTEM
b. Use the password you defined when installing the software
3. Execute the new_user.sql script to create a new user. (Command is shown in bold)
SQL> start c:/cprg250s/new_user.sql
Note: This will create the CPRG250 user account which you will use throughout the remainder
of the course.
4. Connect to the CPRG250 account
SQL> connect cprg250
SQL> Password: password
Part C – Install thce JustLee Bookstore Database
1. While logged into the CPRG250 account, load the JustLee Database. Go to Course
Resources->Databases->JustLee Database
a. Save the file build_JLDB.sql to the download area
b. Start the script
SQL> start c:/cprg250s/build_JLDB.sql
Part D – Install Really Cheap Vacations
1. While logged into the CPRG250 account, load the Really Cheap Vacation Database. Go
to Course Resources->Databases->JustLee Database. Follow the instructions in the
README.TXT file.
© 2022, Southern Alberta Institute of Technology 2
Part E – Verify the Installation and Submit the Resultant Spool File
1. While logged into the CPRG250 account, run the test script verify.sql. This script will
provide a spool file that produces a report of all the Vacation Tours and Destinations. Verify
that the databases have been properly loaded. You should see results for two databases.
2. Find your spool file (c:\cprg250s\loadingoutput.txt) and submit it via Brightspace as proof
that your database has been correctly loaded.
3. Type ‘exit’ to exit SQL*PLUS
Marking Criteria
Categories Fail Pass Score
Spool file does not Spool file contains the 32
contain expected customer book orders.
Spool file correct output. Pass/Fail
Spool file contains 20 rows for
customer tours.
spool
connect
© 2022, Southern Alberta Institute of Technology 3
