The Oracle database and Developer are very easy to install.  The only difficulty that you may face is:  How to establish connectivity between the Oracle developer tools and the Oracle database on the same machine such as windows98.  This Hands-On, it will teach you how to make this connectivity.

    1- Start listener

    2- Create a Service Name using the Net8 Easy Configuration

    3- Test the Service Name

    4- Copy SQLNET.ORA from the oracle database folder to the developer folder

    5- Copy TNSNAMES.ORA from the oracle database folder to the developer folder

    6- Add the LOCAL string to the registry

    7- Login to the "SQLPLUS" tool

When you install Oracle8i and Developer in the same machine, be sure to install them on two different sub-directories.  Also you must make sure their home names are different.

Once you install the Oracle products, go to the connectivity and play the movie.  The movie shows how to login to Oracle8i using the Oracle tools, such as “SQLPLUS,” and “FORM Builder.”

To establish connectivity, you will use Net8 Easy config.  If you don’t have “Net8 Easy config,” you can use the “Net8 assistant” option.

Important notes to remember:

• Oracle Server is an object-relational database management system that provides an open, comprehensive, and integrated approach to information management.  It consists of an Oracle database and instance.

• The Oracle Database contains all user data information.  It has a physical and a logical structure.

• The “Physical Structure” is determined by the operating system files; such as data files, control files, and parameter files.

• The “Logical Structure” is determined by the Oracle Database, such as tablespaces, tables, and segments.

• An instance is a combination of Oracle background processes and memory buffers. 

• The memory buffer is called System Global Area (SGA) and is shared by the database users.  Every time a database is started the system global area is allocated and Oracle background processes are started.

• Oracle Background Processes Server tasks between memory and disk.

• A user establishes connection and then requests information using a client application from the Oracle Server.

• The Listener process waits for connection requests from a client application, and routes each client to a server process.

• Server processes are created on behalf of each user’s application to read a user request and return the results.

• The TNSNAMES.ORA and SQLNET.ORA files establish client session connectivity to a server using the local naming option.

Subject to cover:

Now, go to each hands-on and play the movie over and over until you become familiar with the subject.  For more information, we encourage you to read the Oracle Installation Manual.

Good Luck!