ora12514

在linux（centos5.3）系统下，登录oracle数据库时提示ORA-12514错误

[oracle@localhost dbs]$ sqlplus sys/qaz@orcl as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 11 22:25:25 2012

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

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

Enter user-name:

解决方法：在lisener.ora文件中增加如下一段
SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /oradata/oracle/112)
      (PROGRAM = extproc)
    )
   (SID_DESC =
    (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = /oradata/oracle/112)
      (SID_NAME = orcl)
    )

如果监听文件已经有了SID_LIST_LISTENER，只要相应的修改下就可以了。
注：一定要重启监听服务