Re: TNS unable to connect to destination

From: Frank <fbortel_at_hotmail.com>
Date: 2000/07/26
Message-ID: <397ECEB2.6FBA5A86@hotmail.com>#1/1

Forget about listeners on a single machine!

my tnsnames.ora has:
Beq-local.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (PROTOCOL = BEQ)

          (PROGRAM = oracle80)

          (ARGV0 = oracle80ORCL)

          (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')

        )

    )
    (CONNECT_DATA = (SID = DES2)
    )
  )

And, without a listener, I can use svrmgr30, and plus80: C:\>plus80 scott/tiger

SQL*Plus: Release 8.0.5.0.0 - Production on Wed Jul 26 13:34:42 2000

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Connected to:
Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production PL/SQL Release 8.0.5.2.0 - Production

Just make sure ORACLE_SID is set in HLKM/Software/Oracle, and the NT OracleService is started. Received on Wed Jul 26 2000 - 00:00:00 CDT