ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

I'm having trouble connecting to my new Oracle 10g (on Red Hat Linux) server. When I try to connect from the command line locally I can.

$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Sep 19 16:51:20 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect temple/N3urosci3nc3
Connected.

But if I try the same thing with the fully-qualified domain name and port, it fails:

SQL> connect temple@developmentserver.domain.com:1521
Enter password:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Here is a copy of my listener.ora

# listener.ora Network Configuration File: /opt/oracle/102/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER0 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = developmentserver.domain.com)(PORT = 1521))
  )

SID_LIST_LISTENER0 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/102)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = temple.developmentserver.domain.com)
      (ORACLE_HOME = /opt/oracle/102)
      (SID_NAME = TEMPLE)
    )
  )

TRACE_LEVEL_LISTENER0 = USER

PASSWORDS_LISTENER0= (B44576B593A635F3)


Here is a copy of my tnsnames.ora

# tnsnames.ora Network Configuration File: /opt/oracle/102/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

TEMPLE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = developmentserver.domain.com)(PORT = 1521))
      (LOAD_BALANCE = yes)
    )
    (CONNECT_DATA =
      (SERVICE_NAME = temple)
      (SERVER = DEDICATED)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )


Here is the LSNRCTL STATUS

LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                19-SEP-2008 16:43:22
Uptime                    0 days 0 hr. 13 min. 47 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/102/network/admin/listener.ora
Listener Log File         /opt/oracle/102/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=developmentserver.domain.com)(PORT=1521)))
Services Summary...
Service "temple.developmentserver.domain.com" has 1 instance(s).
  Instance "temple", status READY, has 1 handler(s) for this service...
Service "templeXDB.developmentserver.domain.com" has 1 instance(s).
  Instance "temple", status READY, has 1 handler(s) for this service...
Service "temple_XPT.developmentserver.domain.com" has 1 instance(s).
  Instance "temple", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
Start Free Trial