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

[oracle@oracle01 ~]$ sh oracle.sh start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 24-MAY-2009 17:25:43

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=oracle01)(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                24-MAY-2009 17:25:44
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
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=oracle01)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", 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 ................................. started.
------------------------------------------------------------------
Logs are generated in directory /opt/oracle/product/10.2.0/db_1/oracle01_ATYU30/sysman/log
iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
Starting iSQL*Plus ...
iSQL*Plus started.
oracle start up is ok!
[oracle@oracle01 ~]$ netstat -ant
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address               Foreign Address             State      
tcp        0      0 127.0.0.1:2208              0.0.0.0:*                   LISTEN      
tcp        0      0 0.0.0.0:2049                0.0.0.0:*                   LISTEN      
tcp        0      0 0.0.0.0:3938                0.0.0.0:*                   LISTEN      
tcp        0      0 0.0.0.0:1158                0.0.0.0:*                   LISTEN      
tcp        0      0 0.0.0.0:5802                0.0.0.0:*                   LISTEN      
tcp        0      0 0.0.0.0:5580                0.0.0.0:*                   LISTEN      
tcp        0      0 0.0.0.0:5902                0.0.0.0:*                   LISTEN      
tcp        0      0 0.0.0.0:111                 0.0.0.0:*                   LISTEN      
tcp        0      0 0.0.0.0:5520                0.0.0.0:*                   LISTEN      
tcp        0      0 0.0.0.0:1521                0.0.0.0:*                   LISTEN      
tcp        0      0 0.0.0.0:6002                0.0.0.0:*                   LISTEN      
tcp        0      0 0.0.0.0:54324               0.0.0.0:*                   LISTEN      
tcp        0      0 0.0.0.0:854                 0.0.0.0:*                   LISTEN      
tcp        0      0 0.0.0.0:5560                0.0.0.0:*                   LISTEN      
tcp        0      0 127.0.0.1:25                0.0.0.0:*                   LISTEN      
tcp        0      0 0.0.0.0:794                 0.0.0.0:*                   LISTEN      
tcp        0      0 0.0.0.0:988                 0.0.0.0:*                   LISTEN      
tcp        0      0 127.0.0.1:2207              0.0.0.0:*                   LISTEN      
tcp        0      0 127.0.0.1:3938              127.0.0.1:38415             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:56836             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:56843             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:59166             TIME_WAIT   
tcp        0      0 127.0.0.1:60573             127.0.0.1:1521              TIME_WAIT   
tcp        0      0 127.0.0.1:60574             127.0.0.1:1521              TIME_WAIT   
tcp        0      0 127.0.0.1:60575             127.0.0.1:1521              TIME_WAIT   
tcp        0      0 127.0.0.1:60578             127.0.0.1:1521              TIME_WAIT   
tcp        0      0 127.0.0.1:60579             127.0.0.1:1521              TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:63259             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:64553             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:21556             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:62007             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:64566             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:50739             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:56889             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:46917             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:46145             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:20034             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:40013             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:15950             TIME_WAIT   
tcp        0      0 127.0.0.1:55675             127.0.0.1:1158              TIME_WAIT   
tcp        0      0 127.0.0.1:55679             127.0.0.1:1158              TIME_WAIT   
tcp        0      0 127.0.0.1:55676             127.0.0.1:1158              TIME_WAIT   
tcp        0      0 127.0.0.1:55701             127.0.0.1:1158              TIME_WAIT   
tcp        0      0 127.0.0.1:55700             127.0.0.1:1158              TIME_WAIT   
tcp        0      0 127.0.0.1:55683             127.0.0.1:1158              TIME_WAIT   
tcp        0      0 127.0.0.1:55682             127.0.0.1:1158              TIME_WAIT   
tcp        0      0 127.0.0.1:55680             127.0.0.1:1158              TIME_WAIT   
tcp        0      0 127.0.0.1:55686             127.0.0.1:1158              TIME_WAIT   
tcp        0      0 127.0.0.1:55685             127.0.0.1:1158              TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:8801              TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:64354             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:55413             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:35703             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:49784             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:44679             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:47754             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:60573             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:60572             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:60575             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:60574             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:60581             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:60580             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:60577             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:60576             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:60579             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:60578             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:60589             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:60591             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:60592             TIME_WAIT   
tcp        0      0 127.0.0.1:55291             127.0.0.1:57184             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:9157              TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:42447             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:38857             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:64991             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:12520             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:8683              TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:16637             TIME_WAIT   
tcp        0      0 127.0.0.1:1521              127.0.0.1:31482             TIME_WAIT   
tcp        0      0 :::80                       :::*                        LISTEN      
tcp        0      0 :::6002                     :::*                        LISTEN      
tcp        0      0 :::22                       :::*                        LISTEN      
tcp        0   5208 ::ffff:192.168.2.60:22      ::ffff:192.168.2.125:34359  ESTABLISHED
[oracle@oracle01 ~]$ !sql
sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 24 17:28:06 2009

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

SQL> conn sys/sys123@ATYU30 as sysdba;
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


SQL> quit    
[oracle@oracle01 ~]$ ls
Desktop  oracle.sh  sqlnet.log
[oracle@oracle01 ~]$ cat sqlnet.log


***********************************************************************
Fatal NI connect error 12514, connecting to:
 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle01)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ATYU30)(CID=(PROGRAM=sqlplus)(HOST=oracle01)(USER=oracle))))

  VERSION INFORMATION:
        TNS for Linux: Version 10.2.0.1.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production
  Time: 24-MAY-2009 17:28:22
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12564
    TNS-12564: TNS:connection refused
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
[oracle@oracle01 ~]$
处理办法:
在 /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
中添加
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (SID_NAME = ATYU30)
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle01)(PORT = 1521))
    )
  )

重新启动 lsnrctl
[oracle@oracle01 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 24 17:57:53 2009

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

SQL> conn sys/sys123@ATYU30 as sysdba;
Connected.
SQL>