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

Go to “MS-DOS” and start the listener.

=

Open the Net8 Assistant tool or Oracle Net8 Easy Config tool.

=

Type “DBS” as a new service name, and then click “NEXT.”

=

Choose “TCP/IP”, then click “NEXT.”

=

Type 127.0.0.1, and click “NEXT.”

=

Type your Global Database name.

Mine is “oracle,” then click “NEXT.”

=

Click on test.

The connection should be successful.

You may have to enter a USERID and PASSWORD.

Then click “CLOSE.”

Click “Next.”

and “Finish.”

=

On MS-DOS, type tnsping then the service name.

You should get a message like this.

=

Open “windows explorer.”

Go to the oracle database home, network, and then the admin folder.

Copy the “sqlnet.ora” and “tnsnames.ora” files to the developer’s admin folder.

=

Close the window.

=

Edit the registry file.

=

Expand “Local machine.”

Expand “Software.”

Select  “Oracle.”

Add a new string value.

Name it “LOCAL.”

Then double click on the “LOCAL” icon and type “dbs” (the service name).

And Click “OK.”

=

Close the window.

=

To test the service name, Login to sqlplus as scott/tiger using the service name.

=

Exit “SQLPLUS.”

=

Open any Oracle tool such as “SQLPLUS” and login as “SCOTT/TIGER” without the service name.  Remember.   The sqlplus uses the service name that you added to the registry file.

Click ‘OK.”

=

That is all.

=

And I wish you good luck in you set up.