Oracle 8.0.5 on Linux and Remote database

From: Michael Madore <mmadore_at_blarg.net>
Date: Sat, 07 Nov 1998 14:37:51 -0800
Message-ID: <3644CBBF.71C38347@blarg.net>

I don't know if this is a Linux specific question, but I am having trouble connecting to a remote database from Linux using SQLPlus.

Here is a copy of my tnsnames.ora file:

################
# Filename......: tnsnames.ora
# Name..........: LOCAL_REGION.world

# Date..........: 28-FEB-98 11:10:45

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

SGHDTA.world =
  (DESCRIPTION =

        (ADDRESS =


          (COMMUNITY = TCP.world)


          (PROTOCOL = TCP)


          (Host = homer)


          (Port = 1521)


        )
      (CONNECT_DATA =
        (SID = ORCL)
           (GLOBAL_NAME = SGHDTA.world)
      )

  )

(Port = 1521)

        )
      (CONNECT_DATA =
        (SID = ORCL)
           (GLOBAL_NAME = SGHDTA.world)
      )

  )

If I execute tnsping SGHDTA, I get a response from the remote listener.

If I execute this, however:

sqlplus system/manager_at_SGHDTA

I get:

ERROR:
ORA-12545: Connect failed because target host or object does not exist

If I set TWO_TASK = SGHDTA, then I get this instead:

ERROR:
ORA-12571: TNS:packet writer failure

I have only installed the client portion of the Oracle software on this machine. I am trying to talk to a UnixWare box running Oracle 7.3.2.

Mike Madore
Systems Manager
Sun Gro Horticulture, Inc. Received on Sat Nov 07 1998 - 16:37:51 CST