Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How connect Oracle under TCP/IP

How connect Oracle under TCP/IP

From: J.Golovaty <golovaty_at_crs.ch>
Date: 1996/11/11
Message-ID: <32873020.5F25@crs.ch>#1/1

Hello,
Who can tell me how to connect under TCP/IP?

EasyCfg generated the following LISTENER.ORA and TNSNAMES.ORA configuration:

LISTENER =
  (ADDRESS_LIST =

     (ADDRESS = 

(PROTOCOL = IPC)
(KEY = IO_LSNR)
) (ADDRESS =
(PROTOCOL = SPX)
(SERVICE = IO_LSNR)
) (ADDRESS =
(PROTOCOL = TCP)
(HOST = io)
(PORT = 1521)
)

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCL)
      (ORACLE_HOME = VOL1:ORANW732)

    )
  )
#EZCFG_VER=1.1.0.0.0
--------------------TNSNAMES---------------------------
IO-IPC.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS =
         (COMMUNITY = ipc.world)
         (PROTOCOL = IPC)
         (KEY = IO_LSNR)
       )

    )
    (CONNECT_DATA =
(SID = ORCL)

    )
  )
IO-SPX.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS =
         (COMMUNITY = spx.world)
         (PROTOCOL = SPX)
         (SERVICE = IO_LSNR)
       )

    )
    (CONNECT_DATA =
(SID = ORCL)

    )
  )
IO-TCP.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS =
         (COMMUNITY = tcp.world)
         (PROTOCOL = TCP)
         (Host = io)
         (Port = 1521)
       )

(ADDRESS =
(COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = io) (Port = 1526) )

    )
    (CONNECT_DATA =
(SID = ORCL)

    )
  )
#EZCFG_VER=1.1.0.0.0 Under SPX/IPX I can connect using alias IO-SPX but IO-TCP returns General connect error.

Both aliases exsist on server and client TCP/IP on my server works because I can ping IO(my server host) and browse my DB using Netscape and Oracle Web on server side. I tried to set ports 1521 and 1526 in their SERVICE files, nothing helps.
What I'm doing wrong?
I run Oracle7.3 under Netware 4.x and client under win95 Received on Mon Nov 11 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US