ARG! Cannot resolve service name?????

From: Chuck Carson <chuckc_at_clinicomp.com>
Date: Mon, 12 Nov 2001 09:46:05 -0800
Message-ID: <oVTH7.55$xW4.198763@news.uswest.net>

I have an 8.17 database running on Slaris 2.8. Here is the listener.ora file:
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = becka)(PORT = 1521))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )

    )
  )
SID_LIST_LISTENER =
 (SID_LIST =
   (SID_DESC =

     (SID_NAME = PLSExtProc)
     (ORACLE_HOME = /u01/app/oracle/product/8.1.7)
     (PROGRAM = extproc)

   )
 )

The listener is running and I verified with netstat that it is indeed listenening on port 1521.

I am trying to connect from a Win2K and Red Hat 7.2 machine with the 8.1.7 client and I keep getting this:
ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

Here is the tnsnames.ora file on the Red Hat machine: ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

I am trying to connect as this:
sqlplus chuck_at_BECKA_OPS1
I have also tried numerous other connection strings.

On the Win2K machine I used the Net8 Config util to create the tnsnames file and same error. If I use tnsping, it works. The database host, becka, is in all system's hostsfile, both as a FQDN and as the alias becka. I have verified that it is pingable based on hostname.

Anyone have any ideas?

Thanks greatly,
Chuck Received on Mon Nov 12 2001 - 11:46:05 CST