在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,只要相应的修改下就可以了。
注:一定要重启监听服务

posted on 2012-04-12 11:30  蓝紫  阅读(369)  评论(0编辑  收藏  举报