在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)
)
在监听器的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)
)