Re: Net 8 Configuration

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Mon, 13 Mar 2000 20:56:27 GMT
Message-ID: <38d83c30.26141769@netnews.worldnet.att.net>

I usually just setup a TCP/IP connection, and use that. You can also do an IPC connection, which might make more sense if you are running everything one one machine. Here's the tnsnames.ora entries that I use:

HERMAN-IPC.GENNICK.ORG =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = HERMAN))     )
(CONNECT_DATA =

      (SERVICE_NAME = HERMAN.GENNICK.ORG)     )
  )

 HERMAN.GENNICK.ORG =
   (DESCRIPTION =

     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST =
jonathan.gennick.org)(PORT = 1521))
     )
     (CONNECT_DATA =
       (SERVICE_NAME = herman.gennick.org)
     )

   )

Both IPC and TCP/IP require that a Net8 Listener be running. I recently spent quite a bit of time trying to get a Bequeath connection working with 8i--Bequeath does not require a listener, only to find out that 8i release 8.1.5 on NT does not support Bequeath. See the bottom of page 7 in the Release Notes.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Mon, 13 Mar 2000 09:05:27 GMT, dagaith_at_md.prestige.net (dagaith) wrote:

>I have installed Oracle 8I EE on my Windows 2000 machine.
>I am trying to connect to the database using sqlplus or
>Oracle Forms.  How do I setup the Net8 configuration
>to that I can make a connection.  Everything will installed
>on the same machine, so everything will be local.
>
>Thanks in advance.
>
>--Dwayne--

Received on Mon Mar 13 2000 - 14:56:27 CST