跟大家讲解下有关ORA-12514问题解决,相信小伙伴们对这个话题应该也很关注吧,现在就为小伙伴们说说ORA-12514问题解决,小编也收集到了有关ORA-12514问题解决的相关资料,希望大家看到了会喜欢。
本机安装Oracle后链接测试发现以下情况:sqlplus scott/tiger 正常登陆,sqlplus scott/tiger@orcl 登陆失败,提示ORA-12514错误
版本:11.2.0.1.0 - 64bit
本机安装Oracle后链接测试发现以下情况:
sqlplus scott/tiger 正常登陆
sqlplus scott/tiger@orcl 登陆失败,,提示ORA-12514错误,应该是无法识别服务名ORCL
为此查阅资料,找到以下解决方案:
-------------------------------------------------------------------
找到oracle安装目录下listener文件:
原文件如下:
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = d:\app\Administrator\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS ="EXTPROC_DLLS=ONLY:d:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) )
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = idylan)(PORT = 1521)) ) )
ADR_BASE_LISTENER = d:\app\Administrator
修改后如下:
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = d:\app\Administrator\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS ="EXTPROC_DLLS=ONLY:d:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = d:\app\Administrator\product\11.2.0\dbhome_1) (SID_NAME = ORCL) ) )
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = idylan)(PORT = 1521)) ) )
ADR_BASE_LISTENER = d:\app\Administrator
保存,后sqlplus scott/tiger@orcl 可正常登陆。
--------------------------
dylan presents.
相关阅读:
GoldenGate不使用数据泵完成Oracle-Oracle的双向复制
使用GoldenGate的数据泵进行Oracle-Oracle的单向复制
如何对 Oracle 数据泵(expdp/impdp) 进行 debug
Oracle 数据库导出数据泵(EXPDP)文件存放的位置
Oracle 10g 数据泵分区表的导出
来源:php中文网