D2K connect to Oracle8 database

From: John Chiu <johnchiu_at_ican.net>
Date: Sat, 09 May 1998 06:51:38 -0400
Message-ID: <3554353A.B6686E39@ican.net>

I try to connect D2K to Oracle8 database but I encounter a fatal erroras follows:

Assume my host name is JOHNCHIU

My c:\windows\hosts file has the following one line: (127.0.0.1 JOHNCHIU) [by the way, this file does not exist, so I create it with one line as shown above]

orawin95\net80\admin\listener.ora has the following details:

LISTENER =
(ADDRESS_LIST =

        (ADDRESS =


          (PROTOCOL = TCP)


          (Host = JOHNCHIU)


          (Port = 1521)


        )
        (ADDRESS =


          (PROTOCOL = TCP)


          (Host = JOHNCHIU)


          (Port = 1526)


        )

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

and my tnsnames.ora file contains:

Tcp-loopback.world =
  (DESCRIPTION =
    (ADDRESS =
(PROTOCOL = TCP)
(HOST = 127.0.0.1)
(PORT = 1521)

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
what.world =
  (DESCRIPTION =
    (ADDRESS =
(PROTOCOL = TCP)
(HOST = JOHNCHIU)
(PORT = 1521)

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )

I run lsnrctl80 and start.
I receive a fatal error when starting tnslsnr80 with the following messages displayed:
TNSLSNR80 for 32-bit Windows: Version 8.0.3.0.0 - Production on 08-MAY-98 11:14:17 (c) Copyright 1997 Oracle Corporation. All rights reserved.

System parameter file is D:\ORAWIN95\net80\admin\listener.ora Log messages written to D:\ORAWIN95\net80\log\listener.log

Attempted to listen on:
(DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(Host=JOHNCHIU)(Port=1521)))

TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist

32-bit Windows Error: 1001: Unknown system error

I know the connection error is due to undefined host but my my local host name is JOHNCHIU and defined in Win95.

Please advise me about the possibilities.

Thanks.

John
johnchiu_at_ican.net Received on Sat May 09 1998 - 05:51:38 CDT