DEV/2000 to Personal Oracle8 IS Possible!!

With the help of Gina at Oracle Web support (web-sup_at_us.oracle.com) I was able to get Developer/2000 communicate to Personal Oracle8 via TCP/IP in NET8. All the software is running on the same PC. The PC is a standalone PC (not connected to a network) running Windows95. Developer/2000 is a trial release 2.

I followed the instructions that Oracle support sends out for getting Dev/2k to talk to Personal Oracle8. (Connect Oracle Support at web-sup_at_us.oracle.com for the instructions.) It did not work. I had to do the following to get it to work:

1. I noticed that SQL*Net EASY configuration software (which Oracle Support recommended to use to configure SQL*Net) was not updating the NET8 directory. It was changing the NETWORK directory. I copied the TNSNAMES.ORA and LISTNER.ORA files in the C:\ORAWIN95\NETWORK directory to the C:\ORAWIN95\NET8 directory.
2. The Oracle Support instructions tell you to go into the TCP/IP properties in Windows95 and specify an IP address. This is fine as long as you are connected to a network and do not automatically receive an IP address at connect time from your ISP (Internet Service Provider). In my case specifying an IP address in the TCP/IP properties caused me to lose the ability to connect to anything through my ISP including my e-mail service. I left my TCP/IP IP address as "obtain the IP address automatically". In the NET8 files I used the IP address of 127.0.0.1 (localhost).

Here is my C:\orawin95\net80\admin\tnsnames.ora file:

ORACL.world=
  (DESCRIPTION =
    (ADDRESS =
(PROTOCOL = TCP)
(Host = localhost)
(Port = 1521)

        )
    )
    (CONNECT_DATA = (SID = orcl)
    )
  )

Here is my C:\orawin95\net80\admin\listner.ora file:

LISTENER =
  (ADDRESS_LIST =

        (ADDRESS = 


          (PROTOCOL = TCP)

          (Host = 127.0.0.1)


          (Port = 1521)


        )

I hope this helps. Thank you very much Gina at Oracle Support!!! Received on Tue Jun 30 1998 - 00:00:00 CEST