If you are still interested in Oracle 8i feel free to read on below.
The Oracle Corp. offers numerous products from relational and object-relational database management systems, software developement tools and CASE tools to packaged applications such as Oracle Financials. When discussing Oracle, one must refer to a specific piece of software. People who talk about "buying Oracle" or that say "I have used Oracle" seldom actually know or understand what they are talking about.
Under the headings above, one might categorize the Oracle product line as follows:
|Database Servers|| Oracle7, Oracle8, Oracle8i, Oracle9i, Oracle10g, Oracle11g|| The database engines that store and retrieve data,
and servers that provide access to the DBMS over
a LAN or the Internet/Web.|
There are several versions of each:
Personal Oracle X (intended for desktop single user)
Oracle X (intended for small to medium sized workgroups)
Oracle X Enterprise (intended for very large organizations)
(where X is some version like Oracle7, Oracle8, Oracle8i, Oracle9i, etc.)
|Application/Web servers||(Web) Application Server, WebDB or it's modern name "Application Express"||Web development and applications server software that allow applications to served over the web. This is typically done in a 3-tier architecture.|
|Software Development|| SQL*Plus (Command line interface) |
Developer/2000, or simply Developer (Forms, Reports, Graphics)
Designer/2000 or simply Designer (CASE Tools)
Programmer/2000 (Embedded SQL libraries)
JDeveloper (Java application development)
As of Summer, 2002, all of these pieces are now combined under one title: Oracle 9i Development Suite. The modern version is Oracle10g Developer. With Oracle 11 they are transitioning away from the "Forms" and "Report" model.
|Tools used to develop applications that access an Oracle DBMS (or multiple DBMS), typically in a traditional 2-tier client/server architecture or 3-Tier architecture.|
|Packaged Apps.|| Oracle Financials|
Oracle Supply Chain Management, etc.
|Software written using Oracle tools by Oracle that is then installed and customized for a business.|
In general, Baruch supplies an Oracle8i server and the Developer tools for projects in the CIS4400 and CIS 9440 courses.
Given the vast array of products listed above, one should assume it is not feasible to learn ALL of the Oracle products at one time. Below is a suggested series of steps to gradually build your Oracle knowledge using the minimum amount of software. If you have a reasonably equipped PC (2 GB RAM, 30 GB disk space free, Windows Server, XP Professional or later OS), you can run both a server instance and the client tools on the same machine.
|If your goal is to ...||Acquire this software...|
|Learn the basics of SQL, Stored Procedures, Triggers and the Oracle data dictionary|
e.g., in preparation for the first OCP exam. This is also the basics you will need for Baruch College's CIS 4400 and CIS 9440 classes.
|Personal Oracle 8i/10g/11g for Windows (includes the DBMS and SQL*Plus tool)|
|Learn how to develop client side applications (forms, reports)|
e.g., for development of a 2 or 3 tier client/server project
|Personal Oracle 8i/9i/10g/11g (see above) and Oracle Developer 9i/10g or Forms 11g|
|Learn how to develop client side applications in Java (forms, reports)|
e.g., for development of a 2 or 3 tier client/server project
|Personal Oracle 8i/9i/10g/11g (see above) and Oracle JDeveloper|
This is probably the most appropriate place to remind you that copying software is illegal. Oracle is well known in the software industry for zealously prosecuting offenders.
The 3rd edition of the Elmasri/Navathe Fundamentals of
Database Systems book can be ordered with an Oracle Software
supplement. This supplement includes the following
- Personal Oracle 8i RDBMS for Windows 98 (This software does not work with Windows 95, NT, ME, 2000 or XP)
They used to bundle Developer and Designer, but no longer.
Students with the Elmasri/Navathe Oracle software supplement may wish to visit the Addison-Wesley Computer Science and Engineering home page for the textbook. There are some installation instructions available for the Oracle tools.
I have also provided some installation guidelines for Personal Oracle8i (click here). Note that these instructions ONLY apply to installing the EXACT version of Personal Oracle8i that comes with the E/N textbook on to Windows 98.
All versions of the Oracle RDBMS ship with the SQL*Plus tool. SQL*Plus is a simple command-line tool for entering SQL statements in to the Oracle database. In the CIS 9440 and CIS 4400 classes, we will use SQL*Plus to create tables, write queries and create stored procedures and triggers.
Oracle Designer (Designer/2000) (the CASE tool) is not presently supported anywhere at Baruch and is not used for any classes. It is strongly recommended that you do not attempt to install Oracle Designer. The main reason is that this is a very complex product that requires you to create a "CASE Repository". This repository is actually an Oracle database with a minimum size of over 300 megabytes. It requires strong DBA skills to get this product installed properly. This includes manipulating the Oracle tablespaces (not a typical job for novices). When things go wrong during the installation, one can waste significant time troubleshooting. Once installed, Oracle Designer requires significant time to learn and master before it can be used effectively. For these reasons, I recommend against using Oracle Designer until you are very familiar with manipulating Oracle schemas.
At this time (August, 2002) none of the Oracle databases or tools appear to be supported under Windows ME or the Home Edition of Windows XP). Most of the tools and databases are now only supported under Windows NT 4.0, Windows 2000 (Server or Professional) and Windows XP Professional.
Speaking of Windows 2000, if you have trouble installing Oracle8i under Windows 2000, try this suggestion from the Intel web site: http://support.intel.com/support/processors/pentium4/issues.htm
One hint that seems to work for some people is that once you have installed the database (Personal Oracle8 for example), and then you attempt to install Developer/2000 2.1, you may get some errors during the install. When you put in the CD-ROM for Developer/2000 2.1, its install program will automatically run. The problem is that Developer/2000 2.1 install program is likely not compatible with Personal Oracle8. So the trick is to exit the Developer/2000 2.1 install program and run the "Oracle Installer" program that was installed along with Personal Oracle8. You can then tell Oracle Installer to point to the CD-ROM drive where it will find the Forms, Reports and Graphics applications parts of Devleoper/2000 to install.
File: index.html Date: Tue Aug 20 12:09:21 EDT 2002
All materials Copyright, 1997-2002 Richard Holowczak