CPSC4670 Database Security and AuditingProject 1

Project #1 Installing Oracle 11g Database

Due on Jan. 26

  1. If you are installing Oracle on a DHCP computer. If yes, you have to install a loopback adapter first, and it has to be the last adapter installed! VERY IMPORTANT. If you mess this up, next time your IP address changes, you will not be able to run Oracle db.
    Check this tutorial (scroll down to Vista installation tips)
  2. Install oracle 11g database. (40 points)

Oracle Database Software Downloads is available at:

Tutorial of Oracle installationis available at:

Tutorial of Installing Oracle Database 11g on Windows is available at:

3. Oracle SQL Developer is a free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks. More Info:

4. Create the database schema (you can use the script from the textbook, which is available in blackboard and called chapter04.zip), refer to Figure 4-20 on page 161 for scheme details. (20 points)

5. Fill in the data (you can use the script from the textbook also) (10 points)

6. Use SQL commands to manipulate the data, such as (20 points)

a) count the number of unique department,

b) query an order,

c) insert a payment method and

d) delete a product.

7. Submit a written report including above activities.Please use screen shots to document your results. (10 points)

Tips:

0. Alternatively, you can use Pre-Built Developer VMs (for Oracle VM VirtualBox)

Just assemble the downloaded files (if needed), import into VirtualBox (available for free), import, and go!

1. To facilitate process of installation, you are recommended to install a virtual box and then a clean Windows XP.

2. If your oracle is gone when you restart your computer, please go to

control panel > administrator tools > services to check if OracleConsole is started.

3. Uninstall Oracle database is not trivial, here are guides to uninstall Oracle manually from Windows XP and

3.1 Uninstalling Oracle 10g Manually from Windows XP

Oracle's installation utility has a nasty habit of leaving a lot of items behind. I wrote this up to document what I've found you need to do to uninstall Oracle 10g manually. This is specific to 10g and Windows XP. Removing 9i is very similar.

The first thing you should do, is go ahead and run the installation tool to do adeinstall. It probably will leave some things behind, but it's worth running. Then go through this list and remove anything it missed. This list is detailed enough though, that I believe even if you did not run the uninstallation tool, this would fully uninstall Oracle.

The most commonly missed item is to make sure you remove everything from the GAC because the uninstaller doesn't appear to. I get to that later, but if you wanted to know the largest source of uninstallation problems, it's libraries remaining in the GAC.

After running the supplied Oracle uninstallation utility (which may or may not do some or all of the following):

Stop any Oracle services that have been left running.

Start->Settings->Control Panel-> Administrative Tools ->Services

Look for any services with names starting with 'Oracle' and stop them.

Run regedit and delete the following keys (some may have slightly different names in your registry):

HKEY_CURRENT_USER\SOFTWARE\ORACLE

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\Application\Oracle.oracle

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleDBConsole

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Oracle10g_home

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OraclService

Note that the services control panel will still show the old services until you reboot.

Delete the Oracle home directory

C:\Oracle

Delete the Oracle Program Files directory:

C:\Program Files\Oracle

Delete the Oracle Start Menu shortcuts directory:

C:\Documents and Settings\All Users\Start Menu\Programs\Oracle*

Where * indicates the name of your install. Look for and remove all Oracle directories from that location.

Remove Oracle refereces from the path. To edit your path go to:

Start->Settings->Control Panel->System->Advanced->Environment Variables

Edit both of the environment variables user PATH and system PATH. Remove any Oracle references in them.

Remove Oracle.DataAccess and any Polic.Oracle files from the GAC which is at:

C:\Windows\assembly\

There, now your system is Oracle free. If you are installing a new instance of Oracle (and not just an additional DB) I recommend you do this before any new Oracle installation.

3.2 Uninstall Oracle 10g from Windows Vista

following is the instruction of remove it from

  1. Delete Oracle_Home and Oracle in the system environment variables (e.g. oracle in PATH).
  2. Stop all oracle services, listener services. Use regedt32 to remove Oracle service entries.
  3. Delete c:\program files\oracle and all sub dir.
  4. Remove Oracle in Start->All Programs->Oracle by delete Oracle Home and any Oracle directory in c:\programdata\Start Menu\Programs; this directory is hiding, so you have to change the view setting to see it.
  5. Use regedt32 to delete all entries of oracle and ora in hkey_classes_root, hkey_local_machine and/or hkey_current_user. (do not let this deter you, actually, they all together next each other on top of the tree hive; about 15 in hkey_classes_root, just one or two in hkey_local_machine and none in hkey_current_user on my system)
  6. Delete c:\Oracle installation directory or rename it to something else.

Reboot and run Oracle setup.exe should let you install a fresh copy of 11g.