ORA-12514: TNS:listener does not currently know of

问题：
[oracle@backup bin]$ /opt/oracle/product/10.2.0/db_1/bin/sqlplus sys/123456@ATYU30 as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 29 15:24:32 2009

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

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


Enter user-name:

处理过程：

[oracle@backup ~]$ sh oracle.server.sh start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-DEC-2009 15:40:37

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

Starting /opt/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /opt/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                29-DEC-2009 15:40:38
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /opt/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "ATYU30" has 1 instance(s).
  Instance "ATYU30", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Failed to auto-start Oracle Net Listene using /ade/vikrkuma_new/oracle/bin/tnslsnr
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.

Starting Oracle Enterprise Manager 10g Database Control ...............OC4J Configuration issue. /opt/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_backup.oracle_ATYU30 not found.
iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
getnameinfo failed
getnameinfo failed
Starting iSQL*Plus ...
iSQL*Plus started.
sqlplus sys/123456 as sysdba
startup
oracle start up is ok!
[oracle@backup ~]$ sqlplus sys/123456@ATYU30 as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 29 15:42:06 2009

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

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


Enter user-name: sys
Enter password:
rlwrap: Oops, segfault -  this should not have happened!
If you need a core dump, re-configure with --enable-debug and rebuild
Resetting terminal and cleaning up...
[oracle@backup ~]$ sh oracle.server.sh stop
Shoutdown Oracle:
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-DEC-2009 15:42:13

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
TZ set to PRC
EM Configuration issue. /opt/oracle/product/10.2.0/db_1/backup.oracle_ATYU30 not found.
iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
getnameinfo failed
getnameinfo failed
Stopping iSQL*Plus ...
iSQL*Plus stopped.
sqlplus sys/tpark123 as sysdba
shutdown immediate
[oracle@backup ~]$ sh oracle.server.sh start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-DEC-2009 15:44:30

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

Starting /opt/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /opt/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=backup.oracle)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                29-DEC-2009 15:44:30
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /opt/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=backup.oracle)(PORT=1521)))
Services Summary...
Service "ATYU30" has 1 instance(s).
  Instance "ATYU30", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Failed to auto-start Oracle Net Listene using /ade/vikrkuma_new/oracle/bin/tnslsnr
TZ set to PRC
OC4J Configuration issue. /opt/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_backup.oracle_ATYU30 not found.
iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
getnameinfo failed
getnameinfo failed
Starting iSQL*Plus ...
iSQL*Plus started.
sqlplus sys/123456 as sysdba
startup
oracle start up is ok!
[oracle@backup ~]$