The following will need to be done to establish a connection from Developer to Oracle Database Personal Edition.

Developer 6.x & 8i Personal Edition on Win 98 (standalone)

The following will need to be done to establish a connection from Developer 6.x to Oracle 8i Personal Edition.

1.Install Oracle8i. Default Oracle_Home is as follows: (oracle/ora81)

If you are do not have a Domain name or are unsure of - use default selections (REMEMBER: your SID-System Identifier--for step 3)

2.Install Developer 6.0 into a seperate Oracle_Home from the 8i database. Default Oracle_Home: ORAWIN95.  Change the Developer Home name to: (oradev60) and the Developer Home location to: (oracle/dev60)

3.Create a Net8 service name using the Net8 Easy config utility (start -> programs -> Oracle ->network administration -> net8 easy config)

Enter the following information:

     Select "create"

     Name the service name - any name can be used. (this name must be the same as SID name on the step 1.

     Select TCP/IP as the protocol adapter

     Enter your PC name as your host (as found in your TCP/IP

     properties of the control panel or 127.0.0.1)

     Select the second radio button to change your database instance to equal the SID created during your 8i installation or leave the default as ORCL.

     Bypass the test and remaining screens by clicking next.

4.Go to the following location (using Windows Explorer): (oracle/ora81/network/admin/)  (where Oracle/Ora81 is the location of your 8i Oracle_Home) then copy the tnsnames.ora file to the following location:  (oracle/oradev60/net80/admin) (where oracle/oradev60 is the location of your Developer Oracle_Home)

5.Rename the sqlnet.ora file to sqlnet.old.  These files can be found in the following locations:

     a.oracle/ora81/network/admin/

     b.oracle/oradev60/net80/admin

Some installations will not create the above files in both locations, rename only the files that are found. Now reboot.

6.Start your listener:

At the DOS prompt type: LSNRCTL START

NOTE: if you have an internet connection that uses TCP/IP as a protocol you may recieve a dial-up connection box when starting the listener.  Press cancel to bypass this connection.

7.Start your database:  (Start -> Oracle - OraHome81 -> Database Administration -> Start

Database)

     Login to any developer’s tools and make a connection using:

     username: scott

     password: tiger

     database: <enter the service name created in step #3>

What is the Username/Password Needed for Login

The Oracle8i starter database comes with some default user names and user passwords, which are shown in the following table.  Use these default values until you establish your own user name and user password.

User Name:                Password:

scott                             tiger

system                          manager

sys                               change_on_install

internal                         oracle

demo                           demo

To connect to your local database from SQL*Plus, you may be asked for the host string, database, connect descriptor, or some similar label, depending on the application. You can leave this field blank.  If you are trying to connect from an Oracle tool (Developer, Discoverer, Designer, etc) then you will need to create a connect descriptor using the Net8 configuration tool.