ora-12514

在orcal的配置过程中 经常会出现监听的问题  也让人 很恼火

今天 listner的配置都是ok的 

可是

sqlplus systm/system 是ok的

但是sqlplus system/sysetem@orcl就不可以 ora-12514的错误

 

后来 发现是环境变量的问题

在listener.ora中 添加 全局的服务解析 

 (SID_DESC =
       (GLOBAL_DBNAME = ORCL)
       (ORACLE_HOME = E:/oracle/product/10.1.0/Db_1)
       (SID_NAME = ORCL)
      )

 

 

添加后

# listener.ora Network Configuration File: E:/oracle/product/10.1.0/Db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:/oracle/product/10.1.0/Db_1)
      (PROGRAM = extproc)
    )

 

  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

 

 

这样就ok了