Oracle10g 中配置连接ora-12514的错误处理

在oracle10g中通过sqlplus链接数据库时报ora-12514错误，记录一下处理过程：

在监听器的listener.ora中
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/10gR1)
      (PROGRAM = extproc)
    )
  )
添加
  (SID_DESC =
       (GLOBAL_DBNAME = ora10g)
       (ORACLE_HOME = /opt/oracle/product/10gR1)
       (SID_NAME = ora10g)
      )

最终成为
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/10gR1)
      (PROGRAM = extproc)
    )
  (SID_DESC =
       (GLOBAL_DBNAME = ora10g)
       (ORACLE_HOME = /opt/oracle/product/10gR1)
       (SID_NAME = ora10g)
      )