TEC 5323 Advanced Database Technology


Project 1 Oracle Installation

Task:

Install Oracle 11g, 12c or 18c database on your own computer. Only one of the following tasks is required.

  • Install 11g, 12c or 18c Enterprise Edition, Standard Edition or Express Edition.depending upon your computer hardware and your operating sytem (Windows 32 bit or 64 bit). (The version of Oracle database is not important for this course since we focus on Oracle core technology that remains compatible over various versions. Any available version will work for our course.)

    You will need to download the software from www.oracle.com. Please read the course materials for this week for more details.
 
Report:

Submit your project report in Microsoft Word format through D2L--Assessment--Dropbox--Project I. If you need instructions on how to submit, click here.

Please include the following information in your MS Word file:

1. Your Full Name

2. Version of Oracle 11g/12c/18c database installed. (10 points)

3. Operating System (10 points)

4. Screen shots that details your installation procedure. (60 points)

5. A screen shot of login Oracle SQL*Plus as SYSTEM user. Typically, after you start SQL*Plus and enter user name "SYSTEM" and its password, it will look similar to the following screen shot from your computer. (20 points)

sqlplus

To show the login user name, you may issue a SQL command as

SQL> show user;


Convention for File Name: Please name your file as firstname_lastname_project1.doc, where firstname and lastname are your first and last name, respectively, and "_" is underscore. Seriously, the above convention will help the instructor's grading. Therefore, the instructor will be more generous when grading your project if you follow the convention.

 

Due:

At the end of this week. Please see the course schedule for exact due date.

 

School of Technology
College of Business & Applied Sciences
Eastern Illinois University