1. Extract the downloaded zip file, and then double click on setup file to start installation.

2. Choose Administrator tools to install (see below)  
3. Choose "Use Windows Built-in Account" (see below) 
4. Chose your file location (see below for example) and press Next to continue. If during the installation, your windows defender is blocking installation, choose Allow Access to move on. The process should finish without hiccups.
5. Now, we need to configure host strings to connect to Oracle servers. Go to Start and open Network Manager program. Click on + sign in front of Local to expand Local (see below): 
6. Click on Service Naming and press the green + button to create a new service name. Enter ecourse.org as Net Service Name (see below for example) 
7. Press Next and then choose TCP/IP as protocol (see below) 
8. Press Next and enter ecourse.org as Host Name and 1521 as port number (see below) 
9. Enter ol7.ecourse.org as Service Name (see below) 
10. Press Next and then press Test to make sure your setup is successful (see below). If the text fails, you may need to go back to the previous steps to check for errors. 
11. If test is successful, press Close button to dismiss the test message. Press Finish to dismiss the configuration process. 
12. Go to File and select Save Network Configuration. Now you can exit Network Manager. 
13. [Repeat the above Steps 6-12 to configure connection to the host cobismcourses.uakron.edu and Oracle instance with ID cob19c.uanet.edu]
14. Now go to Start, and open SQL Plus. Enter scott@ecourse.org as user name and tiger as password to connect to ecourse.org database (see below).

Instead of the above Steps 5-10, you can create file called tnsnames.ora (using notepad) and put it inside the folder c:\app\oracle\product\19.0.0\client\network\admin (depending on your choice of installation location in Step 4). 

Copy and paste the following to the end of the file and then save the file tnsnames.ora for UA CBA Students only (Make sure the extension must be .ora, not .txt):

ecourse.org  =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ecourse.org)(PORT = 1521)))
(CONNECT_DATA =(SERVICE_NAME = ol8.ecourse.org) )
)

 
COB19C =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cobismcourses.uakron.edu)(PORT = 1521)))
(CONNECT_DATA =(SERVICE_NAME = cob19c.uanet.edu) )
)

CREATE PROFILE student LIMIT
FAILED_LOGIN_ATTEMPTS 6
PASSWORD_LIFE_TIME 180
PASSWORD_REUSE_TIME 60
PASSWORD_REUSE_MAX 5
PASSWORD_LOCK_TIME 2
PASSWORD_GRACE_TIME 14;


drop role student;
create role student;
grant create session to student;
grant CREATE CLUSTER to student;
grant CREATE INDEXTYPE to student;
grant CREATE OPERATOR to student;
grant CREATE PROCEDURE to student;
grant CREATE SEQUENCE to student;
grant CREATE TABLE to student;
grant CREATE TRIGGER to student;
grant CREATE TYPE to student;
grant create view to student;
grant CREATE DATABASE LINK to student;
grant CREATE DIMENSION to Student;
grant create any index to Student;
grant CREATE JOB to student;
grant CREATE LIBRARY to student;
grant CREATE MATERIALIZED VIEW to student;
grant CREATE SYNONYM to student;
grant unlimited tablespace to student;

drop role teacher;
create role teacher;
grant create user, alter user to teacher;
grant student to teacher with admin option;

create user SCOTT identified by TIGER
default tablespace users
temporary tablespace temp
profile student;

revoke student from scott;
grant student to SCOTT; --student account