Re: Looking for working SQL*Net on Oracle 7.1/NT (x86)

From: Paul Christopher <uczmpac_at_ucl.ac.uk>
Date: 1996/02/06
Message-ID: <311786AF.2B90_at_ucl.ac.uk>#1/1

Kees Verruijt wrote:

> 
> Sardara Brar wrote:
> > Timo Feickert <timo> wrote:
> > >hello world,
> > >
> > >who is successfully using SQL*Net V2 from Windows-Client to Oracle 7.1
> > >on x86 Windows-NT?
> > >Would you share your "winning" listener.ora, sqlnet.ora, tnsnames.ora
> > >(names.ora ?) files with me?
> > >[ cut ]

The below works, more or less the sample files as supplied.

Oracle 7.1.3.3.6A Server (Enterprise 90day...

TCP/IP Adapter 2.1.3.0.0
SQL*Net Client 2.1.3.0.0
SQL*Net Server 2.1.3.0.0

NT 3.51 WS c/w Service Pack 3, P120 with 32MB Ram, also ran ok with NT newshell.  

################


# Filename......: listener.ora

# Node..........: msg.world
# Date..........: 24-MAY-94 13:23:20

################

LISTENER =
  (ADDRESS_LIST =

        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= orcl.world)
        )
        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= ORCL)
        )
        (ADDRESS = 
          (COMMUNITY = msg.world)
          (PROTOCOL = TCP)
          (Host = 127.0.0.1)
          (Port = 1525)
        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCL)
    )
  )
PASSWORDS_LISTENER = (oracle)

################


# Filename......: sqlnet.ora

# Node..........: local.world
# Date..........: 24-MAY-94 13:23:20

################

TRACE_LEVEL_CLIENT = OFF
sqlnet.expire_time = 2147483647
names.default_domain = world

name.default_zone = world
netman.trace_level=off
netman.trace_file=netman
netman.trace_directory=I:\ORANT\network\trace

################  


# Filename......: tnsnames.ora

# Node..........: msg.world
# Date..........: 24-MAY-94 13:23:20

################

orcl.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 
          (COMMUNITY = msg.world)
          (PROTOCOL = TCP)
          (Host = 127.0.0.1)
          (Port = 1525)
        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
orcl_seq.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 
          (COMMUNITY = msg.world)
          (PROTOCOL = TCP)
          (Host = MISUS)
          (Port = 1526)
        )

    )
    (CONNECT_DATA = (SID = A701)
    )
  )

############# Oracle.ini includes ######## [Oracle]
TCP_PORT=1525 ############# Above must also be in the services file Received on Tue Feb 06 1996 - 00:00:00 CET